Merge fields with phone number format

[Denny]

I have a user who has a database that tracks information
on vendors. This database has three fields that are phone
numbers using the following format{(555) 555-5555}. This
is how the data is stored in the Access table. The field
is setup as a text file.

We are trying to do a MailMerge into a document and when
these three fields are merged the formatting is removed
and we only get the straight numbers {5555555555}.

I have read through some Access and Word books, but
nothing I try has any affect.

Any suggestions?

Thanks in advance.
Denny

 

[Paul Lautman]

Your field (Alt-F9) neeeds to look like:
{MERGEFIELD phone \# "(###) ##'-'####"}

see: http://tinyurl.com/4xgd3