 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / August 2007How 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" \"(###) ###-####"} {Mergefield Phone \# "(###) ###'-'####"} see also http://www.gmayor.com/formatting_word_fields.htm  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I tried the following, and it did nothing. I tried a few other > variations, but they all gave me errors. > > { MERGEFIELD "PHONE" \"(###) ###-####"} 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? > {Mergefield Phone \# "(###) ###'-'####"} > see also http://www.gmayor.com/formatting_word_fields.htm [quoted text clipped - 3 lines] > > > > { MERGEFIELD "PHONE" \"(###) ###-####"} 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! Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I tried to do like that. But No effect!!! Why? > First I merge from Word then I click in {...} I add \# .... and [quoted text clipped - 17 lines] >>> >>> { MERGEFIELD "PHONE" \"(###) ###-####"} 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. > Did you update the field after adding the switch? > [quoted text clipped - 31 lines] > >>> > >>> { MERGEFIELD "PHONE" \"(###) ###-####"} What do you get when you insert the mergefield without the switch? Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > 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 [quoted text clipped - 45 lines] >>>>> >>>>> { MERGEFIELD "PHONE" \"(###) ###-####"} (207) 555-2462 > What do you get when you insert the mergefield without the switch? > [quoted text clipped - 47 lines] > >>>>> > >>>>> { MERGEFIELD "PHONE" \"(###) ###-####"} 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 . Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > (207) 555-2462 > [quoted text clipped - 57 lines] >>>>>>> >>>>>>> { MERGEFIELD "PHONE" \"(###) ###-####"} 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 > (207) 555-2462 > [quoted text clipped - 49 lines] >> >>>>> >> >>>>> { MERGEFIELD "PHONE" \"(###) ###-####"} |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.