13.2 What is Mail Merge
13.3 Concept of Mail Merge and its Components
13.3.1 Main document
13.3.2 Data source
13.3.3 Form letter
13.4 Mail Merge Option of Word
13.5 Merge Printing
13.6 Conditional Merging
13.7 What you have learnt
5.8 Terminal Questions
13.9 Feedback to In-Text Questions
The Mail Merge feature has been described here. In Ms-Word Mail Merge option is an important and every way for office set up. Many times we required sending the same content of a letter to different individuals. By using Mail Merge you can send the same letter to a number of persons without typing the content of the letter again and again.
At the end of the lesson you should be able to:
· understand the concept of Mail Merge
· create a main document
· create a data source
· link the main document with the data source
· merge print a document
13.3 WHAT IS MAIL MERGE?
In any working environment, there are situations when a similar type of letter or document is to be sent to many persons who reside at different locations. The letters may contain the address of each recipient, in addition to the standard information contained in the letter. One way of doing this is to print the letters by changing the address each time in the document after printing such letter. But this would mean lot of effort and time and also results in bad organisation.
Such problems are taken care of by the Mail Merge facility. In word processing, Mail Merge is the process of transferring selected information from one document to another document.
13.4 CONCEPT OF MAIL MERGING AND ITS COMPONENTS
Mail Merge is the facility which requires the following three information
· General body of the letter called main document
· Header Row, the record structure or the name of the fields, which will identify the data
· Data for all the individuals, for whom the letters are to be generated also called data source
Mail Merge option of Word reads this data and physically merges it with Main document to generate letters for all the persons or for all records in the data file.
Main Document Data Source
(a) Main Document
In Mail Merge, Main Document is the common letter, which contains the common information for each of the merged document. It also contains the field names, which contain the instructions for carrying out the merge.
(b) Data Source
Data Source is also called the Data File. It stores information to be brought into the Main document. The data file table contains a column for each category of information, or data field, in the data file. The Header Row is the first row of the table. It contains field names, which indicate the type of information in each column. For example list of names and addresses.
Each field name must be unique and must begin with an alphabet/letter.
(c) Form Letter
Form letter is the resultant document of the mail merge operations, which contains the copy of the main document along with each piece of information stored in the data file.
IN-TEXT QUESTIONS 13.1
1. What do you mean by Mail Merge?
2. What are the three information required for Mail Merge?
3. Define Form Letter.
13.5 MAIL MERGE OPTION OF WORD
Thus by now it is clear that for Mail Merge document, you need to
¨ Create the main document
¨ Create data source
¨ Merge the data with document
All these operations can be performed by Mail Merge option of WORD. In order to invoke the Mail Merge option, choose the Mail Merge option of the Tools menu. The following Mail Merge Helper box will appear as shown in Fig. 13.2.
Fig. 13.2 Mail Merge Helper
Mail Merge helper guides you through the steps of mail merging a document. There are three main options available in the box.
(a) Creating the Main Document
The first step in the mail merge is to create the main document. For this, choose ‘Create’ button of ‘Main Document’ option in Mail Merge Helper box. The following menu will be displayed
Restore to Normal Word document
Now choose ‘Form Letters’ option from this menu as the type of main document. The following box will appear as shown in the Fig. 13.3.
13.3 Main Document
Choose the Active Window button from the above box. Type the main document and again invoke the Mail Merge Helper.
(b) Creating Data Source
Choose the ‘Get Data’ button from the Mail Merge Helper box. For creating data source, select Create Data Source. The following dialog box will appear as shown in the Fig. 13.4.
Fig. 13.4 Structure of Data File
The field names are already available in the Header row, which are default fields for an address list. Any field that is not required can be removed, and any new field can be added. For removing a field, highlight that particular field and click on the ‘Remove field Name’ button. For adding a new field, type the name of the field in the Field Name box and then click on the ‘Add Field Name’ button.
Click on the OK button and save your data structure as well as the data source. The following dialog box will appear as shown in the Fig. 13.5.
Fig. 13.5 Editing Data Source
Click on the ‘Edit Data Source’ button from the box to enter records in the data file. A Data Form dialog box will be displayed as shown in Fig. 13.6
Fig. 13.6 Data Form for Entering Records
Enter the records by typing in the boxes. For adding a record choose ‘Add New’ button. For removing a record, choose ‘Delete’ button. After you finish with adding records, click on the OK button.
(c) Opening the Data Source
You can also use a data source already created. You can open it by clicking the ‘Get Data’ option in the Mail Merge Helper and then selecting ‘Open Data Source’ A dialog box will appear with a list of data source file names. Select the name of the data source to open it.
(d) Merging the Text with Data
After creating the main document and data source, the third step is to merge the main document with the data source. For this, invoke the Mail Merge Helper again and choose the ‘Merge’ button. The following dialog box will appear as shown in the Fig. 13.7.
Fig. 13.7 Merging data with the document
Select ‘New Document’ from the ‘Merge To’ drop-down list and click on ‘Merge’ button. The form letters are generated and stored in the document which may be previewed for final adjustment in the main document, before printing the for letters.
13.6 MERGE PRINTING
You can directly print the Form Letters without previewing them. Select the Printer option, then the form letters are directly printed on the printer.
13.7 CONDITIONAL MERGING
You can also mail merge the document with a condition. There are two options available in the Merge dialog box as shown in the Fig. 13.7, i.e., ‘Merge’ and ‘Query Options’ options. Using Query Option’ you can define the selection criteria so that at the time of merging only those records are selected which meet the defined selection criteria.
IN-TEXT QUESTIONS 13.2
1. State whether the following statement is True or False.
(a) For mail merge document, you need to create the main document.
(b) To create Data Source choose the get data button from the mail merge helper box.
(c) For adding new field, type the name of the field in record name box.
(d) After creating the main document and data source, the third step is to merge main document with the data source.
(e) You can directly print the form letters without previewing them.
(f) Merge and query are two options available in merge dialog box.
13.8 WHAT YOU HAVE LEARNT
After going through this lesson you have learnt the concept of mail merge and its usefulness. The mail merge feature of Ms-Word requires mainly two components: the main document and the data file. The main document is the body of the letter that has to be sent. The data file contains the list of names and addresses in the form of fields. You have learnt the procedures of creating the main document and the data file, and combining them.
13.9 TERMINAL QUESTIONS
1. What do you understand by Mail Merge?
2. Define the different components of Mail Merge.
3. How do you invoke ‘Mail Merge Helper’ window?
4. Differentiate between Merge and Query option of ‘Mail Merge Helper’ window.
13.10 FEEDBACK TO IN-TEXT QUESTIONS
IN-TEXT QUESTIONS 13.1
1. The process of transferring selected information from one document to another document is known as Mail Merge.
2. Main Document, Data Source and Form Letter.
3. Form letter is the resultant document of the mail merge operations, which contains the copy of the main document along with each piece of information stored in the data file.
IN-TEXT QUESTION 13.2
1. (a) True (b) True (c) False (d) ) True (e) False (f) True