Emailing an Access Report Using "With OutMail"

  • Thread starter Thread starter Tom Glasser
  • Start date Start date
T

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
 
Nothing could be simpler.

DoCmd.SendObject.

Look it up in the help file of all the details and examples.
 
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.
 
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
 
Hi Daniel,

That works. Thanks!

Tom


Daniel Pineault said:
Nothing could be simpler.

DoCmd.SendObject.

Look it up in the help file of all the details and examples.
Click to expand...
 
Back
Top