ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

Step by Step Guide on Using Mail Merge Wizard in Word 2007

Updated on October 2, 2017
Patkay profile image

Patrick, a Computer Technician, is a dedicated writer who wishes to make the world better by informing individuals who seek more knowledge.

Mailings Ribbon Tab of Microsoft Office 2007

Mail Merge

The Mailings Ribbon Tab of Microsoft Office 2007 deals with mail merge. Mail merge is used when you want to create a set of documents for instance form letter that is sent to many recipients or when creating address labels. Your letter will usually contain a portion that is similar to all letters and another part like the name and address information that will be different for all letters. This unique information will come from entries in a data source.

Importance of Mail Merge

Mail merge is useful when a message needs to be sent to many people at once. It is a tool that will make your work easier eliminating the need for copying and pasting of some document parts. This program is commonly found in word processors.

Advantages of using the mail merge feature:-

  1. It will help you save a lot of time as you will be required to prepare only the main mail merge document which will be used for all the recipients.
  2. There is no need to incur huge cost with letterhead
  3. There is no need to sign each letter
  4. You can be able to produce more friendly letter
  5. You will be able to make one letter and then produce as many as you want

Mail Merging Steps

You will follow these steps in order to create a mail merge:-

  1. Setting up the main document.
  2. Creating a Data Source.
  3. Adding the merge fields into the main document.
  4. Merging the data with the main document.
  5. Previewing your finalized letter and making any necessary changes.

The Mail Merge Ribbon Tab

The Mail Merge Ribbon Tab
The Mail Merge Ribbon Tab | Source

Create Group Option

These are the commands found in the create group command

Envelopes – the envelopes command allows you to create and print envelopes. You will be able to set the recipients address and the return address.

Labels – if you want to create and print labels, use this command.

Start Mail Merge Group

Use this command to start a form letter which you intend to print or e-mail multiple times sending each copy to a different recipient. You will be able to insert fields such as name or address which MS Word will replace automatically with information from a database or contact list for each copy of the form letter you are creating.

Customizing Addresses

Customizing Addresses
Customizing Addresses | Source

How to Create a Mail Merge Using Microsoft Office Word 2007

The best way to start mail merge process is to use the wizard guide. Click on the start mail merge and select step by step mail merge wizard. The wizard guide is much easier to follow.

  • The first stage is to select the document type you are creating; this could be letters, E-mail messages, envelopes, labels or directory.
  • In stage two, you select the starting document. If for instance, you indicated you want to create a letter, you will now specify how you will set up your letters. The options you have are to use the current document, start from a template, or start from existing document.
  • The third stage is to select recipients. For selecting recipients, you will use an existing list; select from outlook contacts, or type a new list. If you do not have an existing list, click on type new list and click on create. A new address list dialogue appears where you will click on customize columns to set your own columns by either adding or deleting the existing. Enter the address list and save upon completing.

Address List

Entering the recipients
Entering the recipients | Source

Write Your Letter

  • The fourth stage is to write your letter if you have not yet done so. Otherwise, if you already have the letter, you need to insert recipient information to your letter. Click a location on your letter where you want any of these items to appear and then click on the item to use: Address block, greeting line, electronic postage, and more items.
  • The next stage is to preview your letter. You can also change your recipient list or modify parts of your letter.
  • This is the last stage where mail merge is ready to produce your letter. You can print your letter or edit individual letters. For print, your merged letters are sent to your default printer. You specify if you want to print all, current record, or from which letter to which. Editing the individual letters, your letters are merged to a new document and you can proceed to change them individually or print.

Inserting Addresses to The Main Letter

Inserting Addresses to The Main Letter
Inserting Addresses to The Main Letter | Source

Conclusion on Merging Documents

The write and insert fields group, preview results group, and finish group have thus been covered in the above procedure. If you feel comfortable using them instead of the wizard, you should go ahead and use them.

Step by Step Mail Merge Wizard in Word 2007 or Word 2010

Mail Merge Tool

Have you ever used the Mail Merge tool?

See results

© 2013 Patrick Kamau


    0 of 8192 characters used
    Post Comment

    • Patkay profile imageAUTHOR

      Patrick Kamau 

      5 years ago from Nairobi, Kenya

      njeri , thanks I am glad you liked.

    • profile image


      5 years ago

      your hub is very easy to understand good job

    • Patkay profile imageAUTHOR

      Patrick Kamau 

      5 years ago from Nairobi, Kenya

      Okay iamvijay, thanks for visiting and commenting.

    • iamvijay profile image

      vijaya kumar 

      5 years ago from Chennai, India

      Great dude an awesome explanation and a pretty article too..

      Thank you.

      Have a great day.


    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at:

    Show Details
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the or domains, for performance and efficiency reasons. (Privacy Policy)
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)