Send multiple reports on a singe email

[Michael Marquardt]

I have reports that I run daily and send out via email. I currently use a
macro that uses the send object command to do this, however it creates a new
email for each report. I want to be able to have all of the reports on a
singe email, I know I will probably have to move from a macro to some VBA but
I do not know where to start. I have seen some code to do this if using
Outlook but my email is done using Lotus Notes. I would appreciate any help
you can give me. Thanks in advance for your assistance.
Mike Marquardt

 

[Steve Schapel]

Michael,

I don't know if this will help, as it involves some manual intervention.
But you could replace the SendObject action in your macro with an
OutputTo action, for all but the last of the reports. That way all the
reports will be saved to disk. With the last report, leave it as a
SendObject, and set the Edit Message argument to Yes, which should cause
the email client to open with the email with the last report already
attached, and then all you need to do is attach all the others before
sending.

 

[vseale]

If you're still struggling with this check out this link -
http://www.access-programmers.co.uk/forums/index.php?

Under Code Repository go to "Sending Email Via Lotus Notes"
I found this code to be very flexible and easy to implement. I can send
multiple emails with multiple attachments with it.