Reply
 
Thread Tools Display Modes
  #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!
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mail Merge: zip codes that start wtih zero all default to zero..?

The formatting in Excel only governs the way in which Excel displays the
data, not the way in which it is stored and Word just uses the data as it is
stored. To get the desired formatting in Word, it is necessary to add a
formatting switch to the Mergefield.

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

"MosskinsInNY" wrote in message
...
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!



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
edg edg is offline
external usenet poster
 
Posts: 3
Default Mail Merge: zip codes that start wtih zero all default to zero

As always, Microsoft makes things much more complicated than necessary. If a
field is coded as zip, then the number should be stored that way. How stupid
not to carry it also what purports to be an intergrated system.
--
edg


"Doug Robbins - Word MVP" wrote:

The formatting in Excel only governs the way in which Excel displays the
data, not the way in which it is stored and Word just uses the data as it is
stored. To get the desired formatting in Word, it is necessary to add a
formatting switch to the Mergefield.

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

"MosskinsInNY" wrote in message
...
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!




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
Mail merge in Word from Outlook Catagories stephen Mailmerge 7 December 11th 06 07: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 24th 05 12:56 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 8th 05 12:21 AM


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