Create Labels from a List in Excel | Mail Merge Labels from Excel to Word | Print Avery Labels

In this video I demonstrate how to print labels from an Excel list. This can easily be achieved using Microsoft Word’s mail merge feature. Microsoft Word includes built-in templates for labels such as Avery labels.

Click here to download the featured file.

Video Table of Contents

00:00 Introduction

00:06 Set up your list of recipients in Excel

00:25 Select the correct label template in Word

01:18 Connect your labels to your Excel file

02:04 Insert merge fields into your labels

03:36 Add padding to your labels

03:58 Update all labels

04:10 Preview and print your labels

Click Here for Free Excel Templates

Enrol in Simple Sheet's Excel University - FREE Taster Course

All purchases help to support this blog - thanks!

Click Here to Buy Mediocre Wall Art (& Other Tat) by Chester Tugwell

ON-SITE OR ONLINE TRAINING

0800 612 4105

info@bluepecan.co.uk

Visitors from YouTube, please click here before you contact us.

Tina McGrath

2022-04-26

Chester was a great trainer, I personally learnt so much in one day and it was all down to his calm, friendly demeanour and huge knowledge - we covered many areas which will help us to develop ourselves and the work we do. Thank you Chester, was lovely to meet you 🙂

emmie BL

2022-04-21

Myself and my team had an absolutely fab day with Chester going over excel - it was quite revelatory, with lots of really helpful hints & tips, great clear explanations and plenty of time to ask questions. Being able to work on things in real time, use our own data spreadsheets and his practice ones and have things properly explained has been so useful. Chester's a great instructor/facilitator - pitches to your needs and is very flexible. I would completely recommend him if you're needing to get a grip on all things excel! Thanks very much, Chester!

Martyn Lee

2022-02-28

Chester was a great tutor understanding our needs and allowing time to understand and digest. Great humor too which always lightens a training day. Look forward to another session soon.

Angus Brown

2022-02-25

Detailed, informative and fun, Chester made the class enjoyable and engaging - i have learnt a huge amount from the time we had together

Sisii de Winter

2022-02-25

We booked Chester for several in-house training sessions including Fundamentals, Intermediate and Advanced Excel. He was brilliant with each, very inclusive and patient with all team members. Would fully recommend.

Lucy Maxwell Scott

2021-10-01

A great online one on one intermediate training session in excel - the tools and activities Chester has developed and used are great. His teaching style was highly responsive to my needs (applications I wanted, my learning style). I would strongly recommend him - whatever your level of excel expertise and whatever level you are aiming for!

Louise Walpole

2021-07-14

The online Excel Intermediate course I attended was really high quality. It was pitched at the right level with opportunity to work through examples as part of the course. Course material and follow up support has been excellent. I would highly recommend.

Savannah Baldry

2021-07-14

Excellent training with Chester who's both knowledgeable and a great teacher. He takes the time to make sure you've understood before moving on and I was lucky enough to get some bespoke training specific to my needs. Thanks very much

ECA Account

2021-07-09

I had an intermediate/bespoke excel course with Chester back last year, and enjoyed it so much and thought so highly of the course, I subsequently arranged beginners, fundamentals, intermediate excel courses and Microsoft PP/word courses for my colleagues. Even in a virtual setting Chester is clear in his delivery and guidance, exceptionally knowledgeable, and very adaptable to ever changing attendee lists or capabilities and requirements within the team. It will be great to put our new skills to good use. My advise to people, would be to take notes! Thanks Chester! Kathryn P.

Roofing Contractors Cambridge Ltd

2021-07-08

An employee recently completed an online days training with Chester. He thoroughly enjoyed it and had a great learning experience. Fully recommend Blue Pecan Computer Training and would definitely use them again for future training.

Chester Tugwell
Owner and Course Trainer

Blue Pecan Computer Training Limited
Registered Office: Piper House 4 Dukes Court, Bognor Rd, Chichester, West Sussex. PO19 8FX

Registered in England and Wales No. 8004610