Microsoft Office Forums

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: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:19 AM.


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