View Single Post
 
Old 10-16-2019, 05:21 PM
newtothis newtothis is offline Windows 10 Office 2010
Novice
 
Join Date: Oct 2019
Posts: 2
newtothis is on a distinguished road
Smile How do I set it up so that when 1 category wasn't purchased it won't show up "blank" in in my letter

I've done a simple mail merge before where there was only one item for each recipient, pretty straight forward. But now I have to do a mail merge where the recipients have multiple items. I know that my excel sheet rows need to have all the info for each recipient and I know that my merge fields needs to be mapped out on the word document. My issue is that not everyone purchased every item, ie, "Raffle", Fund-A-Need", "Auction Package"...so I don't know how to set up my mail merge so that if a recipient didn't purchase said item, it won't just show up blank as:
'" " for $ , of which $ is tax deductible'...in the bullet points in the thank you letter.

EXAMPLE OF WHAT MY WORD TEMPLATE LOOKS LIKE:

Dear <FIRST_NAME>,

On behalf of our patients, I want to thank you for your contributions through the following items in celebration of our annual event:

“<FUND-A-NEED>” for $<AMOUNT1>, of which $<AMOUNT1> is tax deductible.
“<AUCTION>” for $<AMOUNT2>, of which $<AMOUNT3>is tax deductible.
“<RAFFLE>” for $<AMOUNT4>, of which $<AMOUNT5>is tax deductible.
Reply With Quote