Merge fields with phone number format

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

You have to provide the formatting required in Word with a switch on the
merge field http://www.gmayor.com/formatting_word_fields.htm

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

should do the trick here

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Denny wrote:
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

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

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

"Denny" wrote in message
...
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