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

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?
 
S

Steve Schapel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

E-Mail A Report 1
Mail Pop-up Message 6
SendObject HOW CAN I SEND TWO REPORTS IN THE SAME MAIL WITH 1
Send an e-mail from the e-mail address in a Form 1
SendObject - Two Email pages 4
Using Query Field to name SendObject file 3
How to send query results via email (not outlook) in Excel format 1
Send Object to e-mail 4

Top