Send Object Macro for multiple objects in an e-mail

R

RobertM

Hello:

I've set up a macro that e-mails a report to a recipient. It's just a simple
send object macro. It works fine.

The only problem is that it does a great job of sending one report to one
recipient. We need to be able to send multiple reports to the same recipients.

Any suggestions? Also please keep in mind, I know Access, but my VB and
module knowledge is minimal.

Thank you,
 
S

Steve Schapel

Robert,

One way of doing this, is to use a series of OutputTo actions in your
macro, one for each of the reports, which will save the output of each
report as a file to disk. And then your SendObject macro for the last
of the reports, with its Edit Message argument set to Yes. This will
open the email in your email client, with the last report attached, and
then you can manually attach the other rfeports before sending.

Apart form that, I think you will need to use a VBA procedure rather
than a macro, if you want it more streamlined than that.
 
E

Eric Blitzer

I have a db with an example of what you want to do. It has a form that let's
select up to 5 attachments and select multiple email addresses from your ms
Outlook contacts folfer. If you are interested email me at
g a n d h a w k @ g m a i l . c o m.

Jim
 

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