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 / December 2004

Tip: Looking for answers? Try searching our database.

Merge from Excel to word for labels

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
pattimelt - 04 Dec 2004 15:35 GMT
HELP!! I'm confuzzled.  

I just got put in charge of my club membership roster.  The columns in Excel
are correct, yet when I put them in the merge, instead of getting a month and
year in the "expires" spot of the merge, the program uses the "year" as a
date, and adds the year the person was originally added to the list.  I can't
seem to figure out how to correct this no matter what format function I use.  

The mail merge fields look like this:  First Name, Last Name, expires on the
first line, then address with city state and zip, and then the postal
whatever it's called on the bottom.  

The label should look like this:

John Smith  Mar 05
1234 Elm Lane
Anaheim, CA 92804

and instead look like this:

John Smith  Mar 05/2003
1234 Elm Lane
Anaheim, CA 92804

How can I fix this problem without having to individually edit each label??
There are 800 members in the club!!!!!!!!!!

Thank you!!
Cindy M  -WordMVP- - 05 Dec 2004 10:44 GMT
Hi =?Utf-8?B?cGF0dGltZWx0?=,

We're missing the version of Word/Office involved in this?

Could you also tell us, please, the field name (Excel column header) for the
field giving you the problem? And how does the data look in Excel in the FORMULA
BAR when you click on a cell in that column?

> I just got put in charge of my club membership roster.  The columns in Excel
> are correct, yet when I put them in the merge, instead of getting a month and
[quoted text clipped - 22 lines]
> How can I fix this problem without having to individually edit each label??
> There are 800 members in the club!!!!!!!!!!

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)
 
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.