Sending out invoices electronically

[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

 

[Arvin Meyer [MVP]]

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/

 

[Tony Toews [MVP]]

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/

 

[Arvin Meyer [MVP]]

Also, if you simply want to attach the snapshot, or another file that you've
already saved (for instance and RTF file which will run in Word) you can use
the code at:

http://www.datastrat.com/Code/MultipleEmail.txt

to email separate attachments to each recipient.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com