phone number mail merge

[nextstep]

I am trying to merge a phone number from Excel 2007 to Word 2007. The format
in Excel is 1234567890. After I merge the file in Word, I need it to look
like (123) 456-7890. No matter how I try, the merged file looks like
1234567890. HELP!

 

[CyberTaz]

IMHO, you'd be a lot better off formatting the phone numbers in XL. Just
select the phone number cells & go to Format> Cells> Number. Select Special
from the list of categories then pick Phone Number. You should find that
they'll come into your merge just the way you want them.

HTH |:>)
Bob Jones
[MVP] Office:Mac



On 10/12/07 6:01 PM, in article
(e-mail address removed), "nextstep"

I am trying to merge a phone number from Excel 2007 to Word 2007. The
format
in Excel is 1234567890. After I merge the file in Word, I need it to look
like (123) 456-7890. No matter how I try, the merged file looks like
1234567890. HELP!

 

[Suzanne S. Barnhill]

See http://www.gmayor.com/formatting_word_fields.htm

 

[Graham Mayor]

Unfortunately formatting the cells in Excel doesn't always cut it - and even
then only if you use the flaky DDE method of connecting to the database. A
formatting switch on the field is a more certain method of producing the
desired results; in this instance:

{Mergefield PhoneNoFieldname \# "(000') '000'-'0000"}

For more information, see the link in Suzanne's reply.
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>