Email with Access report as attachment

[kmims44]

This didn't work for me at all. I have a form "PRF" with an attachment field "Field1". I have a command button that runs a report based on that form "PR" and attaches the report to an email no problem. What I want is for it to not only attach the report but attach any files in "Form!Field1" as pdfs as well.

[June7]

I split your post to a new thread.

The topic of thread (https://www.accessforums.net/access/...ail-24962.html) you posted in is about attaching to email files from table Attachment field. Attaching an Access database report to email is another topic and has been discussed. Search forum or web.

If I remember right, since you want to send additional attachments, the SendObject method will not be suitable.

Will need code to save the report as PDF then attach the PDF to email as well as the other files you want to transmit. Review https://www.accessforums.net/import-...ges-25042.html
https://www.accessforums.net/access/...pdf-25574.html