MacroPaul -

After several false starts with this project, I've concluded that my original design was too general and restrictive for the user. My thrust now with this is to use a couple of label template Word docs I've created, one for 8-labels per (Avery) page, and another for 10-labels, using a different blank label stock.

My initial approach denied the user the opportunity of a final edit of the labels prior to printing them - what was in the db was what would print - warts and all.

Late into development of the project, I learned that sometimes there is a need to print multiple copies of the same label, along with single prints of the others. How to address this possibility is the main thing that has caused me to step back and redesign the project.

And the approach I'm now pursuing is to create a How To Print Labels document for the user:

If you're printing Single Labels, the db itself becomes the input file.
If you're printing Multiple Labels -

• Extract from the db to a spreadsheet just the records you want to print.
• Edit the spreadsheet to create multiples (this will be the input file to the label-printer).

Click the appropriate 8- or 10-labels per page Desktop shortcut, bringing up the correct template.
Select the appropriate input file and recipients.
Edit the labels in the label-formatted file being sent to the printer.
Print them.
Voilà!

Done.

So, no macros, no subroutines - just a clear, hand-holding document for the user. Let's see if I can make it simple and clear enough for even our music librarian ingénue.

Thanks again for your help, Paul.