Email Each Invoice to each customer

[snehal0909]

Hi All,



I have an invoicing database, below is what my database has.

tblInvoices
InvoiceID
CustomerID
InvoiceAmount
InvoiceDate

tblcustomers
CustomerID
Company
BillingEmail1
BillingEmail2

rptInvoice

frmAllInvoices


I have a list of invoices in a datasheet form (fromAllInvoices). I filter them to show only this month's invoices. I Also have a button that says EMAIL INVOICES.
What code do I attach to that button so it automatically emails SELECTED (or filttered in my case) invoices to each customers. It should pick up email address automatically from Customers table.

Any help is appreciated.

[June7]

Use VBA code to open recordset of customers, loop through the recordset and email filtered report to each customer.

Common topic. Search forum and/or Google.

Review
https://www.accessforums.net/reports...ame-21678.html
https://www.accessforums.net/access/...ate-21081.html

[oar4uusa]

I will share it to my blogs.