Microsoft word 2016 mail merge envelopes free.Mail merge with envelopes

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Then the Merge to Printer dialog is displayed, please select a print records to meet your need and finally click OK. Note: The other languages of the website are Google-translated. Back to English. Log in. Remember me. About Us Our team.

How to create and print envelopes from the mailing list in Word? Insert multiple images across folders into Word document at once. Merge and combine multiple Word files across folders into one with your desired order.

Split the current document into separate documents according to heading, section break or other criteria. Convert files between Doc and Docx, Docx and PDF, collection of tools for common conversions and selection, and so on Read More Download Now Purchase. Oldest First. Sort comments by. Newest First. Comments 0. No ratings yet. Be the first to rate! There are no comments posted here yet. Leave your comments. Posting as Guest.

Name Required. Email Required. Rate this post:. Suggested Locations. I agree to the terms and condition. Cancel Submit Comment. When you run a mail merge, your Excel file will get connected to your Word document, and Microsoft Word will be pulling the recipient details directly from the connected worksheet.

Before running a mail merge in Word, make sure your Excel file has all the information you want to include such as first name, last name, salutation, zip codes, addresses, etc.

If you want to add more details, you’d better do this before starting the merge. Here’s an example of an Excel sheet that can be used for a mail merge:. Once the source data spreadsheet is set and reviewed, you are ready to run the mail merge. In this example, we will be merging letters. For email messages, the steps will be essentially the same.

By setting the connection between your Excel sheet and the Word document you ensure that your mail merge data source will be automatically updated each time you make changes to the Excel file that contains the recipient details.

Refine the recipient list. The Mail Merge Recipients dialog pops up, and you check or uncheck checkboxes to add or remove the recipients from the mail merge. You can also sort, filter and dedupe the recipients list as well as validate the email addresses by clicking the corresponding option under Refine Recipients List.

When the recipients list is finalized, you are ready to start on the letter. Add Address Block and Greeting Line. Now it’s time to add placeholders for the Address Block and Greeting Line for Mail Merge to know exactly where to place that data. Depending on which merge field you are inserting, a dialog box will appear with different options.

Select the ones that work best for you, observe the results in the Preview section and click OK. To switch to the next or previous recipient, use the right and left arrows. If Word pulls wrong information from the Excel file, click the Match Fields button to match a specific field. When done, the merge field placeholders will appear in your document like shown in the screenshot below:.

In other situations, you may wish to insert more merge fields to personalize your letters a little further. To do this, place the cursor exactly where the personal information should appear in the letter, click the Insert Merge Field button on the ribbon, and choose the field from the drop-down list.

If a merge field is inserted within the text, make sure there are spaces on both sides of it:. Once saved, the file will stay connected to your Excel mailing list.

When you want to use the mail merge document again, open it and click Yes when Word prompts you to retain that connection. In addition to the options accessible on the ribbon, the same features are available in the form of the Mail Merge Wizard. Once clicked, the Mail Merge pane will open on the right side of your document and walk you through the process step-by-step.

In my opinion, working with the ribbon is more convenient as it lets you use exactly the feature you need at the moment. When doing the mail merge for the first time, the wizard’s step-by-step guidance may come in helpful. For Word Mail Merge to recognize fields correctly, you need to be very specific with the column names in your Excel file. This is especially true for the Address Block and Greeting Line features. If your data source in Excel has different column names, you will have to match the fields manually.

Here’s how:. In the screenshot below, we’ve matched the Street column from our Excel source data file to the Address 1 : Mail Merge shortcuts If you do a mail merge in Word on a regular basis, learning a few shortcuts can save you quite a lot of time and make you more productive.

Hopefully, this information has been helpful, and now you know how to perform mail merge from Excel to Word correctly. Thank you for reading!

 
 

 

Microsoft word 2016 mail merge envelopes free. How to Use Mail Merge in Word to Create Letters, Labels, and Envelopes

 
Choose Print , and then choose Yes to save the return address as the default address. You can use the wizard if you want to, but this can be faster.