View Single Post
 
Old 04-24-2015, 01:02 AM
hanskimber hanskimber is offline Windows 7 64bit Office 2010 64bit
Novice
 
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, 11 views)
File Type: xlsx Mock Data.xlsx (15.4 KB, 10 views)
Reply With Quote