Reply
 
Thread Tools Display Modes
  #1   Report Post  
Shannon
 
Posts: n/a
Default Zip Codes not transferring correctly to merge document

RUSH!!!!!

I have formatted the post code column in my excel worksheet to show the
following format, ex: 12345-1234 & 01234.

When I merge this file to my word mail merge document the format changes to
this... 123451234, 1234, & 0.

What happened to my dashes and zero before my zip code? Also why would the
zip code completely change to 0???
  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

See "Formatting Word fields with
switches" on fellow MVP Graham Mayor's website at:

http://www.gmayor.com/formatting_word_fields.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Shannon" wrote in message
...
RUSH!!!!!

I have formatted the post code column in my excel worksheet to show the
following format, ex: 12345-1234 & 01234.

When I merge this file to my word mail merge document the format changes
to
this... 123451234, 1234, & 0.

What happened to my dashes and zero before my zip code? Also why would
the
zip code completely change to 0???



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
Endnotes do not print correctly in a merge Art K Mailmerge 1 August 2nd 05 10:33 PM
how to use postal codes on a mail merge Scott972 Mailmerge 1 July 19th 05 04:00 AM
Mail Merge some international postal codes displayed as "0" cmcintyre Mailmerge 0 April 18th 05 11:35 PM
Mail merge drops zip codes and replaces with zero Shana Mailmerge 1 March 7th 05 11:21 PM
How do I get mail merge to print full zip codes Randy57 Mailmerge 1 March 3rd 05 07:27 PM


All times are GMT +1. The time now is 10:53 PM.

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"