You can do a mail merge in Microsoft Word and Excel to create personalized documents for many recipients at once. You can import an Excel data table into Word to customize your template with names ...

You can import an Excel data table into Word to customize your template with names and addresses. Mail merge helps you quickly create auto-personalized letters, envelopes, labels, and more.

We show you how to clean up and prepare your data for the big mail merge, everything from trimming unnecessary data fields to setting up record ID numbers.

In part three, you're finally ready to use the data you exported from Outlook to Excel, to create a mail merge with a Word document.

You can copy and paste objects to link or embed data from a worksheet or you can merge data from an Excel table into a Word form. The method you choose depends on your desired outcome.

If your source data is in Excel and has duplicates, run Power Query to remove those duplicates before running a Word mail merge.

Microsoft Excel’s mobile app lets you to take a picture of a table and paste the data directly into your spreadsheet. Here's how to use it.