Mail Merge

Mail Merge

Mail Merge is a useful tool that allows you to produce multiple letters, labels, envelopes, name tags, and more using information stored in a list, database, or spreadsheet. When performing a Mail Merge, you will need a Word document (you can start with an existing one or create a new one) and a recipient list, which is typically an Access Database.

Creating the data source

1. Create a new document and type the letter to be sent to the multiple recipients.

2. To create multiple letters using Mail Merge Wizard, select Tool → Mail Merge Wizard, as shown. A window will appear.

3. Select Step1, ‘Select Starting document → Use the current document → Next’. Click on the Next button move to the next step.

4. In Step 2, select the Document type → Letter → Next 

5. In Step 3, click on the button “Select Address List”. The “Select Address List” window will open, which will allow you to create the recipient list.

Click on the Create button. After clicking on the

6. Create button a New Address List window willClick on the Create button. After clicking on the Create button a New Address List window will appear. In this window under the Address Information section you can enter the information of the recipient.

7. If you want to fill the data of the recipient as per the default fields, then enter the data.

8. If you wish to customise the fields of recipient information, click on Customise button. A 'Customise Address List' window will appear. Now you can add, delete or rename any field name. You can also change the order of appearance of the fields using up/down arrow button.

(a) Add (for a new field)

(b) Delete (to delete an unnecessary field)

(c) Rename (to change the name of the field)

After customising the fields, enter the data in the new format.

9. After entering the data of first recipient, click on the New button to enter the information of the next recipient. After entering the information of the entire recipient, click on the OK button to close the list.

10. After clicking OK button, the Save As dialog box will appear, which will allow to save the list of recipient in .CSV format (say MyList.csv)

11. After saving the list a window will appearwhich will display the various recipient list created till now. You can select any of the created list till now. Select the required list and click on OK button from any of the list to send the letter.

12. After clicking on OK button, you will move to Step 3 of Mail Merge Wizard, a window Insert Address Block will appear, which will show you the address block.

13. Click on Next button, you will move to Step 4 of Mail Merge Wizard. A Create Salutation window will appear, to set the salutations for male and female recipients. A way of distinguishing one group from another is defined by choosing from the offered Field names, for example, Gender and by entering the Field value, for example, Female.

14. Click on Next button, you will move to last Step 5 of Mail Merge Wizard. An Adjust layout window will appear to set the layout of the recipient address on the page. You can set the top and left margin. Click on Finish button to merge the letter with the recipients address.

15. In the next step, the Writer will display the document with the Mail Merge Toolbar below the standard toolbar.

16. Now click on Edit Individual Documents button to merge the letter with the address of the recipients. Here you can verify all letters of the recipients before printing.

17. You can use the other options on the Mail Merge toolbar, such as

(a) to exclude some of the recipient check on the checkbox of Exclude recipient.

(b) to save the merged document, click on the Save Merged Documents button.

(c) to print the merged document, click on the Print Merged Documents button.

(d) to send the letters by email, click on the Send Email Messages button.

  • A word processor is a software for typing, formatting and creating documents.
  • There are two types of formatting that we can apply – character formatting and paragraph formatting.
  • For character formatting, we must first select all the characters where we want to apply the formatting. For paragraph formatting, it is enough to have any part of the paragraph selected – for a single paragraph, it is sufficient to place the insertion point somewhere in that paragraph.
  • Character formatting includes – font, font style, size, font colour, underline style, underline colour, and effects – for example subscript, superscript, emboss, etc.
  • Paragraph formatting comprises of – alignment; indents – left, right, first line and hanging; space before and after paragraphs; and line spacing.
  • To highlight the points, we can use bullets or numbering for the paragraphs.
  • If we plan to put tabular data, we can either use tabs – left, right, center and decimal; or use table to type in the text within the cells.
  • To enhance the appeal of the document, we can insert pictures – either from clip art, or from files. We might have to select appropriate wrapping options to have the text around the picture.
  • We can move or duplicate text in a document or across documents using options like Cut, Copy and Paste.
  • If we are likely to make mistakes (and all of us are!), we can utilise the word processor to check the spellings and grammar.
  • Before we print the document, we must decide on margins, page size, gutter etc. through Page Setup.
  • If we need to have many copies of documents which are same except for some parts, like invitation letters, we can use the mail merge facility to make the task simpler.
  • We can allow others to review the documents by editing as well as by adding comments. These changes can be tracked. We can later decide as to whether to keep those changes or to revert back to the original text.