Mail Merge in Excel – Shiksha Online

Mail Merge in Excel – Shiksha Online

7 mins read2.5K Views Comment
Rashmi
Rashmi Karan
Manager - Content
Updated on Feb 7, 2025 09:25 IST

Mail Merge in Excel is an essential tool for creating a set of documents, such as campaigns, surveys, forms, letters, etc., to be sent to many clients. Each card or label contains the same type of information, although its content is unique. For example, in the letters you send to your clients, each can be personalized with the name of the person to whom it is addressed. The unique information for each card or label comes from the entries contained in a data source. Read the blog to learn more about mail merge.

Mail merge in Excel
We can  create   many copies of a document, each with different details , using the Mail Merge tool in Word . This is  useful  when  one   wants  to send out similar documents but  with   minor   variations,   such   as  names or addresses.

Content

Overview of Mail Merge in Excel

Before moving on to the Mail Merge process, look at the screenshot below. This is how Mail Merge works.

You have data from an Excel spreadsheet and a template from a Word doc. The Mail Merge option uses data from Excel and embeds it in the Word template.

Overview of Mail Merge in Excel

Let us see how it works in detail. 

Most Popular and Powerful Formulas in Excel
Most Popular and Powerful Formulas in Excel
Excel has various functions ready to process your information to get the desired results. Familiarize yourself with each of them. Once you master various functions, you can create advanced MS...read more
What is Conditional Formatting in Excel?
What is Conditional Formatting in Excel?
Conditional Formatting is a popular tool in Excel that allows adding a different format to the cells per their conditions. This way, we can easily see if the value of...read more
Average Function in Excel – Formula and Examples
Average Function in Excel – Formula and Examples
The AVERAGE function is a popular Excel function used for various purposes, such as calculating average sales, average student scores, average monthly expenses, etc. It provides a quick and efficient...read more
Recommended online courses

Best-suited MS Excel courses for you

Learn MS Excel with these high-rated online courses

Free
5 hours
Free
7 hours
Free
7 hours
Free
20 hours
Free
4 hours
β‚Ή9.6 K
21 hours
Free
– / –
β‚Ή5.5 K
18 hours
Free
– / –

Create Your Excel Spreadsheet

The primary step is to set up and prepare the data in the Excel spreadsheet as the data source for the recipient list. When preparing your Excel spreadsheet for a Mail Merge, you need to ensure the following conditions – 

  • Column names match the fields you need to insert in your Mail Merge. For example – separate columns for the first and last names if you must address readers by their first name.
  • All the data is present in the first sheet of your spreadsheet.
  • Entries with data like percentages, currencies, and postal codes are in the correct format.
  • You have stored the spreadsheet for the Mail Merge on your local system.
  • You have made all the necessary changes to your spreadsheet before it’s connected to your Mail Merge document in Word.

We have the below data set that needs to be merged for sending letters.

Create Your Excel Spreadsheet 1
Mail Merge From Excel to Word

In our example, we will merge letters. The steps are the same for email messages as well. 

Create a Word document. Create your letter content and create a new Word doc.

Mail Merge From Excel to Word

Select the merge option – Go to Mailings β‡’ Start Mail Merge β‡’ Letters.

Select the merge option

You can now attach your Excel file with the Word doc. Browse and locate your Excel file and click Open.

attach your Excel file with the Word

You will be prompted to choose the sheet of your choice. Select that and click OK.

attach your Excel file with the Word 2

You have now established a connection between Excel and Word. This Excel sheet is the source of your letter content. Whenever you change your Excel spreadsheet, the Mail Merge data source will be automatically updated.

Now check your recipient list, and deselect names if you don’t wish to send letters or emails to them. Continue if all is well.

recipient list

You will get a dialogue box that suggests specific address elements; choose the one that is suitable for your business and click OK.

specific address elements
 

Match Fields

You have the details that you need to send the letters. If you wish to add more details, click the β€œMatch Fields” option. You will be redirected to another window and can add the missing details per the requirements.

Match Fields

Coming back to the previous option. Keep the letter content handy and copy-paste/write the text on the Word doc. Now add the required placeholders. This includes Address Block and Greeting Line. These placeholders will help to understand where the data should be placed. 

Address Block
Greeting Line

Now that your letter content is ready, insert the merge field. This will help to personalize your letter further. In our example, we will mention the count of years for which the consumer has been associated with the organization.

insert the merge field
insert the merge fields 2

You can preview your content with the help of Preview Results. Verify if all information is placed correctly.

Preview Results mail merge

If you think that the mailer content is good to go, go to Finish & Merge and select the options, which are –

  • Edit Individual Documents
  • Print Documents
  • Send Email Messages
Finish & Merge

Save this Word doc somewhere for your future reference. After you save the doc, it will remain in your mailer list. You just need to open it and click Yes when prompted. This will help you retain the connection we established between Excel and Word.

save letter format
Top MS Excel Interview Questions
Top MS Excel Interview Questions
Microsoft Excel is an indispensable tool that empowers professionals to manage, analyze, and visualize data with unparalleled efficiency. Master your Excel interview with confidence using our curated list of top...read more
Introduction to MS Excel – A Beginner’s Guide
Introduction to MS Excel – A Beginner’s Guide
Microsoft Excel has been around for decades and is one of the most desired skills if you are considering a career in data science or analysis. But there are still...read more
How to Create MIS Report in Excel?
How to Create MIS Report in Excel?
A Management Information System (MIS) report in Excel is a vital tool for businesses and organizations, offering valuable insights by consolidating and presenting data in an organized and comprehensible format....read more

Using Step-by-Step Mail Merge Wizard

You can also access the Mail Merge features from the Mail Merge Wizard located –

Mailings β‡’ Start Mail Merge β‡’ Step-by-Step Mail Merge Wizard

Step by Step Mail Merge Wizard

When you click on the Step by Step Mail Merge Wizard button, a Mail Merge pane will open at the extreme right of your document. You will notice that it guides you through the process of Mail Merge, step-wise.

Step by Step Mail Merge Wizard 2

It is easier to work with the Mailings option located on the toolbar since all the options related to the Mail Merge process are located up front.

Tips to Efficiently Use Excel for Mail Merge

Here are some simple tips to prepare your Excel spreadsheet for a mail merge:

  • Match column names with mail merge fields – Ensure that the column names in Excel match the information you want to insert in your document. For example, if you want to use a person's first name, create separate columns for "First Name" and "Last Name."
  • Use the first sheet – Keep all the data you want to merge in the first sheet of your Excel file.
  • Format numbers correctly – Ensure percentages, currency values, and postal codes are formatted properly so Word can read them correctly.
  • Save the file on your computer – The Excel file should be stored on your local device (not in an online location) to avoid errors.
  • Complete all changes before connecting – All edits and updates should be done before linking the spreadsheet to your mail merge document in Word.

Conclusion

Using Mail Merge is a highly efficient tool that saves a lot of time. The most interesting thing about Mail Merge is that it creates the same letter several times, taking into account the variables that are assigned. If we have to make a letter for 20 people with their names and IDs, Word will take the information from Excel and create a letter for each name and address.

I hope you find this feature interesting and that we helped you to understand how Mail Merge works.

Keep learning!


Top Trending Articles in MS Excel:

Most Useful Excel Formulas | Min Max Functions in Excel | Average Functions in Excel | Introduction to MS Excel | Financial Modelling in Excel | MS Excel interview questions | Sum Function in Excel | Trim Function in Excel | Pivot Table in Excel | Percentage in Excel | Vlookup in Excel | Median Function in Excel | Types of Charts in Excel | Count Function in Excel | MS Excel Vs. Google Sheet | Remove Duplicates in Excel | Create Graph in Excel

FAQs - Mail Merge in Excel

What types of documents can I create with Mail Merge in Excel?

You can create various types of documents in Excel using Mail Merge.

  1. Letters
  2. Envelopes
  3. Labels
  4. Name Badges
  5. Directories
  6. Certificates
  7. Invoices
  8. Reports
  9. Invitations
  10. Surveys or Questionnaires
  11. Thank You Cards
  12. Sales Proposals
  13. Catalogues or Brochures

 

What are the common errors in Mail Merge, and how can I fix them?

Common errors in Mail Merge include missing data, formatting issues, and field mismatches. To fix them, ensure your Excel data is correctly formatted and matches the merge fields in your Word document.

Do I need to save my Excel spreadsheet before starting a Mail Merge?

It's a good practice to save your Excel spreadsheet before starting a Mail Merge, especially if you plan to change the data in Word. This ensures you don't accidentally overwrite your original data.

Can I use Mail Merge for mass mailing and printing labels for an extensive contact list?

Yes, Mail Merge is commonly used for mass mailing and printing labels for an extensive contact list. You can customize each label or letter with recipient-specific information from your Excel spreadsheet.

What is the advantage of using Mail Merge in Excel over manually creating individual documents?

The main advantage of using Mail Merge in Excel is efficiency. It saves time and reduces the risk of errors when creating personalized documents for many recipients, compared to manually creating each document individually.

About the Author
author-image
Rashmi Karan
Manager - Content

Rashmi is a postgraduate in Biotechnology with a flair for research-oriented work and has an experience of over 13 years in content creation and social media handling. She has a diversified writing portfolio and aim... Read Full Bio