Hello,



I am trying to do a customized mail merge and need some help. Every month we export a list of people who haven't paid there bill into an Excel file. What I'm trying to accomplish is emailing them a letter in Word informing them there service will be disconnected if payment is not made. What I want the Word doc to include is the persons first and last name, amount due, email address and account number. I hope to extract all this information from the excel document and create send an email to each customer with this letter in it.

Any tips?