Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
MosskinsInNY MosskinsInNY is offline
external usenet poster
 
Posts: 1
Default Mail Merge: zip codes that start wtih zero all default to zero..?

I have been doing mail merges for nearly 20 years and this has me confused.
I am used to Office 2000 and am now using Office 2003 (whether that accounts
for this I rather doubt).

I am merging into Word (mailing labels) from an Excel file. Everything
looks fine in Excel, but when I merge, any zip code that begins with a "0"
defaults to a single "0" when printing. The column is formatted for "zip
code +4". I have also tried "zip code", and "test" and inserted all those
pesky apostrophes.

Once I did get the labels to come up on my monitor with the correct zip
codes, but when they printed, the postal codes on the first page were
duplicated on all the following pages (NOT what was on the screen).

Anyone out there know how to help? It would be greatly appreciate as we are
coming into "bulk mail season".
Thanks!
 
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
Mail merge in Word from Outlook Catagories stephen Mailmerge 7 December 11th 06 06:48 PM
Editing Mail Merge Recipients Stan W. Mailmerge 8 May 4th 06 05:03 AM
preceeding zeros in postal codes of mail merge Crystal B Mailmerge 2 November 23rd 05 11:56 PM
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


All times are GMT +1. The time now is 02:02 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"