Switch for Telephone number

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

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

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

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

"KarenMike" wrote in message
...
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.
--
Karen K

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.

--

Graham Mayor - Word MVP

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



Doug Robbins - Word MVP wrote:
Adding the following formatting switch to the field will display the
numbers in that way

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


"KarenMike" wrote in message
...
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.
--
Karen K