View Single Post
 
Old 04-30-2013, 04:30 AM
ClaireAMAdams ClaireAMAdams is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Apr 2013
Posts: 3
ClaireAMAdams is on a distinguished road
Default Easy mail merge but want to suppress rows

I'm new to mail merge. I know how how to pull in the field to be merged. I'm not doing a letter-style but more of a data table style, basically to show staff the value of benefits they've had. So, imagine a table like this:

Name ....
Mobile phone (hard-typed) <£x> (mail merge field)
Health care <£y> etc

The above would be presented as a table in word with 2 columns and x rows

I know how to pull in £x and £y data but I want rows to be excluded if an employee doesn't have that particular benefit. How do I do that?

Thanks
Reply With Quote