mail merge
 

I did a mail merge from excel to a word directory. the () and - are gone from
the phone number fields.

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.

mail merge
 

Joanna, to test my theory, pick an empty cell on a row with one of those
phone numbers, and assuming your phone number is in column F and working in
row 21, put this formula into the empty cell:
="(" & LEFT(F21,3) & ") " & MID(F21,4,3) & "-" & RIGHT(F21,4)
that should come out looking like a phone number also. It means that
whatever is in F21 has had special formatting applied to it.

Now, you can fill that formula up/down the column to pick up all of the
phone numbers and then select all of it. With all of the cells with the
formula in them selected use Edit | Copy and turn right around and use Edit |
Paste Special and tick the [Values] option and click OK. The Formulas will
be replaced by what you see, which can be used in a mail merge with better
results.

You can even go one step further: choose that column with the 'bad' phone
numbers and use Cells | Format and set it to General. The () and - will
disappear, and you can now copy the revised numbers (from paragraph above)
over the top of the bad ones and not have to change anything in your mail
merge set up. Of course you'll have to type in the () and - for future phone
numbers in that column.
"Joanna" wrote:

I did a mail merge from excel to a word directory. the () and - are gone from
the phone number fields.

mail merge
 

The cells with your phone number in them were probably formatted using
Special and the phone number mask. The () and - were figments of Excel's
imagination and never really existed.

"Joanna" wrote:

I did a mail merge from excel to a word directory. the () and - are gone from
the phone number fields.