Emailing an Access Report Using "With OutMail"

[Tom Glasser]

Hi Folks,
I am trying to automate the emailing of an Access report, avoiding any
human intervention. I have automated emails in the past using the
"With OutMail" construct, but not involving Access report or query objects.
So my question is this: Is there an easy way with this approach to attach
an Access report to the email, or include it in the body?

Thanks,
Tom

 

[Daniel Pineault]

Nothing could be simpler.

DoCmd.SendObject.

Look it up in the help file of all the details and examples.

 

[m stroup]

Do you mind if I tage another question? I am using DoCmd.sendobject and it
works beautifully. I cannot, however, figure out how to send to multiple
recipients within the to argument.

 

[Douglas J. Steele]

Use a single string value holding all of the e-mail ids, separated by
semi-colons.

From the Help file:

DoCmd.SendObject acSendTable, "Employees", acFormatXLS, _
"Nancy Davolio; Andrew Fuller", "Joan Weber", , _
"Current Spreadsheet of Employees", , False

 

[Tom Glasser]

Hi Daniel,

That works. Thanks!

Tom

Nothing could be simpler.

DoCmd.SendObject.

Look it up in the help file of all the details and examples.