Automatic Emails on Exchange Server

[mcktigger]

Morning all

I'm hoping someone can point me in the right direction with this as can't find a post that answers my question.

I want to send automatic emails (without user intervention) when a user changes a record. I know how to send emails where Access launches outlook and the user hits send but need certain emails to go without the user doing anything.

We use MS Exchange Server and want to use this for sending the emails. Is this possible and if so could you point me in the direction of code do this.

Many thanks

 

[DavidAtWork]

It is possible to send emails using the Docmd.SendObject method and this doesn't require launching Outlook, the whole process can be performed in the background using VBA, just Google Docmd.SendObject

David

 

[mcktigger]

Hi

Thanks for the reply. I found a solution using:

.display
SendKeys "%{s}", True

This displays the email then momentarily then automatically does the send in Outlook. This avoids the Outlook pop-up warning that is shown when using the .Send option.

Thanks