How to e-mail a report and query in the same e-mail

  • Thread starter Thread starter Angela
  • Start date Start date
A

Angela

How do I e-mail a Report and a query in the sendobject
command? If I put SendObject, with report and then
sendobject with query. It will do the first sendobject
first and you have to send that e-mail before the
sendobject w/ query opens. How do I attach both things
into one e-mail?
 
Angela,

You can't do this in one step with a macro. You could proceed like this...
Use an OutputTo action to export the report, and save in a convenient
location. Then, use your SenbdObject to create the email with the query
attached, and set the Edit Message argument to Yes. Then, you can
manually attach the report file to the email before sending.
 
Back
Top