Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / September 2004

Tip: Looking for answers? Try searching our database.

Merge fields with phone number format

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Denny - 02 Sep 2004 14:11 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.