PDF converter

[Jozo]

Dear All!!!

I have MS Office 2007...
Please can you tell me is possible that I convert one of my report in PDF format and after that insert as attach file in e-mail.... (automatically)
I tried this code but it is wrong...
DoCmd.SendObjec t _ acSendReport, _ "Sales By Order", _ acFormatPDF, _ "ToJohn@ doe.com", _ , _ , _ "Subject", _ "Message", _ False ...

Thank you in advance!

Rgds,
Jozo

[cwby1966]

I believe your code is correct but you need to make sure you have the PDF add on installed
Link
Download details: 2007 Microsoft Office Add-in: Microsoft Save as PDF or XPS