Skip to content

5000+ Great Articles

Best Articles & Essays: Interesting Articles to Read Online

  • Android Chrome Browser Supports Dark Theme How-To
  • screen brightness keeps changing windows 10 Windows
  • How to fix memory leaks in Windows 10 Windows
  • Best calculator small 2020 black
  • How To Powerwash (Factory Reset) a Chromebook How-To
  • iPhone External Storage: 4 Best Flash Drives For iPhone Hardware
  • How To Find & Upgrade 32-Bit Apps On Your Mac OS X
  • How to Restore a Folder that has Turned into a Package in OS X OS X

how to do a mail merge in word for letters

Posted on October 8, 2021October 8, 2021 By blog_786 No Comments on how to do a mail merge in word for letters

how to do a mail merge in word for letters.

Merge letter is a feature of Microsoft Word that helps to simplify the creation of personalized letters, labels, envelopes, emails, and catalogs. Since letter merging is not among the most commonly used features in MS Word, some users may not know how to merge letters in Word to create letters, labels, and envelopes.

If you’re trying to save the time spent manually customizing each letter, label, or another document, mail merge may come in handy. Even if you’ve never tried to create a mail merge letter, the process is pretty simple and we’ll walk you through each step below.

how to do a mail merge in word for letters

How to Create Mail Merge Letters

Microsoft Word has a wizard that walks you through creating mail merge letters. The wizard will ask for the letter you want to use and the recipients of the letter, so make sure you have a list of recipients ready to be pasted. If you don’t, you can always add the recipient list manually.

  1. Open a Word document and enter your message. Leave personalized elements (like title, name, city, etc.). For now, you can just leave a blank space where you want to insert these elements, for example:

how to do a mail merge in word for letters

  1. When your template is ready, select Mailings> Start Mail Merge> Step-by-Step Mail Merge Wizard on the top ribbon.

how to do a mail merge in word for letters

  1. A new panel will appear along the right border of the MS Word window. This is the wizard who guides you through the entire process. In the first step, you will need to choose the type of document you are working on. Select “Letters” and select “Next: Source Document”.

how to do a mail merge in word for letters

  1. You will need to select the document you want to use for the mail merge next.
    If you have already entered some content for your letter, select Use current document.
    If you want to use a predefined template, select Start with template. When you have selected the starting document, click Select Recipients.

how to do a mail merge in word for letters

  1. The next step is to select recipients. Assuming you have an Excel sheet populated with recipient data, you can import the data by selecting the Use an existing file option and choosing Browse in the next section.

Use Explorer to navigate to the recipient list sheet, select the sheet, and click Open.

how to do a mail merge in word for letters

When you select a sheet, you will see the Select Table window. Select the appropriate table (s). Make sure to check the box next to the text First row of data contains column headers if this is correct for your data and click OK.

how to do a mail merge in word for letters

You will then see a list of recipients that Word will use in the mail merge. If everything is ok, click OK.

When you add the Excel sheet, click Next: Write a letter.

how to do a mail merge in word for letters

  1. You are now ready to add placeholders to your email. Hover over where you want to add a placeholder and choose More Items in the merge panel.

how to do a mail merge in word for letters

This will open the Insert Mail Merge Field dialog where you can select the appropriate placeholder and select Insert to add it to your email.

how to do a mail merge in word for letters

  1. After inserting all the mail merge fields, select Next: Preview Emails.

how to do a mail merge in word for letters

This will show you a preview of all the mails generated by the mail merge. You can use the arrow buttons on the mail merge panel to toggle the preview of the letters.

how to do a mail merge in word for letters

  1. Select Next: End the merge. In the next step, select either Print (if you want to print all letters) or Edit Individual Letters> All (if you are going to combine the letters into one document).

how to do a mail merge in word for letters

How to Create Mail Merge Labels

It’s always a good idea to create an Excel spreadsheet mailing list carefully so you don’t get dizzy when you need someone’s mailing data. However, if you want to print labels, your Excel sheet selection will not crop them. Instead, you will need to create mail merge labels in MS Word.

  1. If you already have an Excel mailing list, you can proceed to the next step. If not, organize your mailing list on an Excel sheet. Add some headings (first name, last name, address, etc.) and sort the list.
  2. Switch to MS Word. Use a wizard to create labels. Open a blank document and choose Mailings> Select Mail Merge> Step by Step Mail Merge Wizard.

how to do a mail merge in word for letters

  1. Select Labels and then Next: Start Document.

how to do a mail merge in word for letters

  1. On the next screen, select Change Document Layout. Then select Label Options to specify the product number and brand of the label.

how to do a mail merge in word for letters

After you click OK, you will see the shortcuts circled in the document. Otherwise, choose Table Design> Borders and select View Gridlines.

how to do a mail merge in word for letters

  1. Return to the Mailings tab in MS Word and select Select Recipients> Use Existing List.

how to do a mail merge in word for letters

Browse to the Excel file containing the mailing list. Select the file and click “Open”.

how to do a mail merge in word for letters

  1. You will see the Select Table window. If your workbook has multiple sheets, you will see multiple items here. Select the one that contains your mailing list. Select the check box next to the text First row of data contains column headings, and then click OK.

how to do a mail merge in word for letters

  1. MS Word is importing the mailing list. Select Address Block. Take a look at the preview on the right.

how to do a mail merge in word for letters

If that doesn’t sound like the way you want it, select Map Fields. Make sure all of the data matches the appropriate heading on your sheet and click OK.

how to do a mail merge in word for letters

Take a look at the preview again. If everything is in order, click “OK”.
  1. You will now see <> on the label. Choose Mailings> Update Labels to add <> to all labels.

how to do a mail merge in word for letters

  1. The labels are now ready to be merged. Go to Mailings> Complete & Merge> Edit Individual Documents.

how to do a mail merge in word for letters

You will see a pop-up window. Select “All” and then “OK”.

  1. Now you will see that all your shortcuts are merged.

how to do a mail merge in word for letters

How to Create Mail Merge Envelopes

The creation of mail merge envelopes is basically the same as for labels, with a few changes.

Click Mailings> Start Merging> Step-by-Step Mail Merge Wizard again, but this time select Envelopes and then select Next: Start Document Bottom.

how to do a mail merge in word for letters

  1. You will be prompted to select a starting document. Select Envelope Options to select the envelope size and shipping / return address position (see next step), and select Next: Select recipients.

how to do a mail merge in word for letters

  1. When you select envelope options, a pop-up window appears. Select the desired envelope size, font and placement for shipping and return address.

how to do a mail merge in word for letters

  1. The next step in the wizard is to select recipients. Select Use Existing List (assuming you already have an Excel sheet with recipient details) and select Browse to locate the file. Select the appropriate file and click Next. Arrange the envelope.

how to do a mail merge in word for letters

  1. On the next screen, select the Address Block, preview the preview to make sure it looks the way you want it, and click OK.

how to do a mail merge in word for letters

Now <> appears on the envelope.

  1. Click Next: Preview the envelopes. You will see the same preview as in the previous step, but in your document. You can use the arrow buttons on the wizard panel to switch between envelopes.

how to do a mail merge in word for letters

Your envelopes are now ready to be combined. Select Next: Complete the merge.

  1. On the next screen, you will see an option to edit individual envelopes. Select it, select “All” to combine all entries, and click “OK”.

how to do a mail merge in word for letters

Now you will see that all the envelopes are combined into one document.

how to do a mail merge in word for letters

Bulk Printing and Emails Made Easy

Using mail merge saves you a ton of time you would spend customizing letters, labels, or envelopes. However, this is not all that you can do with MS Word. You can also create greeting cards, brochures, and index cards.

Merging emails has been around for a long time, but if you want to improve the efficiency of your processes, Microsoft Office 2019 has introduced several useful features that you might want to look out for.

how to do a mail merge in word for letters

how to do a mail merge in a word for letters

Share this:

  • Twitter
  • Facebook
MS Office Tips Tags:Amazon, Bulk Printing Emails Made Easy, How to Create Mail Merge Envelopes, How to Create Mail Merge Labels, How to Create Mail Merge Letters, how to do a mail merge in word for letters, intel, Letters, Mail, merge, Print, receipt, Recover deleted user from home folder, Why You Might Need to Find an Amazon Receipt, Word

Post navigation

Previous Post: What Is BetterDiscord and How to Install It?
Next Post: How to Get Pixel 4 Voice Recorder App on Any Android Phone

Related Posts

  • How to Hide Sheets, Cells, Columns, and Formulas in Excel MS Office Tips
  • Turn Caps Lock Text back to Normal in MS Word MS Office Tips
  • Where to Download Cool Microsoft Teams Background Images for Free MS Office Tips
  • How to Filter Data in Excel MS Office Tips
  • Format Cells using Conditional Formatting in Excel MS Office Tips
  • How To Understand What-If Analysis In Microsoft Excel MS Office Tips

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Archives

  • September 2023
  • August 2023
  • July 2023
  • June 2023
  • May 2023
  • April 2023
  • November 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • March 2021
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • December 2019
  • July 2019
  • May 2019
  • April 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018

Categories

  • AI Tools & Guides
  • Amazon Web Services
  • Apple Watch
  • Computer Tips
  • Cool Websites
  • Featured Posts
  • Free Software Downloads
  • Gadgets
  • Gaming
  • General Software
  • Google Software/Tips
  • Hardware
  • Help Desk
  • How-To
  • iOS
  • iPad
  • iPhone
  • islamic Books
  • Linux
  • Linux Tips
  • Mac OS X
  • macOS
  • MS Office Tips
  • Networking
  • Office Tips
  • OS X
  • Product Reviews
  • Reviews
  • Safari
  • Smart Home
  • Smartphones
  • Software Reviews
  • technology
  • text
  • Tools Review
  • Troubleshooting
  • Tutorials
  • Uncategorized
  • Urdu Books PDF
  • Web Site Tips
  • Windows
  • Windows 10
  • Windows 7
  • Windows XP Tips
  • Wordpress
  • SmartDNS vs VPN – What’s the Difference?
  • How to go Back to the old YouTube Layout (2017)
  • A Simple Trick to Get 50% Discount on Audible for Three Months
  • What Is “Other” Storage on Android And How to Clean It Up ?
  • 7 Legal Websites to Get Free Music Downloads
DMCA.com Protection Status

Recent Posts

  • SmartDNS vs VPN – What’s the Difference?
  • How to go Back to the old YouTube Layout (2017)
  • A Simple Trick to Get 50% Discount on Audible for Three Months
  • 6 Best PayPal Alternatives (2017)
  • How to Fix the the “Invalid SIM Card” Error on Android

Recent Comments

  1. A Simple Trick to Get 50% Discount on Audible for Three Months on Private Browsing: What is it and What it is not
  2. 6 Best PayPal Alternatives (2017) on How to Save Money While Shopping Online in India
  3. Automatically Transcribe YouTube Video/Audio with Google Docs on 5 Best Team Management Apps (For Small and Large Teams)
  4. 6 Things You Need Know About Email Encryption on Delete All Emails from Gmail With Once Click
  5. Looking For YouTube Alternative? Try These 7 Video Sharing Sites on Ten Best YouTube Video Editing Software 2023
  • How to Watch Prime Video with Friends Online How-To
  • 12 Best Bluetooth Speakers In 2020 Product Reviews
  • which wifi is better 2.4ghz or 5ghz How-To
  • How to Disable Settings, Services, and Programs in Windows 7/8.1 Computer Tips
  • 5 Effective ways to stay Anonymous on Android How-To
  • How do I switch between integrated and dedicated graphics? How-To
  • Evernote Not Syncing? Try These 7 Troubleshooting Tips Help Desk
  • Fix “Your PC’s CPU isn’t compatible with Windows 8/10” Error Windows 10

Copyright © 2023 How To Blog.

Powered by PressBook News WordPress theme

Go to mobile version