I have an MS Word document that I'm trying to mailmerge. The datasource is an
Excel spreadsheet and contains telephone numbers. The telephone number
field is a number field with telephone display format (I did this to
facilitate easy data entry). When I mailmerge my Word document (the fields
get inserted into a table), the telephone numbers appear without formatting.
How can I tell Word to format the number as telephone? I'm using Word
2002-SP2.

First see the sectionon Excel data at:

http://www.gmayor.com/mail_merge_lab...th_word_xp.htm

or you could use a format swith:

\# "(###) ###'-'####"
--
Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.

ghllag wrote:
I have an MS Word document that I'm trying to mailmerge. The
datasource is an Excel spreadsheet and contains telephone numbers.
The telephone number field is a number field with telephone display
format (I did this to facilitate easy data entry). When I mailmerge
my Word document (the fields get inserted into a table), the
telephone numbers appear without formatting. How can I tell Word to
format the number as telephone? I'm using Word 2002-SP2.

Or see my other web page 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




Greg Maxey wrote:
First see the section on Excel data at:

http://www.gmayor.com/mail_merge_lab...th_word_xp.htm

or you could use a format switch:

\# "(###) ###'-'####"

ghllag wrote:
I have an MS Word document that I'm trying to mailmerge. The
datasource is an Excel spreadsheet and contains telephone numbers.
The telephone number field is a number field with telephone display
format (I did this to facilitate easy data entry). When I mailmerge
my Word document (the fields get inserted into a table), the
telephone numbers appear without formatting. How can I tell Word to
format the number as telephone? I'm using Word 2002-SP2.