Microsoft Word - Do you know how to use Mail Merge?

What makes up a mail merge and how do you use one?

When many people need to receive the same document or email message and it needs to be personalised, or it may have fields that change, then a mail merge is what you need.

What Makes Up a Mail Merge?

A mail merge is made up of three elements.

The Source Document

Word Document – create a document that can be sent to many different people.

The List

You can have the list of the data in:

  • A Word table
  • An Excel spreadsheet
  • Outlook contacts

The Merge

Once you have the list and the document you can go ahead and create the merged document.

Mail Merge from an Excel List

The first step is to set up your data list in Excel. Perhaps you have inherited one, or it may have been exported from a database. You may also need to do some cleaning up of the structure of the data.

In your Excel list, you need headings at the top of each column. Each column represents a field. A field in the merge document is a placeholder for text that changes with each record. A record is all the information held about each individual person in the list.

Here is a snapshot of my data:

Now that I have a list, I can get on with creating the document and the merge process.

The Mailings Ribbon

The starting point for your mailing is the Mailings Ribbon.

The first two icons are for creating Envelopes and Labels. We will discuss those separately because they are for individual envelopes or a sheet of just one label. The mail merge process moves from left to right through the Ribbon depending on where you are up to in the process.

To get started – click on Start Mail Merge and then select the type of Mail Merge you wish to do.

Creating a Letter

Start the Mail Merge and select Letters from the drop-down list.

Nothing much appears to happen. Next step is to Select the Recipients so that Word knows where to go and fetch the data from. There is a choice of three options for the data.

Type a new List – this will pop up a form for you to fill in and create a list on the fly – it’s ok for small lists, however in most cases you will already have a large list stored elsewhere.

Use an Existing Listthis is what we are doing here as the list already exists in Excel.

Choose from Outlook Contacts – this is where we can pull our data in from information held in Outlook People.

Click Choose Existing List.

Navigate to where the list is stored and select it. Word may direct you to a folder where it stores Data Connections, however you can store your list wherever you wish.


As this list is in an Excel Workbook, Word will prompt you to select the correct worksheet or range.

Note the check box that says First row of data contains column headers – this is very important You should have a row of column headers in the spreadsheet that are formatted differently to the rest of the data.

Edit Recipients

The list that you have may be very large and it is possible that you do not need to write to everyone on the list. Word allows for this and there is an option to exclude recipients.

Insert Merge Fields

Merge Fields are the placeholders or codes that tell Word which information to pull in from your list.

There are several options for adding them.

Address Block – this inserts a whole block in a specified format which you can choose. Click on Address Block and you will see the following dialogue box enabling you to test out how you want things to look.

Greeting Line - The greeting line is a pre-set line of introductory text to your letter. You set how you want this to start by picking the relevant options.

You can choose whether it says Dear or To and then choose the greeting line for recipients where you don’t have enough information.

Insert Merge Fields - My personal favourite is to insert the individual merge fields in the location that I want them in the document. This gives me complete control over how things look.

Place the cursor where the Merge Field should go and then choose it from the list.

What Do The Fields Look Like?

The fields will look a bit odd when you first see them. To see the information that they relate to, you need to preview the results.

Address Block and Greeting Line

Merge Fields

With Merge Fields you type the body of the document and insert the placeholder Merge Fields where you need them. Then to see how they look click on Preview Results.

Once you are happy with the document and how it looks with the Merge Fields you can click on Finish and Merge.

Letters1

When the document has been merged, a new document is created. This is called Letters1 (each time you do this the number may change). The merged result can be printed. However, it should not be saved. It is a larger document than the original merge document and if you intend to send this out later, the names to whom you send it may have changed or been added to.


Each time you perform the merge, the most up to date list is used so if you keep on adding or taking people out of the data list, the result will be different.

What Should I Save? 

Save the data list – you can continue to update it. 

Save the document with the merge fields in – this is then ready for you to perform the merge at any time. The merge fields keep the document connected to the data source and so the end result will always be up to date. 

Discard the Letters1 document – it only takes a moment to recreate.

When you are ready to improve your Microsoft Word skills, get Essential Word for The Savvy Assistant which is part of Essential Office for The Savvy Assistant.



Categories: Blog, Microsoft Word