Text us: 480.389.6596

Creating Mailing Labels in Office 2010

This will assume you have an excel file with all the names and addresses.

  1. Click the mailings tab.
  2. Click Start Mail Merge
  3. Click Labels
  4. Select the closest matching. Commonly 30 per page, find it in the left side.
  5. Click details and make sure the sizes match the labels you have.
  6. Click OK
  7. Click OK again
  8. Click Select Recipients >> Use Existing List
  9. Find your Excel doc and select it
  10. Select the first label and Click Address Block. If your preview doesn’t look right, click Match Fields.
    1. If the first and last name are in the same cell, just match it to the first name.
  11. Click Ok once previewing the labels.
  12. You should now see Address block in the first label and a bunch of Next Record on the rest.
  13. Click Update Labels on the top bar.
  14. Click Preview results to see how it will look
  15. When it looks acceptable, click finish and merge and select your desired option.
%d bloggers like this:
COMPANY NAME
CONTACT US
Dolor aliquet augue augue sit magnis, magna aenean aenean et! Et tempor, facilisis cursus turpis tempor odio putonius mudako empero brutto populius giten facilisis cursus turpis balocus tredium todo.
Thank You. We will contact you as soon as possible.
Worry No More!
Complimentary Threat Analysis







Got a Question?
DISCLAIMER
By communicating with me, downloading my installer or scheduling with me in any way shape or form you hold me free of any and all liability, confirm you understand my rates, FAQ, as well as agree to my terms of service and hiring.
We're here to help!
To prove it, just by visiting the site you can get FREE data backups and a COMPLIMENTARY threat checkup.
Our goal is to see you happy!
Text Us:
480.389.6596

Email Us:
[email protected]
Click above to schedule an appointment for a free consult and a month free of our worry free plan.
Our goal is to see you happy!
Text Us:
480.389.6596

Email Us:
[email protected]