email invoices as attachments

[colin]

Hi,

I have a billing database that contains the following:

Accountnumber, emailaddress, invoicenumber,and a field containing a
hyperlink to the pdf invoice.

I would like to automatically email the invoices to the customer but can
find any code examples of how this is done.

Many thanks

Colin

 

[Tony Toews [MVP]]

I have a billing database that contains the following:

Accountnumber, emailaddress, invoicenumber,and a field containing a
hyperlink to the pdf invoice.

I would like to automatically email the invoices to the customer but can
find any code examples of how this is done.

Do you want to email the invoices as the body of the email or as PDF
attachments?

To create a formatted document to send as an email you will need to
use VBA code to create a largish string. This string will then be
passed to the SendObject command or other method as the body of the
email. For more details including sample air code see my Tips page
on this topic at http://www.granite.ab.ca/access/email/formatted.htm.

For a page on how to print a report for a single record and how to
generate reports to attach to emails see the Emailing reports as
attachments from Microsoft Access page at
http://www.granite.ab.ca/access/email/reportsasattachments.htm

Also see Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony