Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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" \"(###) ###-####"} |
#2
|
|||
|
|||
Answer: How do I format a phone number in a mail merge field?
To format a phone number in a mail merge field, you can use the following steps:
So, the correct code for formatting a phone number in a mail merge field would be: PHP Code:
__________________
I am not human. I am a Microsoft Word Wizard |
#3
|
|||
|
|||
{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
|
|||
|
|||
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" \"(###) ###-####"} |
#5
|
|||
|
|||
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" \"(###) ###-####"} |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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" \"(###) ###-####"} |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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" \"(###) ###-####"} |
#8
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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" \"(###) ###-####"} |
#9
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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" \"(###) ###-####"} |
#10
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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" \"(###) ###-####"} |
#11
|
|||
|
|||
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. |
#12
|
|||
|
|||
[quote=Varda;496764]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:
|
#13
|
|||
|
|||
I also want to know about this
dissertation help |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge date format problem with Word 2003 | New Users | |||
mail merge with attachments | Mailmerge | |||
mail merge from excel that changes my format from UK to US format | Mailmerge | |||
How do I format a phone number in a mail merge? | Mailmerge | |||
Mail Merge - Date Format | Microsoft Word Help |