|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
This appears to be a Many to One merge - see Merge Many To One
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#3
|
|||
|
|||
Seriously, thanks!
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula to format "I" column based on if "F" column row is not blank | ravl13 | Excel | 3 | 08-22-2017 12:26 PM |
Word 2013's Navigation Pane does not show "level 4" headings, even when I click "Show Heading 4" | zrcarlson | Word | 1 | 10-26-2016 09:51 AM |
How to show "Names" only of people I'm allowed to "Send As" | ravl13 | Outlook | 0 | 02-11-2016 12:44 PM |
How to edit the "Format" and the "show level" of an EXISTING table of content? | Jamal NUMAN | Word | 2 | 08-14-2011 10:46 AM |
How to add a "note" which is "active" when doing a powerpoint show | Anders | PowerPoint | 0 | 01-22-2011 08:47 AM |