Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / April 2004

Tip: Looking for answers? Try searching our database.

Mailmerge - Data does not transfer

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
chris - 05 Apr 2004 06:35 GMT
Hello,

I've been creating Labels in Word 2002 from mailing lists
in Excel 2002. Some of the data in the "Zip Code" column in
Excel is 5 digits (e.g. 92714) while others are 5 digits +
4 digits (e.g. 92714-8445). These are all formatted as
"General".

When the data is merged into Word, each 5 digit entry comes
out fine. But the fields with 5 + 4 digits all come out as
"0".

The rest of the fields (name, street address, city, etc.)
all come out fine.

Would really appreciate any assistance on this problem.
Thank you!
Graham Mayor - 05 Apr 2004 07:43 GMT
See the zip code entry at http://www.gmayor.com/formatting_word_fields.htm
If this doesn't fix it, follow the link in the note at the beginning of that
page and checkout the section on Excel data.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
    Graham Mayor -  Word MVP

     Web site www.gmayor.com
 Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
.

> Hello,
>
[quoted text clipped - 13 lines]
> Would really appreciate any assistance on this problem.
> Thank you!
chris - 05 Apr 2004 18:04 GMT
Thank you Mr. Mayor - works just fine now!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.