#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
Hi Claire,
You can't do that with a table, but you can do it using a tabular text layout, using the mailmerge \b and/or \f switch. See: http://office.microsoft.com/en-us/wo...005186172.aspx
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thanks. I did try the \f but it didn't work as I had hoped. My template simply continued to state all the possible benefits (as I had typed them in) and just left blanks in the value fields. Looked like gappy teeth
|
#4
|
||||
|
||||
You would probably have to use both switches, with the benefit names attached to the \b switch, thus:
{MERGEFIELD Mobile \b "Mobile phone £" \f "¶ "} where the ¶ is an actual paragraph break.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Hmmm, I'm clearly not very good at this because this does nothing. I think I shall consider myself beaten on this one - probably not good use of a CFO's time anyway!
Thanks again |
#6
|
||||
|
||||
Did you delete the "Mobile phone £" text from before the mergefield? Also, are you sure there's no output from the mergefield when there is no mobile phone (eg no space character)?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge to create specific number of table rows | flackend | Mail Merge | 4 | 12-01-2023 02:49 PM |
Formula that can merge multiple rows with the same ID into one row | Hilwey | Excel | 3 | 07-08-2015 08:50 PM |
Mail Merge multiple rows? | ender541 | Mail Merge | 1 | 08-21-2012 03:14 PM |
Suppress the Save prompt | UTSUPPORT | Word | 1 | 01-16-2012 09:27 PM |
Suppress Dialog Box | crutch024 | Word | 0 | 08-17-2010 09:52 AM |