Automated Emailing from Access 2007 Database

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.