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
--
macropod
[MVP - Microsoft Word]
"Shannon" wrote in message
...
In a similar case, I used a query in Access to manipulate data into being
a
percentage with no decimals. In the Word document, those fields are
neither
in percent form, nor integers. Can you help via Access, or should I go to
the site you mentioned, and piddle in Word switches (which I've never
done)?
Thanks in advance, Shannon
"Doug Robbins - Word MVP" wrote:
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
"Rene" wrote in message
...
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