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
