Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

HOW CAN I SEND MORE THAN ONE REPORT AT A TIME???

Status
Not open for further replies.

chubby

Programmer
Joined
Apr 28, 2001
Messages
278
Location
US
How can I send two reports via e-mail at the same time?
I made a macro but I can only send one report at a time, is there away around that?

Chubby
 
Hi!

With a macro I think that you are limited to one at a time. Of course, you can put two Send Object actions in the macro to send both reports. In VBA, you should be able to save both reports to Word and then attach both docs to an Outlook email message and send it, but that is considerably more complicated.

hth
Jeff Bridgham
bridgham@purdue.edu
 
Thanks for the tip. I'll use your first tip, placing two send objects in one macro to send both reports.

Thanks [thumbsup]
Smithr023@hawaii.rr.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top