send object command -

G

Guest

I am using the send object command in a macro. I can send one report via a
snapshot type, however, i want to send two reports in one email. Basically,
I want to send an email with two attachments (both are reports), one with a
snapshot type and the other a text file. How can I do this?
 
C

Chris Reveille

You can't with a macro. You will have to use the output to
command to save the reports to files and then use vb code
to send them in one email.

Chris
 
S

Steve Schapel

Just to expand upon Chris's suggestion, you can do it like this... In
your macro, use an OutputTo action for the first report, to save the
file to disk. Then use the SendObject action for the second report,
with the Edit Message argument set to Yes. Then, when your email client
opens,with the second report already attached, you can simply manually
attach the first file before sending the email.
 
G

Guest

Thanks for the replys Chris, Steve,
but my users will have a hard time (believe it or not...) following the
"Output to" process, saving it to disc, then attaching it....
I will have to figure out how to write VB to get this to work.
thanks -
 
C

Chris Reveille

I have some VB that will take the Sender, subject, body and
file information from a form(up to five attachments) and
put them in an email. All the user has to do is type in
the file attachment name or you could set up a browse file
in the form.

Chris
 

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

Top