Sending out invoices electronically

  • Thread starter Thread starter joev30
  • Start date Start date
J

joev30

I have a customer data base that creates a printed monthly invoices for each
customer. I would like to send the invoices electronically via email to each
customer. How would I go about doing that?

Thanks
 
joev30 said:
I have a customer data base that creates a printed monthly invoices for
each
customer. I would like to send the invoices electronically via email to
each
customer. How would I go about doing that?

I've done the same thing with purchase orders having to send out as many as
2,000 a week. I used Win2PDF:

http://www.win2pdf.com

to print the reports directly. and the Access The PDF and Mail Class Library
by Steve Arbaugh to do any merging and mailing:

http://www.groupacg.com/
 
joev30 said:
I have a customer data base that creates a printed monthly invoices for each
customer. I would like to send the invoices electronically via email to each
customer. How would I go about doing that?

You will need to create a query containing the customer ID and email
address. And loop through the recordset creating a PDF file for each
customer which you will then email.

See the Sample Code illustrating looping through a DAO recordset page
at the Access Email FAQ at
http://www.granite.ab.ca/access/email/recordsetloop.htm

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

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Back
Top