Re: How do I format a phone number in a mail merge field?
- From: "Graham Mayor" <gmayor@xxxxxxxxxxxxxxxxxx>
- Date: Sun, 12 Aug 2007 08:07:19 +0300
What do you get when you insert the mergefield without the switch?
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
me04984 wrote:
This is an old post but I find it helpful. However, when I put in the
code you suggest, I get ( )- -2462 for example, where it prints
only the last four. What format does the data base have to be in to
make it come out right? Actually, I would prefer having it listed as
207-555-2462 in my listings, if possible.
"Graham Mayor" wrote:
Did you update the field after adding the switch?
In your merge source document insert the phone number field. It will
look something like
<<phone>>
Right click and toggle the display. It will now look like
{Mergefield Phone}
Add the switch this
{Mergefield Phone \# "(###) ###'-'####"}
Press F9 to update
then toggle the display back again (if it has not already done so.)
Execute the merge to a new document.
Voila!
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
AnhVu wrote:
I tried to do like that. But No effect!!! Why?
First I merge from Word then I click in {...} I add \# .... and
nothing happend.
I tried to visit your web and tried every example. And no one
effect.Please help me. What step I wrong?
"Graham Mayor" wrote:
{Mergefield Phone \# "(###) ###'-'####"}
see also http://www.gmayor.com/formatting_word_fields.htm
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Halley wrote:
I tried the following, and it did nothing. I tried a few other
variations, but they all gave me errors.
{ MERGEFIELD "PHONE" \"(###) ###-####"}
.
- Follow-Ups:
- References:
- Prev by Date: Re: How do I format a phone number in a mail merge field?
- Next by Date: Repeating data in Merge or conditional use of fields
- Previous by thread: Re: How do I format a phone number in a mail merge field?
- Next by thread: Re: How do I format a phone number in a mail merge field?
- Index(es):
Relevant Pages
|
