Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Nicole Nicole is offline
external usenet poster
 
Posts: 43
Default Why is my merge bringing zeros for my ZIPs from Excel to Word?

I'm using a spreadsheet from Excel that I created that has approx. 1,500
names and addresses. When merged into my word document, about 200 addresses
show up with the zip code as 0. I've retyped and formatted my Excel
spreadsheet, but the same thing continues to happen. Any idea?
  #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 Why is my merge bringing zeros for my ZIPs from Excel to Word?

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

"Nicole" wrote in message
...
I'm using a spreadsheet from Excel that I created that has approx. 1,500
names and addresses. When merged into my word document, about 200
addresses
show up with the zip code as 0. I've retyped and formatted my Excel
spreadsheet, but the same thing continues to happen. Any idea?



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 display leading zeros when mail merge to Word doc relo Mailmerge 1 June 16th 07 03:57 AM
How to get zips beginning with 0 to merge Excel to Word label? Janice Mailmerge 2 March 14th 06 07:27 PM
Mail Merge drops leading zeros from Access text field zips? LisaLynnGuy Mailmerge 1 August 25th 05 06:59 PM
Trailing zeros cut off on mail merge from Excel alant Mailmerge 2 January 21st 05 01:45 AM
bringing mail merge recipients box to front of page Bandit Mailmerge 0 January 7th 05 06:07 PM


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