mail merge
There may be ways of using field formatting within Word, in which case the
experts in a Word newsgroup may be able to help, but it is worth remembering
that in Excel the cell formatting doesn't affect the contents of the cell,
only the way it is displayed in the Excel cell. Your mail merge will
pick up the contents of the cell, so one option is to use a helper column
=TEXT(A1,"[<=9999999]###-####;(###) ###-####") or whatever format you are
trying to use.
--
David Biddulph
"Joanna" wrote in message
...
I did a mail merge from excel to a word directory. the () and - are gone
from
the phone number fields.
|