Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-04-2017, 06:53 AM
Laura123 Laura123 is offline Need help suppressing information in a table in a mail merge Windows 7 32bit Need help suppressing information in a table in a mail merge Office 2013
Novice
Need help suppressing information in a table in a mail merge
 
Join Date: Dec 2017
Posts: 1
Laura123 is on a distinguished road
Default Need help suppressing information in a table in a mail merge


I am working on an email merge and part of the body is a table that has text and currency. I need to suppress the information in the row if the value is $0. Is there a way to do this? In the example below I would not want want rows "B" and "D" to appear in the merge. Thanks!

Name Quantity Value
A 15 $45
B 0 $0
C 3 $15
D 0 $0
Reply With Quote
  #2  
Old 12-04-2017, 01:34 PM
macropod's Avatar
macropod macropod is offline Need help suppressing information in a table in a mail merge Windows 7 64bit Need help suppressing information in a table in a mail merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

There are two easy ways of addressing the issue:
1. Use the mailmerge filters; or
2. Use a SKIPIF field,
to exclude the unwanted records.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you mail merge information into Smartart graphics? QCJen Word 0 05-31-2017 08:02 AM
Need help suppressing information in a table in a mail merge How do I mail merge records into table columns with more than one merge field? tech123 Mail Merge 1 04-26-2017 07:13 PM
Skipping row in mail merge table. Mulith Mail Merge 6 10-30-2014 04:32 AM
How to mail merge information in PPT 2010 mschlagel Excel 1 11-08-2012 07:49 PM
Need help suppressing information in a table in a mail merge mail merge with table nadja Mail Merge 5 03-06-2012 05:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:27 PM.


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