Label template for price of item(s)

[Richmond Blueprint & Supply]

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 M -WordMVP-]

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