Reply
 
Thread Tools Display Modes
  #1   Report Post  
Rene
 
Posts: n/a
Default Switch for mail merging telephone-number field

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

  #2   Report Post  
Doug Robbins - Word MVP
 
Posts: n/a
Default

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


  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Shannon Shannon is offline
external usenet poster
 
Posts: 42
Default Switch for mail merging telephone-number field

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



  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod macropod is offline
external usenet poster
 
Posts: 1,002
Default Switch for mail merging telephone-number field

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





Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
form field,can I add a telephone number under the number field w/d redwolfe5 Microsoft Word Help 3 March 3rd 05 06:30 PM
Why can't I see 'home phone' field when mail merging from Outlook. Roger Mailmerge 1 December 19th 04 11:36 AM
Date issue merging from Excel field in Date format to Word Barb Reinhardt Mailmerge 1 December 17th 04 08:34 AM
Text Form Field Ref in Footer Won't Update on Screen StarWine Microsoft Word Help 3 December 6th 04 07:17 PM
Number fields not merging correctly Gov_ner Mailmerge 1 December 2nd 04 11:51 PM


All times are GMT +1. The time now is 11:32 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"