Phone numbers unformatted from Access

[Joe]

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]

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.
--
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