Custom Mail Merge

[luke]

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?

[macropod]

So what is the issue? Unless you're aiming to send the letter as an attachment, what you're describing is a standard email merge, for which Word provides all the tools you need via its Mailings tab. To send the letter as an attachment, see: http://word.mvps.org/FAQs/MailMerge/...ttachments.htm