how do I get phone numbers to format correctly in a mail merge?

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-4576 but
when I merge into word the numbers come over like 5551234576. How can I get
them to merge correctly?

Reply to this Message

Peter Jamieson - 14 Jul 2006 03:04 GMT

Typically you have to use a "numeric format switch", e.g. if your field in
Word looks like

{ MERGEFIELD "phone number" \*mergeformat }

(Use Alt-F9 to look)

try changing it to

{ MERGEFIELD "phone number" \#"(000) 000'-'0000" }

Peter Jamieson

> The phone numbers in my data source are formatted like (555) 123-4576 but
> when I merge into word the numbers come over like 5551234576. How can I
> get
> them to merge correctly?

Reply to this Message