Send Multiple Objects using the SENDOBJECT Method

[Mando13]

I created a SendObject Method which works wonderfully. It creates an email with a report for every manager with only their data.
However I now need to include another report within the same email.
Does anyone know how I can accomplish this?



DoCmd.SendObject acSendReport, "MONTHLY_REPORT", "Snapshot Format(*.snp)", rs("email"), , , "Monthly Report", "Attached is your Monthly Report", False

 

[TheAceMan1]

How are ya Mando13 . . . . .

As far as I know, [blue]you can only send one object per SendObject.[/blue]

If your using Outlook, you can use [blue]DoCmd.OutputTo[/blue] to convert the objects to files, then execute the code at the following link: How to use Automation to send a Microsoft Outlook message

See Ya! . . . . . .

 

[Mando13]

Thanks for you help with this...