Sending Files within Access

B

Bill M

I want to send an email a file (PDF style) to a list of users selected from a
query. Is there a way to do that, either by a macro or with VB code? And if
so, how?
 
S

Steve Schapel

Bill,

It is not really practical to do this with a macro. You will need to
use a VBA procedure, to loop through the query's records to build the
"To" list for the email. Is the PDF file a previously existing,
unrelated file? Or do you mean you want to export from your database to
a PDF, and then email that? If the latter, using the SendObject method
may be applicable. Otherwise, you may have to use Office Automation,
assuming you have Outlook. More information on this topic is available
here...
http://www.granite.ab.ca/access/email.htm
 
B

Bill M

Steve:

The PDF file is previously existing, and I have no problem using VBA code
instead, I just don't know how to access the existing PDF file from within my
VBA code. Any help you can provide or a link to a reference would be greatly
appreciated.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Images are pixelated when saving to PDF 0
Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Mail Merge skipping records/sending one at a time 0
Protecting Word 2019 document 0
Printing Outline view - formatting lost 0
Need help modifying code 0

Top