Reply
 
Thread Tools Display Modes
  #1   Report Post  
Halley
 
Posts: n/a
Default 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   Report Post  
Anne Troy
 
Posts: n/a
Default

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   Report Post  
Halley
 
Posts: n/a
Default

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   Report Post  
Anne Troy
 
Posts: n/a
Default

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   Report Post  
Halley
 
Posts: n/a
Default

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I format a phone number in a mail merge field? Halley Mailmerge 12 April 25th 23 08:54 PM
Syntax for Number format in the Text Form Field Options Ed Hall 61 Microsoft Word Help 3 May 8th 05 07:51 PM
Home Phone field not getting picked up in Merge Cathleen McGuire Mailmerge 4 January 7th 05 04:13 AM
Why can't I see 'home phone' field when mail merging from Outlook. Roger Mailmerge 1 December 19th 04 11:36 AM
how to format phone number merged fields? GMed Mailmerge 1 December 9th 04 10:49 PM


All times are GMT +1. The time now is 01:13 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"