Creating Labels Using Data from Excel        
Movies.  Use controls or refresh for replay Please read all directions carefully Mistakes? We can't fix them if you don't let us know

This set of instructions takes you step-by-step through the process of creating labels using data from an excel spreadsheet.  Note that this can also be accomplished with an Access database file as well, but for simplicity sake, these in

 

Complete your Excel  file of data and close.

 		  
Open Word.  On the Mailings ribbon, click Start Mail Merge.

In Label vendors, click the  and choose Avery.   (unless you have labels from another company)

Then, in the product number choose the number of the Avery label.    5160 is one of the most common labels 
Next, click on Select Recipients, and choose Use Existing List

Go to where your Excel file is saved.

Double-click on the file 
Your data will normally be on
Sheet 1

Click the Okay button
In the Insert Merge field, choose the field you wish to be on the label. 

Don't forget to put spaces where necessary

Once all the fields are in, you can

  • highlight all the fields,

  • right-click,

  • choose font, and

  • change any of the font attributes you wish

 
Click Update Labels

 

 

 

 
Click the finish and Merge and choose Edit Individual Documents.

Press Okay

 
  At this point, a new document opens.  You can then:
  • Print
  • Delete any individual data
  • Save for later use
  
This page last updated:  Tuesday September 22, 2009

Questions regarding this page?  Click here