sending multiple reports - using send object command

[Guest]

Hello

I would greatly appreciate any assistance - I have some visual basic code
using the send object action/command, and am wondering whether there is a way
to send multiple reports in the one e-mail?

Many thanks in advance

Kind regards
AC

 

[Tony Toews [MVP]]

I would greatly appreciate any assistance - I have some visual basic code
using the send object action/command, and am wondering whether there is a way
to send multiple reports in the one e-mail?

Not using SendObject. That's one of it's many limitations.

For alternatives Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Guest]

Sadly no, SendObject only allows 1 attachment/object to be included. Tony
gave you a great web resource with different alternative technics for sending
email. I have used automating outlook to do this type of task and it works
well! Question being whether you have outlook or not. If so take a look at

http://msdn2.microsoft.com/en-us/li...odc_ac_olauto_sendanoutlookmessageusingaccess

it may also be worth your while to take a look at

http://www.microsoft.com/technet/archive/mail/ml302.mspx?mfr=true