If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Label template for price of item(s)
I am looking for a way to print price labels for items along with item number
and description. I would like to use the information that I can export from QuickBooks into Excel, but be able to set up a macro or something akin that would allow me to poll the quantity on hand to determine the correct number of labels for each item. It would be nice also to key in number of labels needed for each item in the event of a missing or torn label. I make mailing labels frequently from our customer list. I think of this as being similar, except I want to have various quantities printed and not just one of each, two of each, etc. I am open to your suggestion and can use Word, Excel or Publisher to make pricing labels. |
#2
|
|||
|
|||
Hi =?Utf-8?B?UmljaG1vbmQgQmx1ZXByaW50ICYgU3VwcGx5?=,
as far as Word and mail merge are concerned, there's really no built-in way to do this during the merge process. "Easiest" would probably be a macro in Excel that would copy the label information for as many labels as required, so that mail merge just processes the all the items. Anything else would mean avoiding mail merge completely, and just doing it all with a macro. And in that case, you could probably stay in Excel. I am looking for a way to print price labels for items along with item number and description. I would like to use the information that I can export from QuickBooks into Excel, but be able to set up a macro or something akin that would allow me to poll the quantity on hand to determine the correct number of labels for each item. It would be nice also to key in number of labels needed for each item in the event of a missing or torn label. I make mailing labels frequently from our customer list. I think of this as being similar, except I want to have various quantities printed and not just one of each, two of each, etc. I am open to your suggestion and can use Word, Excel or Publisher to make pricing labels. 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 :-) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Avery 5266 template | Stephanie Smith | General Discussion | 5 | December 14th, 2004 05:19 PM |
How do I find a label template to make different address labels o. | jf | General Discussion | 1 | December 8th, 2004 01:41 AM |
Problems with Word 2003 | Chloe | Formatting Long Documents | 4 | July 17th, 2004 12:56 AM |
Adding a Downloaded Template into Template Wizard | Tennisman1939 | General Discussion | 3 | May 30th, 2004 01:14 AM |