Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
schroederv schroederv is offline
external usenet poster
 
Posts: 2
Default how do I get phone numbers to format correctly in a mail merge?

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?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default how do I get phone numbers to format correctly in a mail merge?

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

"schroederv" wrote in message
...
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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I mail merge to EMAIL from MS Word AND add a pdf attachment Lily@Insight Mailmerge 24 January 15th 07 09:33 PM
Getting international addresses to format correctly in a mail merg ldgoss Mailmerge 2 February 14th 06 07:05 PM
Date Format needs to change from Mail Merge malycom Microsoft Word Help 1 February 9th 06 12:07 PM
Numbers reformatting during mail merge Sherry Formatting Long Documents 1 December 9th 04 03:47 PM
Mail Merge - Date Format Kilinski Microsoft Word Help 0 December 7th 04 01:13 PM


All times are GMT +1. The time now is 09:18 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"