Print labels for items received on receiving report

[leaning]

Hello!

Before I try to tackle this new project, I wanted to check with you guys/gals for setup guidance.

1. Warehouse receives parts from suppliers.
2. Warehouse inspects each part and documents part info and how many are acceptable and how many are unacceptable.
3. Warehouse (now) hand-writes a paper tag with the same information that is on the Receipt Log and affixes it to the items.

Notes:

1) For small items (nuts, bolts), one tag could be affixed to cover 20 items in a Ziplock bag. So qty of items does not necessarily correspond to qty of tags.

2) 3 tags (Accepted, Hold, uNacceptable). A-tags are always by themselves. If an H or N tag is needed, an A tag needs to be printed with it.

Bottom Line: We would like to automate printing of tags using the information that has already been entered in the Receipt Log.

I was thinking of doing it this way:

1) User selects rows to copy.
2) Button copies rows to other sheet.
3) Mail merge to Word from other sheet.
4) Word prints to labels.
5) Peel off labels and stick to paper tags.

Other problems: If the user wants to just print one tag, how can the user tell the printer which location of an Avery label sheet gets that tag?

I started a workbook which has a tag template (more-or-less) on it.

Anyone know of anything out there already like this? Any recommendations from the forum on how to set this up?

??

Lost