How to Create LABELS in Microsoft Word Using Mail Merge | Use Data From Microsoft Excel

Whether you’re mailing holiday cards or sending invitations to a wedding, you need a way to easily create mailing labels. Microsoft Word makes this easy to do, using a mail merge that pulls address information from Microsoft Excel.

In a hands-on demo, I’ll show you how to:
00:00 – Video intro
00:12 – Set up address information in Microsoft Excel
00:49 – Find a mailing label (using Avery 5160 as an example)
01:13 – Create a new label template in Word
02:23 – Select recipient information, pointing to addresses in Excel
03:36 – Insert merge fields
05:10 – Complete the mail merge

If you're having issues with blank lines from missing data, check out this video: https://youtu.be/8OnlUNIBAlY

And if you want to do mail merge on invitations, you might find this helpful: https://youtu.be/4dVByG70b5M

Видео How to Create LABELS in Microsoft Word Using Mail Merge | Use Data From Microsoft Excel канала Tiny Technical Tutorials