Thank you to both of you. I have been able to setup the mail merge and the
notecards. However, I am unable to include the category titles on each
notecard. For example, (It's a chemical inventory):

Note card reads:

Acetic Acid, Glacial; Vinegar Acid
C2H4O2
60.05
Keep Cool, Toxic
Under the Hood
Fisher A38-500
6 bottles

But I want:

Name: Acetic Acid, Glacial; Vinegar Acid
Formula: C2H4O2
Formula Wt: 60.05
Storage: Keep Cool, Toxic
Location: Under the Hood
Co./Catalog #: Fisher A38-500
Supply: 6 bottles

Thanks again for any assistance and/or suggestions.







"Doug Kanter" wrote:

I didn't know that!

"Marvin P. Winterbottom"
wrote in message ...
You don't have to copy the data to Word, if you do a Mail Merge, you can
pick
the excel sheet as the data source. Tell it you are doing labels, and you
should be able to pick the Avery number off a list. It's really pretty
easy.

"Doug Kanter" wrote:


"Quik" <Quik @discussions.microsoft.com wrote in message
...
I am currently working on a detailed inventory, but also want to make a
hard-copy version from the list in excel in the form of individual note
cards
for each entry? Are there any shortcuts I could take through excel or
any
other Office programs so that I could just click and print rather than
do
everything manually?

Any help would be greatly appreciated.

Thank you.

I can't help with the software/mail merge part of this, since it's not my
forté, but I have a suggestion for the end result. If you're talking
about
something like index cards, Avery makes those in printable sheets.

Here's one:
http://www.avery.com/us/Main?action=...alogcode=WEB01

I've used their business card sheets and they work flawlessly, at least
in
my printer. Microsoft Word already contains formatting (in Tools,
Envelopes
and Labels) for many Avery products. You choose the product number, and
the
formatting's done for you. If the product isn't listed, the Avery
products
come with extremely easy formatting instructions so you can create a
custom
(and permanent) setting for the card or label on your computer.

If someone else here can help you copy the data to Word and set up a mail
merge to labels (meaning, the cards, in this case), you're in business.