Emailing: MS Outlook closes

[shaunacol]

I am using MS Access 2000 and sending emails with MS Outlook using the code in faq702-2921.

The only problem I have is that MS Outlook closes when the code has run and if Outlook was already open we would like it to stay that way.

I am sure I have seen another question regarding this but have searched and can't find it....

Any help appreciated, thanks.

 

[rene1000]

You have to remove the following three lines of code:

**closes outlook
objOutlook.Quit
Set objEmail = Nothing


this will solve your problem