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 - 02 Sep 2004 18:57 GMT
Your field (Alt-F9) neeeds to look like:
{MERGEFIELD phone \# "(###) ##'-'####"}
see: http://tinyurl.com/4xgd3
> I have a user who has a database that tracks information
> on vendors. This database has three fields that are phone
[quoted text clipped - 13 lines]
> Thanks in advance.
> Denny