phone number mail merge

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to merge a phone number from Excel 2007 to Word 2007. The format
in Excel is 1234567890. After I merge the file in Word, I need it to look
like (123) 456-7890. No matter how I try, the merged file looks like
1234567890. HELP!
 
IMHO, you'd be a lot better off formatting the phone numbers in XL. Just
select the phone number cells & go to Format> Cells> Number. Select Special
from the list of categories then pick Phone Number. You should find that
they'll come into your merge just the way you want them.

HTH |:>)
Bob Jones
[MVP] Office:Mac



On 10/12/07 6:01 PM, in article
(e-mail address removed), "nextstep"

I am trying to merge a phone number from Excel 2007 to Word 2007. The
format
in Excel is 1234567890. After I merge the file in Word, I need it to look
like (123) 456-7890. No matter how I try, the merged file looks like
1234567890. HELP!
 
Unfortunately formatting the cells in Excel doesn't always cut it - and even
then only if you use the flaky DDE method of connecting to the database. A
formatting switch on the field is a more certain method of producing the
desired results; in this instance:

{Mergefield PhoneNoFieldname \# "(000') '000'-'0000"}

For more information, see the link in Suzanne's reply.
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Back
Top