Automating sending reports as PDF files

[puforee]

The DB I am working on will create two reports that I need attached to an email. I will provide a Partial To: for the email but I need the email to open in the creation window so I can add another To: person. I am looking for code to help me attach the reports to email (Outlook) as PDF files and open the email window so I can add another To:. I know this can be done for a single report when print previewing it. I can then select to email it as a PDF attachment. But, I need to attach multiple reports (just 2 for now).

Can anyone steer me in the right direction?

Thanks,

John

 

[Andrzejek]

You may try this first and if/when you get stuck, come back here and ask specific questions


---- Andy

There is a great need for a sarcasm font.