Skip to content

TechRepublic

  • Top Products Lists
  • Developer
  • 5G
  • Security
  • Cloud
  • Artificial Intelligence
  • Tech & Work
  • Mobility
  • Big Data
  • Innovation
  • Cheat Sheets
  • TechRepublic Academy
  • CES
  • TechRepublic Premium
  • Top Products Lists
  • Developer
  • 5G
  • Security
  • Cloud
  • Artificial Intelligence
  • Tech & Work
  • Mobility
  • Big Data
  • Innovation
  • Cheat Sheets
  • TechRepublic Academy
  • CES
  • See All Topics
  • Sponsored
  • Newsletters
  • Forums
  • Resource Library
TechRepublic Premium
Join / Sign In
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

TechRepublic Premium

  • TechRepublic Premium

    Email/Instant Message/voicemail retention policy

    Maintaining electronic communications in business involves walking a fine line. Employees want relevant information to be kept available for future reference so that they can do their jobs, but keeping these items long-term can pose security and resource risks. Server hard drives can fill up, or stolen data (even if outdated) might pose a threat ...

    Downloads
    Provided By TechRepublic Premium Published:  Feb 2023 Modified:  Feb 2023 Read More
    Download Now
  • TechRepublic Premium

    Supplier management policy

    Information technology depends upon the acquisition of products and services for use by the business to achieve operational goals and become profitable. Building and managing productive relationships with suppliers (the description of which includes vendors) is an integral responsibility for many IT departments. Ensuring suppliers are properly vetted, negotiated with, and serve as a valuable ...

    Provided By TechRepublic Premium Published:  Feb 2023 Modified:  Feb 2023 Read More
    View This Now
  • TechRepublic Premium

    Streaming media policy

    Although there are many legitimate business reasons to access streamed audio and video files — such as engaging in training, reviewing industry-related content and conducting research — there are also opportunities for misuse. This policy provides guidelines for the appropriate use of streaming media on systems and devices that access company networks. From the policy: ...

    Provided By TechRepublic Premium Published:  Feb 2023 Modified:  Feb 2023 Read More
    View This Now
  • TechRepublic Premium

    COVID-19 workplace policy

    The COVID-19 workplace policy from TechRepublic Premium describes the procedures the organization has adopted in an attempt to minimize the spread of coronavirus infections. From the policy: Purpose The purpose of the COVID-19 workplace policy is to ensure all individuals entering organization facilities understand and abide by COVID-19 protocols. The guidelines described within this policy ...

    Provided By TechRepublic Premium Published:  Feb 2023 Modified:  Feb 2023 Read More
    View This Now

Services

  • About Us
  • Newsletters
  • RSS Feeds
  • Site Map
  • Site Help & Feedback
  • FAQ
  • Advertise
  • Do Not Sell My Information

Explore

  • Downloads
  • TechRepublic Forums
  • Meet the Team
  • TechRepublic Academy
  • TechRepublic Premium
  • Resource Library
  • Photos
  • Videos
  • TechRepublic
  • TechRepublic on Twitter
  • TechRepublic on Facebook
  • TechRepublic on LinkedIn
  • TechRepublic on Flipboard
© 2023 TechnologyAdvice. All rights reserved.
  • Privacy Policy
  • Terms of Use
  • Property of TechnologyAdvice