Attempting to automate mail labels

There are two possible approaches to this problem that immediately spring to mind, use a:
1. mailmerge; or
2. macro

With a mailmerge, you'd use an Excel workbook as the data source. To populate the Excel workbook, you might type the variable data into a cell, then copy down as far as needed, or you might pre-populate the workbook with a formula like =A2 in cells A3 and copied to all cells below (row 1 is the mailmerge header row), then simply type the variable data into cell A2, go down however many rows you need, type another variable data into the next cell, and so on.

With a macro, you'd need it to do something like: solicit the variable, then the number of labels, populate those labels, then go to the next label and repeat the process until the user exits. This gets a bit complicated if you use label stationery that calls for a table in which there are gaps between the cells that get populated and/or you need more than a single page of labels, or if you want to start anywhere other than the first label. The user also needs to learn how to run macros (not at all difficult).

Thanks for the response Macropod.

I worked out a way to do it, but I will post my steps just in case anybody else comes across this.

• In excel I created a Userform that has all the spaces Customer, C/O, Address, City, State, Zip.
• Made it to where the userform inputs the data into rows when you hit the submit button (that way if they need multiple of the same they can just hit the button X times)
• Set up a button to create the mail merge.
• The button opens up the word file that has the addresses set up they way I want them and creates the labels in a new word document.

Should be easy for them to work since its just buttons and userform, so they really don't have to know how to do a macro.