Help with VBA script to Email Attachment data type

What I need you to do is write code that will export the report as a pdf document using DoCmd.OutputTo, then I will incorporate that into your db. Do some research, Google etc.
 
Hi As suggested by you I have created the script to output the report to c:\drive. Now I need to add this report to the email, so that I can email all the attachments as well as the report in one email to the client.
Please help.
I would like to email all the attachments in a particular records as well as email the access report along with the above attachments (all in one email.)
 

Attachments

Thank you very much, you have been a grate help for me. Helping and encouraging beginners to learn and do well is very kind of you.

My application works perfectly now! . I appreciate your patience with my very limited knowledge. Thanks again! :)
 
Hi VbaInet

Few months ago you helped me with the script for emailing attachment from the DB.

I am trying to send an email with the atttachment in the database as well as the Report as PDF. This works fine.


The problem is when there is no attachment, it will not email the report.

Where can I add (and / or) to the script.

1. The email button should email the attachment and the report.
2. If the attachment is not available, then it should only email the report.

Please help
 

Attachments

Last edited:

Users who are viewing this thread

Back
Top Bottom