Access Auto email attach report as PDF

[Shamli]

Hello Everyone,
I wanted to send an automatic email from access through outlook and also I wanted to attach the PDF version of the report.


I am not sure where to start this.!
Can anyone help me on this.

Thanks!

[ranman256]

In a macro or vb code:

docmd.SendObject acSendReport ,"rMyReport",acFormatPDF,sTo,,,sSubj,sBody

[Shamli]

Perfect! It worked!
Is there any way can I prevent the warning message to send the email!
Automatically to be chosen as allow.

In a macro or vb code:

docmd.SendObject acSendReport ,"rMyReport",acFormatPDF,sTo,,,sSubj,sBody