Switch for Telephone number

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KarenMike - 01 Apr 2008 17:02 GMT

I am trying to do a mail merge with an access 2003 query. The table is set so
my tel. numbers are stored and displayed as (xxx)xxx-xxxx. When I merge it
with a word doc, the number is displayed as xxxxxxxxxx. I have reviewed the
recommended document "www.gmayor.com/formatting_word_fields" as recommended
in previous postings, but it does not address telephone numbers.

Signature

Karen K

Reply to this Message

Doug Robbins - Word MVP - 01 Apr 2008 20:37 GMT

Adding the following formatting switch to the field will display the numbers
in that way

\# "(###) ###-####"

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am trying to do a mail merge with an access 2003 query. The table is set
>so
[quoted text clipped - 4 lines]
> recommended
> in previous postings, but it does not address telephone numbers.

Reply to this Message

Graham Mayor - 02 Apr 2008 09:15 GMT

It should have been possible to work this out from the information on my web
site, however I have added a brief section on telephone number formatting.
In fact Doug's example here will not work as intended as the hyphen needs to
be quoted or it will be replaced by a space. I also suggest using zeros
rather than hashes as phone numbers can contain leading zeros thus

\# "(000) 000'-'0000"

would be my recommendation. The space after the right bracket ')' is
optional.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Adding the following formatting switch to the field will display the
> numbers in that way
[quoted text clipped - 11 lines]
>> --
>> Karen K

Reply to this Message

Rate this thread: