Generate labels in particular format from table of data

[e_esgee]

Hi there, fine folks!

I would like to generate labels for an envelope from a table of data. I have the table of data in a worksheet within a workbook formatted to have the six columns of information. This worksheet is called LabelPrep. I formatted a second worksheet called Labels to look like a series of address labels with each field corresponding to a field from the LabelPrep worksheet. I'm curious how to write the code for a macro that takes the information from the LabelPrep table and inserts it into the appropriate fields in the Labels worksheet.

In a dream world there could be an extra column in the LabelPrep worksheet that indicated how many of each type of label and the macro could read that and prepare the correct number of labels! This feels like wishful thinking but it can't hurt to put it out there!

Can you help?

 

[mumps]

Excel does not have a built-in label creator but Microsoft Word does have one. Do a little research into creating labels using "Mail Merge" in Word. The process allows you to select an Excel file that contains the data that is to be placed on the labels and the type and size of labels you want to use.

 

[e_esgee]

Howdy, Mumps! Thanks for the tip. I'm very familiar with Mail Merge. However, I would like to further automate the process since I make thousands of different labels per week and don't want to go through the step by step MailMerge process each time, hence the desire for a macro that knocks the process down to one step, ideally.

Excel does not have a built-in label creator but Microsoft Word does have one. Do a little research into creating labels using "Mail Merge" in Word. The process allows you to select an Excel file that contains the data that is to be placed on the labels and the type and size of labels you want to use.