Sending Mail from Excel with VBA

**RFraley** · November 3rd 06, 01:53 AM posted to microsoft.public.outlook.program_vba

I have an Excel (2003) VBA application that sends e-mail through our
Exchange server. Everything works fine, but I am looking to address an issue
that is somewhat undesirable with the procedure. The e-mail is sent by
clicking on a command buttom from a userform. As I said; the e-mail is sent
(by the VBA application) correctly. The problem is that the process of
sending the e-mail switches control to Outlook. The user then has to switch
back to the Excel application after the e-mail is sent. This is minor, but
it detracts from the overall professionalism with regard to the appearence
and function of the application. Is it possible to prevent the e-mail code
from switching to Outlook? I'd really like this to be transparent to the end
user. If anyone has a suggestion for how I can improve this situation, I'd
really appreciate some help. Since I don't have much experience with Outlook
and VBA, a code sample would be very helpful.

Thanks in advance
Ralph Fraley

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Editing contacts in a Public Folder from within Excel VBA	Mogge	Outlook - Using Contacts	2	August 28th 06 09:02 PM
mail vba excel	flek	Outlook and VBA	1	June 17th 06 01:40 PM
Problem sending mail via excel	Jas	Outlook and VBA	2	April 8th 06 08:44 PM
Export DL members to Excel CSV with Outlook VBA	[email protected]	Outlook and VBA	0	March 17th 06 08:04 PM
Changing of FROM address when sending emails using VBA	GeorgeMar	Outlook and VBA	2	February 27th 06 07:30 PM