ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel
  • »
  • Business and Employment»
  • Small Businesses & Entrepreneurs

Guide on How to use ’Mail Merge’ in Microsoft Office Word 2007

Updated on November 29, 2016

Mail Merge in Microsoft Office Word

In this hub I am going to show you, fellow readers, how to use the ‘Mail Merge’ option in Microsoft Office Word to be able to send the same, still somewhat personalised letter for several recipients at the same time.

To begin with, you have to write the letter you would like to send for the recipients. I first had to do this when I was working as a Marketing Trainee during university and the company where I worked wanted to send the same letter to several customers. To be able to do this you also have to make an Excel table with the name of people you want to send the letter to (one column is enough, but if you have more, you can choose what to include later – you can even include address, full name, profession, etc. – it really depends on you).

Now let’s see how to make the Mail Merge!

Click on 'Mailings' tab on the top, then click on 'Start Mail Merge'. Choose 'Step by Step Mail Merge Wizard' from the options given.


On the right of your screen in Word now you can choose: 'Labels' then click on 'Next: Starting document' on the bottom.

Choose 'Use the current document' (if you can't, click on 'Label options' first, hit Cancel in the window that appears and then you can select it). Now search for the Excel file which contains the name list (the names you want to print on the cards). Click on 'Browse' and select that file. When you are done, click on 'Next: Arrange your labels' on bottom.

After these, select 'More items...'. According to what column titles you have in your Excel document, you can select the one that contains the names in the small window that appears. In my Excel document I had only one column which title was 'Name'. Navigate to where you want to place the names and click 'Insert' now.


If you want to insert more information and not just the name, navigate where you want to insert the new bit and select it from the same small window. When you are done, close the little window.

As you can see the little label you selected and inserted is now in your document similar to this <<Name>>.

Now click on 'Next: Preview your labels' (assuming you are completely done designing your document, if not, finish writing first). On the right, you can navigate between each record and see how each letter will look like with the informations inserted. To see all in separate documents, click on 'Next: Complete the merge' on the bottom. You can even navigate between the merged records on the top of the Word window.


Now you all have to do is to print your document the way you want :).

Related books on Amazon

Poll on the topic

Have you ever tried Mail Merging before?

See results

Mail Merging video on Youtube

Share your ideas!

Please feel free to comment on this hub, your feedback is very much appreciated!

Or, if you feel that you can write fresh, new ideas about this or a similar topic, just join our community and start writing!

© Copyright 2012-2014, Zsofia Koszegi-Nagy (zsobig)

© 2012 Sophie

Comments on this hub

Submit a Comment

  • zsobig profile image

    Sophie 5 years ago from United Kingdom

    I am happy I could show you something new and very useful!

    Thank you for your nice comment, I appreciate it! :)

  • CWanamaker profile image

    CWanamaker 5 years ago from Arizona

    Interesting, I never realized Word had this option. I always created an Access Database that automatically generates the same but somewhat personalized letters. This actually sounds a lot easier. Next time I need to create mailers, I will give the mail merge method a whirl - thanks!