Creating Mailing Labels in Office 2010

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.

    • Related Articles

    • Creating and switching chrome profiles

      Having different profiles in Chrome can be very helpful if you have multiple Google accounts. It lets each have their own Chrome instance and can make switching very easy. You can click the little circle in the upper right to expand the menu for ...

    • Creating Contact Group + Categories in Outlook

      Open Outlook Go into the Contacts section Click New Contact Group Name the Group Click Categorize at the Top >> All Categories Click New Name the Category Hit OK Add members Click Save and Close on the Group (upper left)

    • Foxit Phantom Basics

      Please Note: Videos in this article will not play if you are using Internet Explorer due to a lack of HTML 5 support. I recommend Google Chrome. New versions of foxit have 2 toolbar modes, Classic and Ribbon. Ribbon it the one this training will be ...

    • Recommended Application Setup for the Home User

      There are a lot of programs out there for nearly anything you would want to ever do. Here are my recommendations for the basics. Email Program - Web based Gmail Interface. As far as email goes. I'm a die hard Gmail user. I prefer to use Gmail ...

    • A little more love!

      For a long time, we've wanted to give as much benefit to our service as possible. In an effort to do so, we're now crediting you for your favorite service for free included with our Support Plan price! Netflix Office 365 Hulu Gsuite (Google Business) ...