Sending Files within Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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
 
Back
Top