Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make note cards from an inventory in excel?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make note cards from an inventory in excel?
"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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make note cards from an inventory in excel?
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make note cards from an inventory in excel?
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make note cards from an inventory in excel?
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make note cards from an inventory in excel?
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. :) "Quik" wrote in message ... 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 merge to labels (meaning, the cards, in this case), you're in business. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make note cards from an inventory in excel?
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: http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMerge The first is from David McRitchie and the second is by Beth Melton and Dave Rado. Quik wrote: 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. -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make note cards from an inventory in excel?
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. "Dave Peterson" wrote: 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: http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMerge The first is from David McRitchie and the second is by Beth Melton and Dave Rado. Quik wrote: 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. -- Dave Peterson |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make note cards from an inventory in excel?
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 http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://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: 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. "Dave Peterson" wrote: 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: http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMerge The first is from David McRitchie and the second is by Beth Melton and Dave Rado. Quik wrote: 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. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a 3-dimensional plot in Excel? | Charts and Charting in Excel | |||
How do i change info in all my cust cards in excel in one go | Excel Discussion (Misc queries) | |||
Excel formula to make AAA-BBB equal to/consistent with BBB-AAA | Excel Worksheet Functions | |||
How do I make a time Stamp in excel? | Excel Discussion (Misc queries) | |||
How to make one CSV file from two Excel sheets? | Excel Discussion (Misc queries) |