how to mail merge labels from excel into word

The mail merge wizard leads me through the steps to complete the merge for letters, emails, envelopes and labels.įormatting in merge fields can be an issue as the formatting applied in Excel doesn't carry over to Word. In this video I look at performing a mail merge where my contact list is in Excel and my mail merge document is in Microsoft Word. This helps support the channel and allows us to continue to make videos like this. Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. ✉ Not sure which of my Excel courses fits best for you? Take the quiz: 🤍 With Mail Merge you can send HTML emails to each person and also send a separate Word file as an attachment.Ġ0:00 How to Send Bulk Emails Using Mail Merge in Microsoft WordĠ5:30 How to Format Date, Currency and Number during Mail MergeĠ9:50 Mail Merge to email with attachment This way you can send personalized invoices to you customers. We'll setup an example where the source data will be in Excel and we will connect each row of data to different places in the Microsoft Word document. This tutorial will save you a lot time and will teach you the basics of Mail Merge. You'll learn how to perform a mail merge in Microsoft Word from Microsoft Excel in order to produce mass mailings to a group of people. This way you can create a batch of documents like personalized emails, letters and envelopes for each recipient.

In this tutorial you'll learn how to link Excel data to Word using Mail Merge.

How to mail merge labels from excel into word