Microsoft Office Forums How do I set it up so that when 1 category wasn't purchased it won't show up "blank" in in my letter

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 10-16-2019, 10:43 PM
gmayor's Avatar
gmayor gmayor is offline 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 Windows 10 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 Office 2016
Expert
 
Join Date: Aug 2014
Posts: 3,008
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
Default

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
Reply With Quote
  #3  
Old 10-17-2019, 07:51 AM
newtothis newtothis is offline 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 Windows 10 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 Office 2010
Novice
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
 
Join Date: Oct 2019
Posts: 2
newtothis is on a distinguished road
Default

Seriously, thanks!
Reply With Quote
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 07:20 AM.


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