Skip to content

TechRepublic

  • Top Products
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • Accounting
  • CRM
  • Academy
Resources
  • TechRepublic Premium
  • TechRepublic Academy
  • Newsletters
  • Resource Library
  • Forums
  • Sponsored
Go Premium
Popular Topics
  • Top Products
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • Accounting
  • CRM
  • Academy
  • Project Management
  • Innovation
  • Cheat Sheets
  • Big Data
  • Tech Jobs
View All Topics
Go Premium
Software

How do I use mail merge in Word 2007?

By anthony-anthonysullivan May 28, 2007, 5:42 AM PDT

Image
1
of 15

67561.jpg
67561.jpg
How do I use mail merge in Word 2007?

How do I... Mail merge in Word 2007?

How do I... Mail merge in Word 2007?

By: Anthony Sullivan

Today we take a look at an old feature and how to use it within the Office 2007 interface.

The mail merge feature has been included with Microsoft Office for several generations of the product and isn’t likely to go away anytime soon.

Fortunately, it gets better and more useful with this latest offering from Microsoft. Let’s have a look.

When this How do I was first published, several readers asked for a PDF version. We are happy to oblige.

How do I use mail merge in Word 2007?

Starting the wizard

Starting the wizard

To get started on our mail merge we need to go to the Mailings tab and select Step by Step Mail Merge Wizard from the Start Mail Merge drop down arrows.

How do I use mail merge in Word 2007?

Select document type

Select document type

First we must select the type of document that we want to merge. In this case, we are going to use the default option, Letters.

Now, click Next: Starting Document to continue.

How do I use mail merge in Word 2007?

Select starting document

Select starting document

On the next screen you can choose from using the current document, opening an existing document, or using a template. We’ll use a template.

Select Start from a template and click Select template.

How do I use mail merge in Word 2007?

Choose a template

Choose a template

For this how-to we’ll select the Oriel Merge Letter template.

Click OK, then click Next: Select recipients.

How do I use mail merge in Word 2007?

Select recipients

Select recipients

Here is where the new merge features start to shine. There are three ways to identify the recipients of your mail merge. You can load them from a file, from a group of contacts in Outlook or from a MS SQL database.

To load the recipients from a file, select Use and existing file and click Browse.

How do I use mail merge in Word 2007?

Validate recipients

Validate recipients

Depending on the makeup of your data this screen may look different.

On this screen, you validate that the data is correct and that your columns are matching up properly.

Click OK once you’ve validated your data.

How do I use mail merge in Word 2007?

Select data source

Select data source

If you want to skip the instructions on how to use the other data sources you can skip to the fourteenth image in this gallery.

When we chose our file earlier we had the opportunity to select New Source. This allows us to setup a data connection to an MS SQL database to import our recipients.

Click New Source to continue.

How do I use mail merge in Word 2007?

Data Connection Wizard

Data Connection Wizard

Now we must choose the data provider we intend to use. We’ll use Microsoft SQL Server to connect to a SQL database and pull in our recipients.

Click next to continue.

How do I use mail merge in Word 2007?

Choose database and table

Choose database and table

If you provided valid connection information then you should now see the databases listed in the drop down list. Select the appropriate database and then the tables available should be provided in the list below.

Select the table that contains your recipient data and click Next.

You should now be presented with a screen similar to the columns screen when we imported via the csv file.

How do I use mail merge in Word 2007?

Using Outlook contacts

Using Outlook contacts

The last option for pulling in recipients is by using Microsoft Outlook. If you choose Select from Outlook contacts on the Select Recipients screen, you will be presented with this screen from which to choose the contacts folder you would like it use.

Choose the folder you’d like to use and click OK.

You should now be presented with a screen similar to the columns screen when we imported via the csv file.

How do I use mail merge in Word 2007?

Write your letter

Write your letter

Once you’ve selected your recipient source, Click Next: Write your letter.

Now you can edit your letter and add merge fields to it where you see fit. Since we are using a template, all of the fields we want are already there.

You can also buy electronic postage through this interface.

Click Next: Preview your letters.

How do I use mail merge in Word 2007?

Preview your letter

Preview your letter

We can now see our letters and edit them individually if we like. This gives us a chance to personalize the letters. We can also remove a letter at this point by clicking Exclude this letter.

Click the arrow buttons to move back and forth in our set of letters.

How do I use mail merge in Word 2007?

Another letter

Another letter

We are now looking at the next letter in our set. Any changes we made to our previous letter are specific to that letter and aren’t changed here.

Once you’ve edited all the letters and feel your merge is ready, click Next: Complete the merge.

How do I use mail merge in Word 2007?

Merge completed

Merge completed

The merge is complete and we can now either print the letters or click Edit individual letters to return to editing.

That does it for this how-to. I think that the Word merge feature is continuing to mature and this upgrade is a welcome one.

Watch out for more helpful “How do I” guides on TechRepublic.

  • Software
  • Account Information

    Share with Your Friends

    How do I use mail merge in Word 2007?

    Your email has been sent

Share: How do I use mail merge in Word 2007?
Image of anthony-anthonysullivan
By anthony-anthonysullivan
ANTHONY SULLIVAN is a software developer working with primarily microsoft technologies. He has been developing web applications and software solutions for nearly 10 years using technologies such as C#, MSSQL, Oracle and ASP.NET. Currently he is a Sen
  • Account Information

    Contact anthony-anthonysullivan

    Your message has been sent

  • |
  • See all of anthony-anthonysullivan's content

Daily Tech Insider

If you can only read one tech story a day, this is it.

TechRepublic TechRepublic
  • TechRepublic on Facebook
  • TechRepublic on X
  • TechRepublic on LinkedIn
  • TechRepublic on YouTube
  • TechRepublic on Pinterest
  • TechRepublic RSS
Services
  • About Us
  • Newsletters
  • RSS Feeds
  • Site Map
  • Site Help & Feedback
  • FAQ
  • Advertise
  • Do Not Sell My Information
  • Careers
Explore
  • Downloads
  • TechRepublic Forums
  • Meet the Team
  • TechRepublic Academy
  • TechRepublic Premium
  • Resource Library
  • Photos
  • Videos
  • Editorial Policy
  • Legal Terms
  • Privacy Policy
© 2025 TechnologyAdvice. All rights reserved.
CLOSE

Create a TechRepublic Account

Get the web's best business technology news, tutorials, reviews, trends, and analysis—in your inbox. Let's start with the basics.

Already registered? Sign In
Use Facebook
Use Linkedin

* - indicates required fields

CLOSE

Sign in to TechRepublic

Not a member? Create an account
Use Facebook
Use Linkedin

Lost your password? Request a new password

CLOSE

Reset Password

Please enter your email adress. You will receive an email message with instructions on how to reset your password.

Check your email for a password reset link. If you didn't receive an email don't forgot to check your spam folder, otherwise contact support.

Back to login
1 Finish Profile
2 Newsletter Preferences
CLOSE

Welcome. Tell us a little bit about you.

This will help us provide you with customized content.

No thanks, continue without
1 Finish Profile
2 Newsletter Preferences
CLOSE

Want to receive more TechRepublic news?

Newsletter Name
Subscribe
Daily Tech Insider
Daily Tech Insider AU
TechRepublic UK
TechRepublic News and Special Offers
TechRepublic News and Special Offers International
Executive Briefing
Innovation Insider
Project Management Insider
Microsoft Weekly
Cloud Insider
Data Insider
Developer Insider
TechRepublic Premium
Apple Weekly
Cybersecurity Insider
Google Weekly
Toggle All
No thanks, continue without

You're All Set

Thanks for signing up! Keep an eye out for a confirmation email from our team. To ensure any newsletters you subscribed to hit your inbox, make sure to add [email protected] to your contacts list.

Back to Home Page
×