Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-16-2019, 05:21 PM
newtothis newtothis is offline How do I set it up so that when 1 category wasn't purchased it won't show up "blank" in in my letter Windows 10 How do I set it up so that when 1 category wasn't purchased it won't show up "blank" in in my letter Office 2010
Novice
How do I set it up so that when 1 category wasn't purchased it won't show up "blank" in in my letter
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I set it up so that when 1 category wasn't purchased it won't show up &quot;blank&quot; in in my letter Formula to format "I" column based on if "F" column row is not blank ravl13 Excel 3 08-22-2017 12:26 PM
How do I set it up so that when 1 category wasn't purchased it won't show up &quot;blank&quot; in in my letter 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:10 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft