200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Is it possble to create mailing address labels from within data from an excel document? For example: if I have a document with rows and columns including individuals names and addresses, can it be pulled out to format a label for printing on a peel off sheet?
Example: Jane Doe, 1234 Walking Trail, Mudville, Iowa 12345
Before you can print a label you must create it onscreen. If it's a single label you want you can link strategically selected cells on a sheet to your data. Normally, however, you will want to print a sheet of labels at a time. The task is still the same but correspondingly bigger.
Next comes the task of managing the flow of data. The links must change to the next data row or the next set of data rows when a sheet has been printed. That's quite complex. I don't think anyone will recommend that you actually do it because Word has a ready program for that called MailMerge. The better way, therefore, is to prepare the list of addresses in Excel and then invoke Word's MailMerge to print the labels.
The process is described here.
