Switch for mail merging telephone-number field

[Rene]

How do I format a merged text field to display as a telephone number in the
merged document. Can't find the rigth switch to add characters and spacing.
F.e: Access source: 5128925552 --> needs to result in Word merge document
(512) 892-5552
Source: Access table, field type: Text

 

[Doug Robbins - Word MVP]

I would always use a query in Access to manipulate/format data, but if you
want to do it in Word,
See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


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

 

[macropod]

For the phone numbers, all you need to do is to add a picture switch to the
mergefield in you mailmerge template. To do this:
.. select the mergefield
.. press Shift-F9 to expose the field code. It should look something like
'{MERGEFIELD MyData}', where 'MyData' is your data field's name.
.. delete everything between 'MyData' and the closing field brace
.. add ' \# "(000) 0000 0000"' after 'MyData', so that you end up with
'{MERGEFIELD MyData \# "(000) 0000 0000"}'
.. press F9 to update the field
.. run your mailmerge.


Cheers