View Single Post
 
Old 09-27-2011, 11:00 AM
bh24524 bh24524 is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Sep 2011
Posts: 10
bh24524 is on a distinguished road
Default mail merge with duplicate names but different dollar amounts

Hello, I am trying to use a mail merge to keep track of donations made to an organization in order to send them letters for tax purposes. I use an excel spreadsheet to keep track of the donor info such as their first/last names, amount donated and a check or reference number to put in the letter. Sometimes I will have people that will make multiple donations in a year. I have one particular donor that does one per month consistently. To default, the mail merge wants to give 12 different letters to that same person. I am wondering how I can make it so it will only give that person one letter which will list all 12 donations. I have heard that it is possible, but it is beyond my knowledge, so any help would be greatly appreciated. Thank you.