Email more than one object using Macro

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

I hope someone can help me with this one issue i have regarding Access Macro.
Here is my case.....
I know how to email out a report using the macro to someone. But, i am
trying to attach more than one report in a single email but i can not figure
that out.
The whole purpose is to eliminate sending out 2 emails to same people for
two different attachment.

Thank you,
 
Jay,

I assume you are using a SendObject macro action.

Sorry, what you are asking is not possible directly.

You can do it like this:
1. Use an OutputTo action to apply to the first report, which will save
it to your computer in a specified location.
2. Use SendObject for the second report, with the Edit Message argument
set to Yes.
3. Your email client will open with the email message all ready with the
second report, and then you have to manually attach the first report, as
per step 1, before Send the email.

Otherwise, I think the only alternative is to use Office Automation
within a VBA procedure, to manipulate the Outlook object.
 
Back
Top