| 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 | |||
Linear Mode
