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.
|