Can I send A File With SendObject?

[geraldcor]

I have created a module that will print my report to PDF. I want to automatically send that PDF report from Access. (Haven't found anything on this in the archives yet). Using the SendObjec Command would be great if I could reference a file rather than a report. Any help or suggestions are greatly appreciated. Thanks for all the help

 

[geraldcor]

I have created a module that will print my report to PDF. I want to automatically send that PDF report from Access. (Haven't found anything on this in the archives yet). Using the SendObjec Command would be great if I could reference a file rather than a report. Any help or suggestions are greatly appreciated. Thanks for all the help

I just re-read my post and I forgot some important information. I can print to PDF just fine my problem is I want to be able to send that PDF file as an attachment in an email. I seem to have ommitted that little piece. I know you can do send a specific report as .rtf and such but I am wondering if instead of having the access report destined to the email, I want the specific file location where the PDF report is stored sent as an attachment. It doesn't appear that it will work. But if someone knows a way, (Any way would be helpful) that would be great.