Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Emails in Access 2010

Author  Topic 

Controller1
Starting Member

8 Posts

Posted - 2013-08-25 : 14:15:25
I need to send emails to customers with unpaid invoices report in access 2010. How can i automate this process in access? i want to send one email per customer. i also use Outlook as email.

I have six customers A, B, C, D, E, F in the Report. I also have customers table with emails.

Invoice report
INVOICE CUSTOMER
8 A
9 A
10 A
11 A
12 B
13 B
14 C
15 C
16 D
17 E
18 E
19 E
20 F
21 F
22 F

Customera table
CUSTOMER email
A A@mail.com
B B@mail.com
C C@mail.com
D D@mail.com
E E@mail.com
F F@mail.com

   

- Advertisement -