How to create address labels with a Mail-Merge with Excel and Word

With the Holidays right around the corner, many people have asked the quickest and easiest way to generate labels is to use a mail merge with Excel and Word.

If you create your data in an Excel sheet - remember to use the following in each cell:

• First name 
• Last Name
• Address
• City
• State
• Zip Code

From there you will need to open up Word and follow these instructions:

• Mailings - Start Mail Merge - Labels (choose your Vendor and product number (I am using Avery 5160 labels)
• Select Recipients - Use an Existing List - Choose your Excel Sheet - then select ok
• In 1st "open" field select Insert Merge Field
• Here is where you select your cells - remember to put a space between First name and Last name - enter - Address - enter - city - space - state - space - zip
• Select preview results (here is where you can adjust size and style of font and anything else you would like to chance
• Select update labels - and you will see all your labels appear
• Select Finish & Merge - Edit individual document - Merge records - All - ok
• Save your doc and print away!

Embedded below is a GIF followed by a 2 minute and 11 second YouTube tutorial.

Take care,

Brad