Field format from Excel

[jbrzez]

I am trying to MailMerge a field from an Excel document. The field is for
Phone Numbers and has been formatted to display them with the area code and
middle dash in the number (123) 456-7890
When I merge that field in it displays as: 1234567890

How do I keep the formatting or how do I change the field once it is in Word?

 

[Graham Mayor]

See the examples at http://www.gmayor.com/formatting_word_fields.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


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

 

[jbrzez]

I don't have full interent here at work (thought this was the 21st century)
so I can't access the site. Any way to describe or list the steps?

 

[Graham Mayor]

Add a switch to the mergefield
Right click and toggle the field display to reveal
{Mergefield fieldname}
Edit that to read
{Mergefield Fieldname \# "(000) 000'-'0000"}
Press F9 to update the field
then Toggle the field display to reveal the update


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


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

 

[jbrzez]

Thanks. It worked great.

Add a switch to the mergefield
Right click and toggle the field display to reveal
{Mergefield fieldname}
Edit that to read
{Mergefield Fieldname \# "(000) 000'-'0000"}
Press F9 to update the field
then Toggle the field display to reveal the update


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


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