Merging Phone numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

schroederv - 14 Jul 2006 00:38 GMT

The phone numbers in my data source are formatted like (555) 123-4567 but
when I merge into my word document it looks like 5551234567. How can I get
it to merge over correctly?

Reply to this Message

Cindy M -WordMVP- - 14 Jul 2006 16:34 GMT

Hi =?Utf-8?B?c2Nocm9lZGVydg==?=,

> The phone numbers in my data source are formatted like (555) 123-4567 but
> when I merge into my word document it looks like 5551234567. How can I get
> it to merge over correctly?

It always helps if you include the version of Word that's giving the problem,
as well as the type of data source.

Include a formatting switch in the merge field. Something like this:
{ Mergefield PhoneNumber \# "(000) 000'-'0000" }

Alt+F9 to turn the field code display on/off.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

Reply to this Message