A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How do I format a phone number in a mail merge field?



 
 
Thread Tools Display Modes
  #1  
Old May 27th 05, 12:23 AM
Halley
external usenet poster
 
Posts: n/a
Default How do I format a phone number in a mail merge field?

I tried the following, and it did nothing. I tried a few other variations,
but they all gave me errors.

{ MERGEFIELD "PHONE" \"(###) ###-####"}
Ads
  #2  
Old May 27th 05, 04:38 AM
Graham Mayor
external usenet poster
 
Posts: n/a
Default

{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" \"(###) ###-####"}




  #3  
Old November 11th 05, 04:22 PM
AnhVu
external usenet poster
 
Posts: n/a
Default How do I format a phone number in a mail merge field?

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" \"(###) ###-####"}





  #4  
Old November 11th 05, 04:31 PM
Graham Mayor
external usenet poster
 
Posts: n/a
Default How do I format a phone number in a mail merge field?

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" \"(###) ###-####"}



  #5  
Old August 11th 07, 10:28 PM posted to microsoft.public.word.mailmerge.fields
me04984
external usenet poster
 
Posts: 4
Default How do I format a phone number in a mail merge field?

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" \"(###) ###-####"}




  #6  
Old August 12th 07, 06:07 AM posted to microsoft.public.word.mailmerge.fields
Graham Mayor
external usenet poster
 
Posts: 19,312
Default How do I format a phone number in a mail merge field?

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" \"(###) ###-####"}



  #7  
Old August 13th 07, 01:54 AM posted to microsoft.public.word.mailmerge.fields
me04984
external usenet poster
 
Posts: 4
Default How do I format a phone number in a mail merge field?

(207) 555-2462

"Graham Mayor" wrote:

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" \"(###) ###-####"}




  #8  
Old August 13th 07, 05:51 AM posted to microsoft.public.word.mailmerge.fields
Graham Mayor
external usenet poster
 
Posts: 19,312
Default How do I format a phone number in a mail merge field?

That's a text string. You cannot format a text string in a merge field. The
only way to do it would be to edit your data source to show 2075552462. You
can then add a formatting switch of your choice eg \# "###'-'###'-'####" -
see 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

me04984 wrote:
(207) 555-2462

"Graham Mayor" wrote:

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" \"(###) ###-####"}



  #9  
Old August 13th 07, 11:02 AM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,583
Default How do I format a phone number in a mail merge field?

What is the data source? And are absolutely all your phone numbers in that
precise format (e.g., even mobile and international numbers, if any) ?

Peter Jamieson
"me04984" wrote in message
...
(207) 555-2462

"Graham Mayor" wrote:

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" \"(###) ###-####"}





  #10  
Old June 24th 17, 08:43 PM
Varda Varda is offline
Junior Member
 
First recorded activity by WordBanter: Jun 2017
Posts: 1
Default

I've read this entire thread several times, tried all the suggestions, but am having the same exact issue the person wrote below. The weird thing is that this happens to SOME of the records, and not all of them.

I've checked my database and the phone numbers are all stored in the same manner. Yet the printed mail merging in Word shows this for some of the phone numbers:
(- ) -1635


[quote=me04984;278569]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.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge date format problem with Word 2003 Thang New Users 1 May 2nd 05 01:55 PM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
mail merge from excel that changes my format from UK to US format mark Mailmerge 0 January 21st 05 04:01 PM
How do I format a phone number in a mail merge? Kristyn Mailmerge 2 December 9th 04 09:12 AM
Mail Merge - Date Format Kilinski Microsoft Word Help 0 December 7th 04 02:13 PM


All times are GMT +1. The time now is 12:16 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.