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:
Increase more than 500% of Email Subscribers!
Your Information will never be shared with any third party.
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?
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!
Subscribe below to our latest articles.
Every 10th subscriber will get a year of data backups via Backblaze on us! :)
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:

Email Us:
[email protected]
We're here to help!
We have some love to share!
Leave us your info and we'll reach out!

We're here to help!
Our goal is to see you happy!
Please don't hesitate to ask questions if you have any!