How To Use Mail Merge.

April 25th, 2010 by admin Leave a reply »

Most people only use mail merge every now and then. So here we are going to help you.

Mail merge is used for when you want to send the same letter to a lot of people or if you want to make labels with all your contact details on.

To make it work easy for you it would be better to have your letter in word and contact details in excel already completed and saved.

If you need to make your contact details in excel. Make six Columns with the headings: Company Name, First Name, Last Name, Address, City, Postcode.

In word click on tools then scroll down and click on letters and mailing. Then click on mail merge. Your mail merge section will then open on the right hand side.

Select the type of document you want. ie letters or lables. Then click next at the bottom of that section. Then select either current document you have opened or you select existing and you can search for the document you need. Then click next.

Select recipients. Highlight existing list then underneath click browse. This will open up your mail files. click on my documents and your contact list u saved in excel will be there. Select this and click open.

A select box will open. It will show up with three sheets. This is by default as when ever you use excel it opens 3 sheets for you. Click on the first sheet and click open. A mail merge recipients box will appear with all your contact details. Here you can unselect any of your contact you dont need to use. Then click ok. Then click next at the bottom of your mail merge column.

Here you can select and input you contact details. For example when you have selected the address. It will appear as address block. Once you have inputed each detail click next and you can then preview your work.

Then you can either print your letters or make final changes.

Advertisement

Leave a Reply