Microsoft Outlook

Question

Hi,

I have a databse that automatically e-mails certain documents when they are created in the background. The user does not even know that the document is mailed.

We are using Outlook Exchange server, but I have a problem when the server is down. The VBA code tries to mail, but because the server is down, it stays in a "loop" and it looks like the program has frozen and does not continue with the next form.

Is there a way to save this e-mail in Outlook when the server is down and mail it as soon as the server is up and running again and continue with the execution of the next procedure?

Thanks

Deon

Answer 1

tricky.  maybe invoke a timer.  not sure the email can be saved as an object......maybe set a flag field in an appropriate table as unsent.  then rely on that flag field.  but potentially lots of nitty gritty issues in triggering the resend attempt depending on User ID stuff and data structure....

Answer 2

>>>Is there a way to save this e-mail in Outlook when the server is down and mail it as soon as the server is up and running again and continue with the execution of the next procedure?

According to your description, I suggest that you could enable Cached Exchange Mode. If you work offline, whether by choice or due to a connection problem, your data is still available to you instantly wherever you are. If a connection from your computer to the server running Exchange isn't available, Microsoft Office Outlook switches to Trying to connect or Disconnected. If the connection is restored, Microsoft Office Outlook automatically switches back to Connected or Connected (Headers). Any changes you make while a connection to the server isn't available are synchronized automatically when a connection is available. You can continue to work while changes are synchronized.

How to turn Cached Exchange Mode on, please refer to steps below:

1.On the Tools menu, clickAccount Settings.

2.On the E-mail tab, click the Exchange Server account, and then click Change.

3.Under Microsoft Exchange server, select the Use Cached Exchange Mode check box.

4.Exit and restart Office Outlook.

For more information, click here to refer about Turn on or off Cached Exchange Mode