Sending Outlook Email 2

[romh]

I know that there are 90 posts on the send-email from access database, but I could not find the answer to this one. I am sending an email from access but have noticed that the email is not sent if you have Outlook closed. It stores the email in the outbox. I have to open it and manually send the items in my outbox. I need to automate the whole process without having Outlook open all the time. Is it possible?

Thankyou

 

[SoloDroid]

Hello romh,
Absolutely! Check out this thread: thread705-475296. None of the methods that I posted required Outlook to be open.

Though I think that your problem is probably a flag or an option that has not been set properly either in Outlook, or in the code.
Good Luck, Robert
•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•
Professional, affordable, Access database solutions and assistance

http://www.SoloDroid.com

°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°

 

[romh]

Hi, I followed the code on the post that you sent me, but I have the same problem with both the Outlook object and the DoCmd.Sendobject method. The email stays in the outbox until I open Outlook. I cannot find any option in Outlook that automatically sends outbox items. Thanks for any help

romh

 

[Rick39]

This link should help in determining if the app is running or not:

http://www.mvps.org/access/api/api0007.htm

 

[romh]

Thanks for all the help. That web site is very useful. I solved my problem by doing the following in case anybody has the same problem. You have to Open Outlook and go to Tools -> Options ->
Mail Delivery and click where it says (Send Messages immediately when connected). If you are connecting via a LAN, then the mail will be sent automatically disregarding if outlook is open or not. Thankyou