Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-24-2015, 01:02 AM
hanskimber hanskimber is offline Dynamic Mail Merged Table Windows 7 64bit Dynamic Mail Merged Table Office 2010 64bit
Novice
Dynamic Mail Merged Table
 
Join Date: Apr 2015
Posts: 2
hanskimber is on a distinguished road
Default Dynamic Mail Merged Table

Hi,



Thank you to anyone who can help.

I am mail merging in Word from an Excel table, and would like to show a table along the lines of:

Service 1 - $2.50
Service 2 -$3.59
Service 3 - $0.00
Service 4 - $5.50

However any time an agency has not received a service, in the above case for Service 3, I want mail merge to hide this line in the table and only show the client agency the service that had $$'s attached.

This is to hide long ugly looking tables in the email.

Thank you!

Lee
Attached Files
File Type: docx Mock Mail Merge.docx (16.4 KB, 10 views)
File Type: xlsx Mock Data.xlsx (15.4 KB, 9 views)
Reply With Quote
  #2  
Old 04-24-2015, 07:42 AM
gmayor's Avatar
gmayor gmayor is offline Dynamic Mail Merged Table Windows 7 64bit Dynamic Mail Merged Table Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 3,913
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

In the circumstances I would not use a table, I would use a list with the text, fields and paragraph break conditionally inserted when the field has content.
__________________
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 04-24-2015, 11:21 PM
hanskimber hanskimber is offline Dynamic Mail Merged Table Windows 7 64bit Dynamic Mail Merged Table Office 2010 64bit
Novice
Dynamic Mail Merged Table
 
Join Date: Apr 2015
Posts: 2
hanskimber is on a distinguished road
Default

Quote:
Originally Posted by gmayor View Post
In the circumstances I would not use a table, I would use a list with the text, fields and paragraph break conditionally inserted when the field has content.
Thanks gmayor I will give it a shot and see how I go!
Reply With Quote
Reply

Tags
hide field, mail merge skips records, word 2010

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic Mail Merged Table How to staple mail merged documents jopegk Mail Merge 16 01-15-2023 12:43 PM
Insert Text between Mail Merged Items kawirider88 Mail Merge 1 09-29-2013 06:55 PM
Dynamic Mail Merged Table Mail Merge Into Dynamic Table Jag618 Mail Merge 1 03-04-2013 11:26 PM
Dynamic Mail Merged Table Overlapping text once mail merged Spartan300 Mail Merge 6 10-13-2010 06:14 PM
Dynamic Mail Merged Table No toggle b/w 2 accounts; mail merged in 1 inbox Windwardman Outlook 1 06-09-2010 09:25 AM

Other Forums: Access Forums

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


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