Reply
 
Thread Tools Display Modes
  #1   Report Post  
Randy57
 
Posts: n/a
Default How do I get mail merge to print full zip codes

When I use mail merge of info from an Excel spreadsheet with names and
addresses into a Word document , the zip codes starting with zero don't print
the zeros, and the zip plus four get cut off. I've been into
format/style/modify/special in the Excel document but it doesn't translate
into the merged Word document. Any ideas?
  #2   Report Post  
pops
 
Posts: n/a
Default


-----Original Message-----
When I use mail merge of info from an Excel spreadsheet

with names and
addresses into a Word document , the zip codes starting

with zero don't print
the zeros, and the zip plus four get cut off. I've been

into
format/style/modify/special in the Excel document but it

doesn't translate
into the merged Word document. Any ideas?
.
Is the cell holding the zipcode formatted as a test cell

rather than sime kind of number cell? When I format the
cell as a text cell I can see the preceeding zeros that
otherwise are truncated. It copies and pastes into a word
doc with the zeros in place. Hope that helps
Pops

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 with attachments AS Mailmerge 5 April 9th 05 09:49 AM
How do I print mailing labels with mail merge? DanaTunstall Mailmerge 5 February 13th 05 10:09 PM
How do I print on a continuous form in mail merge? Jamie Mailmerge 0 February 2nd 05 06:43 PM
How do I print a mail merge data source without the main document Lynn A Mailmerge 0 January 21st 05 11:39 AM
Printing a full page of labels using Mail Merge fields seansmom Microsoft Word Help 2 January 12th 05 01:42 PM


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