Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Troubleshoot using field switching to format phone numbers in Word
I used the following field switch to format a 10-digit phone number:
{MERGEFIELD PHONE \# "(###) ###-####"} It worked in approx. 30% of the documents I merged. However, in the other 70%, it made a number that originally looked like this: 716662-5025, turn into: 71 1637. What did I do wrong??? I also tried removing the () and - from the mergefield, but the same thing happened. |
#2
|
|||
|
|||
http://www.officearticles.com/word/m...osoft_word.htm
Numbers need zeroes. So try {MERGEFIELD PHONE \# "(000) 000-0000"} ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Halley" wrote in message news I used the following field switch to format a 10-digit phone number: {MERGEFIELD PHONE \# "(###) ###-####"} It worked in approx. 30% of the documents I merged. However, in the other 70%, it made a number that originally looked like this: 716662-5025, turn into: 71 1637. What did I do wrong??? I also tried removing the () and - from the mergefield, but the same thing happened. |
#3
|
|||
|
|||
It still didn't work. It gave me the same exact problem as before. Any
suggestions? "Anne Troy" wrote: http://www.officearticles.com/word/m...osoft_word.htm Numbers need zeroes. So try {MERGEFIELD PHONE \# "(000) 000-0000"} ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Halley" wrote in message news I used the following field switch to format a 10-digit phone number: {MERGEFIELD PHONE \# "(###) ###-####"} It worked in approx. 30% of the documents I merged. However, in the other 70%, it made a number that originally looked like this: 716662-5025, turn into: 71 1637. What did I do wrong??? I also tried removing the () and - from the mergefield, but the same thing happened. |
#4
|
|||
|
|||
I need to know what your source data looks like. Is it 10-digit numbers? Or
are there other characters? ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Halley" wrote in message news It still didn't work. It gave me the same exact problem as before. Any suggestions? "Anne Troy" wrote: http://www.officearticles.com/word/m...osoft_word.htm Numbers need zeroes. So try {MERGEFIELD PHONE \# "(000) 000-0000"} ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Halley" wrote in message news I used the following field switch to format a 10-digit phone number: {MERGEFIELD PHONE \# "(###) ###-####"} It worked in approx. 30% of the documents I merged. However, in the other 70%, it made a number that originally looked like this: 716662-5025, turn into: 71 1637. What did I do wrong??? I also tried removing the () and - from the mergefield, but the same thing happened. |
#5
|
|||
|
|||
The source data looks like:
(716) 662-5025 in Excel. "Anne Troy" wrote: I need to know what your source data looks like. Is it 10-digit numbers? Or are there other characters? ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Halley" wrote in message news It still didn't work. It gave me the same exact problem as before. Any suggestions? "Anne Troy" wrote: http://www.officearticles.com/word/m...osoft_word.htm Numbers need zeroes. So try {MERGEFIELD PHONE \# "(000) 000-0000"} ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Halley" wrote in message news I used the following field switch to format a 10-digit phone number: {MERGEFIELD PHONE \# "(###) ###-####"} It worked in approx. 30% of the documents I merged. However, in the other 70%, it made a number that originally looked like this: 716662-5025, turn into: 71 1637. What did I do wrong??? I also tried removing the () and - from the mergefield, but the same thing happened. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I format a phone number in a mail merge field? | Mailmerge | |||
Syntax for Number format in the Text Form Field Options | Microsoft Word Help | |||
Home Phone field not getting picked up in Merge | Mailmerge | |||
Why can't I see 'home phone' field when mail merging from Outlook. | Mailmerge | |||
how to format phone number merged fields? | Mailmerge |