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 / May 2004

Tip: Looking for answers? Try searching our database.

Phone numbers unformatted from Access

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Joe - 26 May 2004 11:54 GMT
Hello,

I am merging from an Access phone/address database.  In
Access I am using an input mask to make the phone numbers
look like, well, phone numbers.  But when I merge them to
Word, the formating (dashes and spaces) disappear.

Any help to get the numbers in Word formatted would be
greatly appreciated!

Oh, also, I found another post addressing this issue and
it said to add a switch such as the following:

{ MERGEFIELD PhoneNum \# "(###) ###'-'####" }

I am not overly familiar with how to use switches, and I
am also not sure of the brackets used above vs the small
double < and > that surround inserted merge fields, but I
did experiment with it and could not get it to work.

Again, THANKS!

Joe
Doug Robbins - Word MVP - 26 May 2004 12:44 GMT
Press Alt+F9 and your mergefield that is in <<  >> will be displayed as a
field code of the form

{ MERGEFIELD PhoneNum }

Note, the exact name of your data field will depend on the name of the field
in the Access table/query

Add the formatting switch inside the closing }

Press Alt+F9 again to toggle off the field codes.
Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested.  Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> Hello,
>
[quoted text clipped - 19 lines]
>
> Joe
 
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.