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

preview_player
Показать описание

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.

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
*************************************
------------------------
Рекомендации по теме
Комментарии
Автор

Best tutorial I've seen!! Every year I go to print Christmas labels and I search for the instructional video or instructions to do it and every year I struggle. Not this year!! I have saved this video and will refer to it time and time again! Also loved the little tidbits nobody else has ever passed along like changing the cell margins and spacing between lines. Bravo!

andreawymer
Автор

You just saved me blood, sweat, and oh, so many tears. Bless you.❤

gracedavis
Автор

Direct and straight to the point. Thank you for the Tutorial.

tmriley
Автор

Step by step directions. Easy to follow and understand.

KristinaPruett
Автор

This was one of the most thorough and helpful tutorial's I've seen in a long time! Thank you!

BaysideHousing
Автор

This is exactly what I needed. When I last searched for this information, the demonstration used the wizard and that did not work for me. I needed the full process. Thanks again!

michaelmatthews
Автор

Yours is one of the better vids on how to use mailmerge features.

nickt
Автор

Super easy tutorial and exactly what I was looking for! Thank you so much!

kae
Автор

You by far explained the merge/label process the best!!

karendavenport
Автор

That was EXCELLENT! I spent 2 hours trying to print labels and just watched this great video and it got the job done!

donnalandry
Автор

Thank You!
You explain very well. Easy to understand.

lupitacardenas
Автор

FANTASTIC VIDEO!!!! Precise and to the point, very helpful!

Homesbyhelenkburke
Автор

This was very concise and extremely helpful. Just what I needed! Thank you!!!

vanessastafford
Автор

Thanks for taking the time to do this. Great little tutorial to get off the ground.

subharmonicj
Автор

This was the best how-to video. It literally covered every issue I was having. Thank you!!

cvfkufz
Автор

Absolutely brilliant video - very clear and easy to follow. Thank you so much.

GlitzyPixie
Автор

Easily showed me how to do it! Simple and quick. Thank you!

qqortqk
Автор

Thank you - thank you - thank you! Very clear instructions! Was going around in circles - again thank you!

sheilalussier
Автор

Could done with this a month ago. I was going round in circles then. Thanks for the clear explanation.

tinplategeektoo
Автор

Perfect. Fast, easy, exactly what I needed.

bexboster