Multiple Reports in cmd.SendObject

[Steven.Allman]

This code works great to create an email with my report, but I have another report I would like to send, and possibly a third. How can I put in a record seperator, much like ; for email addresses, so that it looks for the second report as well. ; , - '*' none of these work..

DoCmd.SendObject acSendReport, "reportname", "PDF", strTo, "guy@yourmom.com; mail@yourbuddy.com", , "subject", "Text Body", , 0

Any suggestions?

[pbaldy]

You can't send multiple reports in one email with SendObject. You can use automation:

http://support.microsoft.com/?kbid=161088