Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
me04984 me04984 is offline
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" \"(###) ###-####"}






 
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
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 03:01 PM
How do I format a phone number in a mail merge? Kristyn Mailmerge 2 December 9th 04 08:12 AM
Mail Merge - Date Format Kilinski Microsoft Word Help 0 December 7th 04 01:13 PM


All times are GMT +1. The time now is 08:38 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"