software

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.


quot;Quikquot; lt;Quik @discussions.microsoft.comgt; wrote in message
...
gt;I am currently working on a detailed inventory, but also want to make a
gt; hard-copy version from the list in excel in the form of individual note
gt; cards
gt; for each entry? Are there any shortcuts I could take through excel or any
gt; other Office programs so that I could just click and print rather than do
gt; everything manually?
gt;
gt; Any help would be greatly appreciated.
gt;
gt; 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:
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.
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.

quot;Doug Kanterquot; wrote:

gt;
gt; quot;Quikquot; lt;Quik @discussions.microsoft.comgt; wrote in message
gt; ...
gt; gt;I am currently working on a detailed inventory, but also want to make a
gt; gt; hard-copy version from the list in excel in the form of individual note
gt; gt; cards
gt; gt; for each entry? Are there any shortcuts I could take through excel or any
gt; gt; other Office programs so that I could just click and print rather than do
gt; gt; everything manually?
gt; gt;
gt; gt; Any help would be greatly appreciated.
gt; gt;
gt; gt; Thank you.
gt;
gt; I can't help with the software/mail merge part of this, since it's not my
gt; forté, but I have a suggestion for the end result. If you're talking about
gt; something like index cards, Avery makes those in printable sheets.
gt;
gt; Here's one:
gt; www.avery.com/us/Main?action=...alogcode=WEB01
gt;
gt; I've used their business card sheets and they work flawlessly, at least in
gt; my printer. Microsoft Word already contains formatting (in Tools, Envelopes
gt; and Labels) for many Avery products. You choose the product number, and the
gt; formatting's done for you. If the product isn't listed, the Avery products
gt; come with extremely easy formatting instructions so you can create a custom
gt; (and permanent) setting for the card or label on your computer.
gt;
gt; If someone else here can help you copy the data to Word and set up a mail
gt; merge to labels (meaning, the cards, in this case), you're in business.
gt;
gt;
gt;

I didn't know that!

quot;Marvin P. Winterbottomquot; gt;
wrote in message ...
gt; You don't have to copy the data to Word, if you do a Mail Merge, you can
gt; pick
gt; the excel sheet as the data source. Tell it you are doing labels, and you
gt; should be able to pick the Avery number off a list. It's really pretty
gt; easy.
gt;
gt; quot;Doug Kanterquot; wrote:
gt;
gt;gt;
gt;gt; quot;Quikquot; lt;Quik @discussions.microsoft.comgt; wrote in message
gt;gt; ...
gt;gt; gt;I am currently working on a detailed inventory, but also want to make a
gt;gt; gt; hard-copy version from the list in excel in the form of individual note
gt;gt; gt; cards
gt;gt; gt; for each entry? Are there any shortcuts I could take through excel or
gt;gt; gt; any
gt;gt; gt; other Office programs so that I could just click and print rather than
gt;gt; gt; do
gt;gt; gt; everything manually?
gt;gt; gt;
gt;gt; gt; Any help would be greatly appreciated.
gt;gt; gt;
gt;gt; gt; Thank you.
gt;gt;
gt;gt; I can't help with the software/mail merge part of this, since it's not my
gt;gt; forté, but I have a suggestion for the end result. If you're talking
gt;gt; about
gt;gt; something like index cards, Avery makes those in printable sheets.
gt;gt;
gt;gt; Here's one:
gt;gt; www.avery.com/us/Main?action=...alogcode=WEB01
gt;gt;
gt;gt; I've used their business card sheets and they work flawlessly, at least
gt;gt; in
gt;gt; my printer. Microsoft Word already contains formatting (in Tools,
gt;gt; Envelopes
gt;gt; and Labels) for many Avery products. You choose the product number, and
gt;gt; the
gt;gt; formatting's done for you. If the product isn't listed, the Avery
gt;gt; products
gt;gt; come with extremely easy formatting instructions so you can create a
gt;gt; custom
gt;gt; (and permanent) setting for the card or label on your computer.
gt;gt;
gt;gt; If someone else here can help you copy the data to Word and set up a mail
gt;gt; merge to labels (meaning, the cards, in this case), you're in business.
gt;gt;
gt;gt;
gt;gt;
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.

quot;Doug Kanterquot; wrote:

gt; I didn't know that!
gt;
gt; quot;Marvin P. Winterbottomquot; gt;
gt; wrote in message ...
gt; gt; You don't have to copy the data to Word, if you do a Mail Merge, you can
gt; gt; pick
gt; gt; the excel sheet as the data source. Tell it you are doing labels, and you
gt; gt; should be able to pick the Avery number off a list. It's really pretty
gt; gt; easy.
gt; gt;
gt; gt; quot;Doug Kanterquot; wrote:
gt; gt;
gt; gt;gt;
gt; gt;gt; quot;Quikquot; lt;Quik @discussions.microsoft.comgt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt;I am currently working on a detailed inventory, but also want to make a
gt; gt;gt; gt; hard-copy version from the list in excel in the form of individual note
gt; gt;gt; gt; cards
gt; gt;gt; gt; for each entry? Are there any shortcuts I could take through excel or
gt; gt;gt; gt; any
gt; gt;gt; gt; other Office programs so that I could just click and print rather than
gt; gt;gt; gt; do
gt; gt;gt; gt; everything manually?
gt; gt;gt; gt;
gt; gt;gt; gt; Any help would be greatly appreciated.
gt; gt;gt; gt;
gt; gt;gt; gt; Thank you.
gt; gt;gt;
gt; gt;gt; I can't help with the software/mail merge part of this, since it's not my
gt; gt;gt; forté, but I have a suggestion for the end result. If you're talking
gt; gt;gt; about
gt; gt;gt; something like index cards, Avery makes those in printable sheets.
gt; gt;gt;
gt; gt;gt; Here's one:
gt; gt;gt; www.avery.com/us/Main?action=...alogcode=WEB01
gt; gt;gt;
gt; gt;gt; I've used their business card sheets and they work flawlessly, at least
gt; gt;gt; in
gt; gt;gt; my printer. Microsoft Word already contains formatting (in Tools,
gt; gt;gt; Envelopes
gt; gt;gt; and Labels) for many Avery products. You choose the product number, and
gt; gt;gt; the
gt; gt;gt; formatting's done for you. If the product isn't listed, the Avery
gt; gt;gt; products
gt; gt;gt; come with extremely easy formatting instructions so you can create a
gt; gt;gt; custom
gt; gt;gt; (and permanent) setting for the card or label on your computer.
gt; gt;gt;
gt; gt;gt; If someone else here can help you copy the data to Word and set up a mail
gt; gt;gt; merge to labels (meaning, the cards, in this case), you're in business.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

Fisher's still around? I used to get stuff from them when, as a kid, my
friends and I were trying to blow up my basement.

quot;Quikquot; gt; wrote in message
news
gt; Thank you to both of you. I have been able to setup the mail merge and
gt; the
gt; notecards. However, I am unable to include the category titles on each
gt; notecard. For example, (It's a chemical inventory):
gt;
gt; Note card reads:
gt;
gt; Acetic Acid, Glacial; Vinegar Acid
gt; C2H4O2
gt; 60.05
gt; Keep Cool, Toxic
gt; Under the Hood
gt; Fisher A38-500
gt; 6 bottles
gt;
gt; But I want:
gt;
gt; Name: Acetic Acid, Glacial; Vinegar Acid
gt; Formula: C2H4O2
gt; Formula Wt: 60.05
gt; Storage: Keep Cool, Toxic
gt; Location: Under the Hood
gt; Co./Catalog #: Fisher A38-500
gt; Supply: 6 bottles
gt;
gt; Thanks again for any assistance and/or suggestions.
gt;
gt;
gt;
gt;
gt;
gt;
gt;
gt; quot;Doug Kanterquot; wrote:
gt;
gt;gt; I didn't know that!
gt;gt;
gt;gt; quot;Marvin P. Winterbottomquot; gt;
gt;gt; wrote in message
gt;gt; ...
gt;gt; gt; You don't have to copy the data to Word, if you do a Mail Merge, you
gt;gt; gt; can
gt;gt; gt; pick
gt;gt; gt; the excel sheet as the data source. Tell it you are doing labels, and
gt;gt; gt; you
gt;gt; gt; should be able to pick the Avery number off a list. It's really pretty
gt;gt; gt; easy.
gt;gt; gt;
gt;gt; gt; quot;Doug Kanterquot; wrote:
gt;gt; gt;
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Quikquot; lt;Quik @discussions.microsoft.comgt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt;I am currently working on a detailed inventory, but also want to make
gt;gt; gt;gt; gt;a
gt;gt; gt;gt; gt; hard-copy version from the list in excel in the form of individual
gt;gt; gt;gt; gt; note
gt;gt; gt;gt; gt; cards
gt;gt; gt;gt; gt; for each entry? Are there any shortcuts I could take through excel
gt;gt; gt;gt; gt; or
gt;gt; gt;gt; gt; any
gt;gt; gt;gt; gt; other Office programs so that I could just click and print rather
gt;gt; gt;gt; gt; than
gt;gt; gt;gt; gt; do
gt;gt; gt;gt; gt; everything manually?
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Any help would be greatly appreciated.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Thank you.
gt;gt; gt;gt;
gt;gt; gt;gt; I can't help with the software/mail merge part of this, since it's not
gt;gt; gt;gt; my
gt;gt; gt;gt; forté, but I have a suggestion for the end result. If you're talking
gt;gt; gt;gt; about
gt;gt; gt;gt; something like index cards, Avery makes those in printable sheets.
gt;gt; gt;gt;
gt;gt; gt;gt; Here's one:
gt;gt; gt;gt; www.avery.com/us/Main?action=...alogcode=WEB01
gt;gt; gt;gt;
gt;gt; gt;gt; I've used their business card sheets and they work flawlessly, at
gt;gt; gt;gt; least
gt;gt; gt;gt; in
gt;gt; gt;gt; my printer. Microsoft Word already contains formatting (in Tools,
gt;gt; gt;gt; Envelopes
gt;gt; gt;gt; and Labels) for many Avery products. You choose the product number,
gt;gt; gt;gt; and
gt;gt; gt;gt; the
gt;gt; gt;gt; formatting's done for you. If the product isn't listed, the Avery
gt;gt; gt;gt; products
gt;gt; gt;gt; come with extremely easy formatting instructions so you can create a
gt;gt; gt;gt; custom
gt;gt; gt;gt; (and permanent) setting for the card or label on your computer.
gt;gt; gt;gt;
gt;gt; gt;gt; If someone else here can help you copy the data to Word and set up a
gt;gt; gt;gt; mail
gt;gt; gt;gt; merge to labels (meaning, the cards, in this case), you're in
gt;gt; gt;gt; business.
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;
Can you just type in the category, then include the field from the excel
database?

Here are a couple of links about using mail merge:
www.mvps.org/dmcritchie/excel/mailmerg.htm
www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.

Quik wrote:
gt;
gt; Thank you to both of you. I have been able to setup the mail merge and the
gt; notecards. However, I am unable to include the category titles on each
gt; notecard. For example, (It's a chemical inventory):
gt;
gt; Note card reads:
gt;
gt; Acetic Acid, Glacial; Vinegar Acid
gt; C2H4O2
gt; 60.05
gt; Keep Cool, Toxic
gt; Under the Hood
gt; Fisher A38-500
gt; 6 bottles
gt;
gt; But I want:
gt;
gt; Name: Acetic Acid, Glacial; Vinegar Acid
gt; Formula: C2H4O2
gt; Formula Wt: 60.05
gt; Storage: Keep Cool, Toxic
gt; Location: Under the Hood
gt; Co./Catalog #: Fisher A38-500
gt; Supply: 6 bottles
gt;
gt; Thanks again for any assistance and/or suggestions.
gt;
gt; quot;Doug Kanterquot; wrote:
gt;
gt; gt; I didn't know that!
gt; gt;
gt; gt; quot;Marvin P. Winterbottomquot; gt;
gt; gt; wrote in message ...
gt; gt; gt; You don't have to copy the data to Word, if you do a Mail Merge, you can
gt; gt; gt; pick
gt; gt; gt; the excel sheet as the data source. Tell it you are doing labels, and you
gt; gt; gt; should be able to pick the Avery number off a list. It's really pretty
gt; gt; gt; easy.
gt; gt; gt;
gt; gt; gt; quot;Doug Kanterquot; wrote:
gt; gt; gt;
gt; gt; gt;gt;
gt; gt; gt;gt; quot;Quikquot; lt;Quik @discussions.microsoft.comgt; wrote in message
gt; gt; gt;gt; ...
gt; gt; gt;gt; gt;I am currently working on a detailed inventory, but also want to make a
gt; gt; gt;gt; gt; hard-copy version from the list in excel in the form of individual note
gt; gt; gt;gt; gt; cards
gt; gt; gt;gt; gt; for each entry? Are there any shortcuts I could take through excel or
gt; gt; gt;gt; gt; any
gt; gt; gt;gt; gt; other Office programs so that I could just click and print rather than
gt; gt; gt;gt; gt; do
gt; gt; gt;gt; gt; everything manually?
gt; gt; gt;gt; gt;
gt; gt; gt;gt; gt; Any help would be greatly appreciated.
gt; gt; gt;gt; gt;
gt; gt; gt;gt; gt; Thank you.
gt; gt; gt;gt;
gt; gt; gt;gt; I can't help with the software/mail merge part of this, since it's not my
gt; gt; gt;gt; forté, but I have a suggestion for the end result. If you're talking
gt; gt; gt;gt; about
gt; gt; gt;gt; something like index cards, Avery makes those in printable sheets.
gt; gt; gt;gt;
gt; gt; gt;gt; Here's one:
gt; gt; gt;gt; www.avery.com/us/Main?action=...alogcode=WEB01
gt; gt; gt;gt;
gt; gt; gt;gt; I've used their business card sheets and they work flawlessly, at least
gt; gt; gt;gt; in
gt; gt; gt;gt; my printer. Microsoft Word already contains formatting (in Tools,
gt; gt; gt;gt; Envelopes
gt; gt; gt;gt; and Labels) for many Avery products. You choose the product number, and
gt; gt; gt;gt; the
gt; gt; gt;gt; formatting's done for you. If the product isn't listed, the Avery
gt; gt; gt;gt; products
gt; gt; gt;gt; come with extremely easy formatting instructions so you can create a
gt; gt; gt;gt; custom
gt; gt; gt;gt; (and permanent) setting for the card or label on your computer.
gt; gt; gt;gt;
gt; gt; gt;gt; If someone else here can help you copy the data to Word and set up a mail
gt; gt; gt;gt; merge to labels (meaning, the cards, in this case), you're in business.
gt; gt; gt;gt;
gt; gt; gt;gt;
gt; gt; gt;gt;
gt; gt;
gt; gt;
gt; gt;

--

Dave Peterson

Thank you for the links, they were very helpful. However, I have one final
question to which I can't find the answer. I have formulas in excel with
subscripts in the cells. After making the mail merge they subscripts are
lost. How do I maintain the formatting from during the merge from excel to
word?

Although I can't show the subscripts here... I want the 2,4, and 2 in C2H4O2
to keep the subcript when being imported into word.

Any help would be greatly appreciated.

Thanks.

quot;Dave Petersonquot; wrote:

gt; Can you just type in the category, then include the field from the excel
gt; database?
gt;
gt; Here are a couple of links about using mail merge:
gt; www.mvps.org/dmcritchie/excel/mailmerg.htm
gt; www.mvps.org/word/FAQs/MailMerge
gt;
gt; The first is from David McRitchie and the second is by Beth Melton and Dave
gt; Rado.
gt;
gt; Quik wrote:
gt; gt;
gt; gt; Thank you to both of you. I have been able to setup the mail merge and the
gt; gt; notecards. However, I am unable to include the category titles on each
gt; gt; notecard. For example, (It's a chemical inventory):
gt; gt;
gt; gt; Note card reads:
gt; gt;
gt; gt; Acetic Acid, Glacial; Vinegar Acid
gt; gt; C2H4O2
gt; gt; 60.05
gt; gt; Keep Cool, Toxic
gt; gt; Under the Hood
gt; gt; Fisher A38-500
gt; gt; 6 bottles
gt; gt;
gt; gt; But I want:
gt; gt;
gt; gt; Name: Acetic Acid, Glacial; Vinegar Acid
gt; gt; Formula: C2H4O2
gt; gt; Formula Wt: 60.05
gt; gt; Storage: Keep Cool, Toxic
gt; gt; Location: Under the Hood
gt; gt; Co./Catalog #: Fisher A38-500
gt; gt; Supply: 6 bottles
gt; gt;
gt; gt; Thanks again for any assistance and/or suggestions.
gt; gt;
gt; gt; quot;Doug Kanterquot; wrote:
gt; gt;
gt; gt; gt; I didn't know that!
gt; gt; gt;
gt; gt; gt; quot;Marvin P. Winterbottomquot; gt;
gt; gt; gt; wrote in message ...
gt; gt; gt; gt; You don't have to copy the data to Word, if you do a Mail Merge, you can
gt; gt; gt; gt; pick
gt; gt; gt; gt; the excel sheet as the data source. Tell it you are doing labels, and you
gt; gt; gt; gt; should be able to pick the Avery number off a list. It's really pretty
gt; gt; gt; gt; easy.
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Doug Kanterquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt; quot;Quikquot; lt;Quik @discussions.microsoft.comgt; wrote in message
gt; gt; gt; gt;gt; ...
gt; gt; gt; gt;gt; gt;I am currently working on a detailed inventory, but also want to make a
gt; gt; gt; gt;gt; gt; hard-copy version from the list in excel in the form of individual note
gt; gt; gt; gt;gt; gt; cards
gt; gt; gt; gt;gt; gt; for each entry? Are there any shortcuts I could take through excel or
gt; gt; gt; gt;gt; gt; any
gt; gt; gt; gt;gt; gt; other Office programs so that I could just click and print rather than
gt; gt; gt; gt;gt; gt; do
gt; gt; gt; gt;gt; gt; everything manually?
gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt;gt; gt; Any help would be greatly appreciated.
gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt;gt; gt; Thank you.
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt; I can't help with the software/mail merge part of this, since it's not my
gt; gt; gt; gt;gt; forté, but I have a suggestion for the end result. If you're talking
gt; gt; gt; gt;gt; about
gt; gt; gt; gt;gt; something like index cards, Avery makes those in printable sheets.
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt; Here's one:
gt; gt; gt; gt;gt; www.avery.com/us/Main?action=...alogcode=WEB01
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt; I've used their business card sheets and they work flawlessly, at least
gt; gt; gt; gt;gt; in
gt; gt; gt; gt;gt; my printer. Microsoft Word already contains formatting (in Tools,
gt; gt; gt; gt;gt; Envelopes
gt; gt; gt; gt;gt; and Labels) for many Avery products. You choose the product number, and
gt; gt; gt; gt;gt; the
gt; gt; gt; gt;gt; formatting's done for you. If the product isn't listed, the Avery
gt; gt; gt; gt;gt; products
gt; gt; gt; gt;gt; come with extremely easy formatting instructions so you can create a
gt; gt; gt; gt;gt; custom
gt; gt; gt; gt;gt; (and permanent) setting for the card or label on your computer.
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt; If someone else here can help you copy the data to Word and set up a mail
gt; gt; gt; gt;gt; merge to labels (meaning, the cards, in this case), you're in business.
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;

I don't know if you can actually keep that kind of format.

Debra Dalgleish posted this to a similar question about formatting
dates/decimals.

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
office.microsoft.com/en-ca/as...164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions he

sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm

about half way down the page.========
I've never tried that with sub/superscripts. I don't know if it'll work.

I would think that MSWord would have to be pretty smart to do this. You may
want to post in one of the MSWord newsgroups for real answers.Quik wrote:
gt;
gt; Thank you for the links, they were very helpful. However, I have one final
gt; question to which I can't find the answer. I have formulas in excel with
gt; subscripts in the cells. After making the mail merge they subscripts are
gt; lost. How do I maintain the formatting from during the merge from excel to
gt; word?
gt;
gt; Although I can't show the subscripts here... I want the 2,4, and 2 in C2H4O2
gt; to keep the subcript when being imported into word.
gt;
gt; Any help would be greatly appreciated.
gt;
gt; Thanks.
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Can you just type in the category, then include the field from the excel
gt; gt; database?
gt; gt;
gt; gt; Here are a couple of links about using mail merge:
gt; gt; www.mvps.org/dmcritchie/excel/mailmerg.htm
gt; gt; www.mvps.org/word/FAQs/MailMerge
gt; gt;
gt; gt; The first is from David McRitchie and the second is by Beth Melton and Dave
gt; gt; Rado.
gt; gt;
gt; gt; Quik wrote:
gt; gt; gt;
gt; gt; gt; Thank you to both of you. I have been able to setup the mail merge and the
gt; gt; gt; notecards. However, I am unable to include the category titles on each
gt; gt; gt; notecard. For example, (It's a chemical inventory):
gt; gt; gt;
gt; gt; gt; Note card reads:
gt; gt; gt;
gt; gt; gt; Acetic Acid, Glacial; Vinegar Acid
gt; gt; gt; C2H4O2
gt; gt; gt; 60.05
gt; gt; gt; Keep Cool, Toxic
gt; gt; gt; Under the Hood
gt; gt; gt; Fisher A38-500
gt; gt; gt; 6 bottles
gt; gt; gt;
gt; gt; gt; But I want:
gt; gt; gt;
gt; gt; gt; Name: Acetic Acid, Glacial; Vinegar Acid
gt; gt; gt; Formula: C2H4O2
gt; gt; gt; Formula Wt: 60.05
gt; gt; gt; Storage: Keep Cool, Toxic
gt; gt; gt; Location: Under the Hood
gt; gt; gt; Co./Catalog #: Fisher A38-500
gt; gt; gt; Supply: 6 bottles
gt; gt; gt;
gt; gt; gt; Thanks again for any assistance and/or suggestions.
gt; gt; gt;
gt; gt; gt; quot;Doug Kanterquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I didn't know that!
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Marvin P. Winterbottomquot; gt;
gt; gt; gt; gt; wrote in message ...
gt; gt; gt; gt; gt; You don't have to copy the data to Word, if you do a Mail Merge, you can
gt; gt; gt; gt; gt; pick
gt; gt; gt; gt; gt; the excel sheet as the data source. Tell it you are doing labels, and you
gt; gt; gt; gt; gt; should be able to pick the Avery number off a list. It's really pretty
gt; gt; gt; gt; gt; easy.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;Doug Kanterquot; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;gt;
gt; gt; gt; gt; gt;gt; quot;Quikquot; lt;Quik @discussions.microsoft.comgt; wrote in message
gt; gt; gt; gt; gt;gt; ...
gt; gt; gt; gt; gt;gt; gt;I am currently working on a detailed inventory, but also want to make a
gt; gt; gt; gt; gt;gt; gt; hard-copy version from the list in excel in the form of individual note
gt; gt; gt; gt; gt;gt; gt; cards
gt; gt; gt; gt; gt;gt; gt; for each entry? Are there any shortcuts I could take through excel or
gt; gt; gt; gt; gt;gt; gt; any
gt; gt; gt; gt; gt;gt; gt; other Office programs so that I could just click and print rather than
gt; gt; gt; gt; gt;gt; gt; do
gt; gt; gt; gt; gt;gt; gt; everything manually?
gt; gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt; gt;gt; gt; Any help would be greatly appreciated.
gt; gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt; gt;gt; gt; Thank you.
gt; gt; gt; gt; gt;gt;
gt; gt; gt; gt; gt;gt; I can't help with the software/mail merge part of this, since it's not my
gt; gt; gt; gt; gt;gt; forté, but I have a suggestion for the end result. If you're talking
gt; gt; gt; gt; gt;gt; about
gt; gt; gt; gt; gt;gt; something like index cards, Avery makes those in printable sheets.
gt; gt; gt; gt; gt;gt;
gt; gt; gt; gt; gt;gt; Here's one:
gt; gt; gt; gt; gt;gt; www.avery.com/us/Main?action=...alogcode=WEB01
gt; gt; gt; gt; gt;gt;
gt; gt; gt; gt; gt;gt; I've used their business card sheets and they work flawlessly, at least
gt; gt; gt; gt; gt;gt; in
gt; gt; gt; gt; gt;gt; my printer. Microsoft Word already contains formatting (in Tools,
gt; gt; gt; gt; gt;gt; Envelopes
gt; gt; gt; gt; gt;gt; and Labels) for many Avery products. You choose the product number, and
gt; gt; gt; gt; gt;gt; the
gt; gt; gt; gt; gt;gt; formatting's done for you. If the product isn't listed, the Avery
gt; gt; gt; gt; gt;gt; products
gt; gt; gt; gt; gt;gt; come with extremely easy formatting instructions so you can create a
gt; gt; gt; gt; gt;gt; custom
gt; gt; gt; gt; gt;gt; (and permanent) setting for the card or label on your computer.
gt; gt; gt; gt; gt;gt;
gt; gt; gt; gt; gt;gt; If someone else here can help you copy the data to Word and set up a mail
gt; gt; gt; gt; gt;gt; merge to labels (meaning, the cards, in this case), you're in business.
gt; gt; gt; gt; gt;gt;
gt; gt; gt; gt; gt;gt;
gt; gt; gt; gt; gt;gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson