Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge field+if statement+phone numbers
I have a form file in Word 2000 that merges with an Excel Database. One of
my fields is a telephone number. I want to do two things with that telephone number. One format as (000) 000-0000 and if that Excel telephone field is blank when the merge takes place, I do not want the telephone number to print at all. I want the field to appear blank on the final merged document. However, if there is a telephone number in that field then I want the telephone number to print in the format shown above. I have tried several versions of an if statement and cannot seem to obtain the correct statement. Here is what I have tried: {IF{MERGEFIELD EmployerPhone}"""{MERGEFIELD EmployerPhone}"} Also tried: {IF{MERGEFIELD EmployerPhone\#"(000)'-'000'-'0000"}"""{MERGEFIELD EmployerPhone\#"(000)'-'000'-'0000"}"} and also: {MERGEFIELD EmployerPhone\#"(000)'-'000'-'0000"}{IF{MERGEFIELD EmployerPhone\#"(000)'-'000'-'0000"}"""{MERGEFIELD EmployerPhone\#"(000)'-'000'-'0000"}"} What am I doing wrong. I have tried merging with files that contain telephone numbers and are blank. My results are not consistent. I can get it to print in the format I want depending on the above statement variation, but not consistently blank when the field is blank and not consistently print the phone number when the filed is not blank. Help!!! AJ -- John R. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I format a phone number in a mail merge field? | Mailmerge | |||
Word: IF statement to merge a field only if another Field is popul | Mailmerge | |||
how do I get phone numbers to format correctly in a mail merge? | Mailmerge | |||
Troubleshoot using field switching to format phone numbers in Word | Mailmerge | |||
Home Phone field not getting picked up in Merge | Mailmerge |