Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Mail Merge "if" statement
I have a merged document with multiple records on each page. I need the
formatting to remain the same throughout the page. I have lines for name, address, home phone, bus phone, & email. If the business phone is blank in excel, word is removing the line, thus messing up the formatting for the record below. How do I make it put a blank line if the information is blank? Im sure its an "if" statement but I can not figure them out. thx |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Mail Merge "if" statement
Hi Patty,
If you select the problem mergefield and press Shift-F9, you should see its coding, which will look something like: {MERGEFIELD Bus_Phone} if there's a '\b' in the field, eg {MERGEFIELD Bus_Phone \b}, removing it may help. Other than that, you could put the mergefields into a single-celled table with a fixed row height - or have a separate tab;e row for each merge line. That way, the rest of the document's formatting won't change if some merge lines are empty. No need for the complications of an IF test but, if you want one: {IF{MERGEFIELD Bus_Phone}= "" "ΒΆ " "{MERGEFIELD Bus_Phone}"} Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Patty White" wrote in message ... I have a merged document with multiple records on each page. I need the formatting to remain the same throughout the page. I have lines for name, address, home phone, bus phone, & email. If the business phone is blank in excel, word is removing the line, thus messing up the formatting for the record below. How do I make it put a blank line if the information is blank? Im sure its an "if" statement but I can not figure them out. thx |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
email merge with multiple recipients in "To", "CC" & "BCC" | Mailmerge | |||
what does "professional philosopy statement" mean? | Microsoft Word Help | |||
Mail Merge - Fields missing within "insert merge field" tab | Mailmerge | |||
using an alphanumeric "word" as a field value in an IF statement | Microsoft Word Help | |||
Multiple "OR" statements in a single "IF" statement | Mailmerge |