Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Formating a Merge Field
How can I setup a merge field so that the result appears in a specific
format? I need to do a mail merge using an Excel spreadsheet as the source, however the telephone numbers are not formated as such (eg 4079947953). For the merge, I need them to appear formated as phone numbers. |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Formating a Merge Field
You need a numeric formatting switch - 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 dch3 wrote: How can I setup a merge field so that the result appears in a specific format? I need to do a mail merge using an Excel spreadsheet as the source, however the telephone numbers are not formated as such (eg 4079947953). For the merge, I need them to appear formated as phone numbers. |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Formating a Merge Field
My phone numbers as coming in from a access database and are in text fields.
Do I need to change them to number fields? -- .. "Graham Mayor" wrote: You need a numeric formatting switch - 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 dch3 wrote: How can I setup a merge field so that the result appears in a specific format? I need to do a mail merge using an Excel spreadsheet as the source, however the telephone numbers are not formated as such (eg 4079947953). For the merge, I need them to appear formated as phone numbers. |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Formating a Merge Field
That rather depends on the result you get when you enter the field without a
switch. If it is a number then no. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org joshnm2020 wrote: My phone numbers as coming in from a access database and are in text fields. Do I need to change them to number fields? You need a numeric formatting switch - 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 dch3 wrote: How can I setup a merge field so that the result appears in a specific format? I need to do a mail merge using an Excel spreadsheet as the source, however the telephone numbers are not formated as such (eg 4079947953). For the merge, I need them to appear formated as phone numbers. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A Merge letter requiring one or more different different mege letters depending on entry in fields | Microsoft Word Help | |||
Merge field control in Documents | Mailmerge | |||
How do I omit an empty date merge field? | Microsoft Word Help | |||
Enhance merge to email feature of word with cc: merge field. | Mailmerge | |||
suppress invalid merge field word 2003 | Mailmerge |