This will be used to automated emails that remind customers of past due balances.
I require the ability to automate the creation of emails, and their delivery, based on detail I house in an Access database. The tables nor criteria are complicated in nature. I do not require the ability to RETRIEVE any data from said emails, but I do require that certain rows of information are place in the body of the emails.
Table 1 is a list of all the Customers. There is Customer name, Type, and Email adress(es).
Table 2 is the listing of all unpaid balances by month. There is Customer name, Type, Invoice Date, and Balance Due.
I need one email to be sent to each contact listed for each Customer, and in the body of the email to have a row for each past due balance.
I also need the ability to have a template email for each TYPE of customer. So that if a customer is TYPE A, then they get a specific email, and if they are TYPE B, they get a specific email type. Customers that have past due balances for each type, should get 2 difference emails.
I would consider an excel solution if that is easier.