Send an email

[Guest]

I want to send an email after a process has completed. (We use Outlook on an
MS Exchange server) I used the following code and got the email pop up but I
have to click the send button to actually send it out. Is there a way to set
it up so that it actually sends the amil?

 

[Guest]

Oops I forgot to include the code line

DoCmd.SendObject acSendNoObject, , , "(e-mail address removed)", , ,
"Walmart TB updated", "The Walmart Trial Balance has been updated"

 

[Guest]

The SendObject method carries out the SendObject action in Visual Basic.

expression.SendObject(ObjectType, ObjectName, OutputFormat, To, Cc, Bcc,
Subject, MessageText, EditMessage, TemplateFile)

 

[Rick B]

Note that the "EditMessage" is the part you need to adjust.