Download Mail Merge in Microsoft Word: Creating Personalized Documents with Data Sources and more Schemes and Mind Maps Printing in PDF only on Docsity!
88 :: Data Entry Operations
Mail Merge
5.1 INTRODUCTION
A common word processing task is to produce periodic mailings to send to different people or agencies connected to you or your profession or your business. The mailings features in Word can help you to organize your address data, get it into a document, and print it out in the desired format. The main uses of Word’s Mail Merge features are: l You can merge a list of names and addresses to a single letter that can be sent to different people in their names and addresses. l You can create categories, a single letter with variable information fields in it, or labels. l You can also produce merged documents such as directory lists, invoices, print address lists, or print addresses on envelopes and mailing labels.
5.2 OBJECTIVES
After going through this lesson you would be able to: l to create form letters, mailing labels, envelopes l to organize the address data and merging it into a generic document, and printing the resulting personalized documents l to customize a mail merge
Mail Merge :: 89
5.3 TYPES OF DOCUMENTS IN MAIL MERGE
Mail Merge requires three types of documents:
(a) Main Document: In a Mail Merge operation, the personalized document (such as, a standard letter, or envelope, or mailing label) is known as the main document. It is the document containing the text and graphics that stay the same for each version of the merged document - for example, the return address and body of a form letter.
(b) Data Source: Data source is a file that contains the names and addresses or any other information that vary with each version of a mail-merge document. For example, a list of names and addresses for a form letter you want to send to a list of clients or other people.
(c) Merge Document: When you merge the main document with data source, a third document called merge document will be produced. The merge document can be merged to the screen to view letters along with addresses; or directly to the printer to print the letters along with addresses and print addresses on envelopes or labels; or save as some other file that can be used later for printing. Inserting the data or information from the data source in the main document creates the merge document. For example, insert the merge field «City» in a letter document to have Word insert a city name, such as “New Delhi” that is stored in the City data field.
Mail Merge or Mailings feature in Word 2007 is available in Main Tab bar. Click on the ‘Mailings’ tab on the main tab bar to activate the mailings features and tools, which comprises subtask such as “Create”, “Start Mail Merge”, “Write & Insert Fields”, “Preview Results” and “Finish & Merge”
Fig. 5.
Mail Merge :: 91
personalised letter that is received by different people in that group with different address.
Select Letters from the options given in the Select Document type box and click on the “Next: Starting document” located on the lower end of the Wizard dialog box to move to the next step.
5.4.2 Select Starting Document
- The 2nd^ step in the process is to select starting document under Letters option. There are three options available.
Use the current document: This is to use the current document shown and use the mail merge features to add recipients address or information. This is suitable when you already have letter draft for the purpose and just want to add address of the recipients to the letter.
Fig. 5.
Start from a Template: Similarly if you don’t have a drafted letter for use, you can choose for ready to use mail merge template already available with Word
- These templates can be customised as per your requirement.
Start from existing document: If you already have a document available with you, you can select the exiting mail merge document and make necessary changes to the content of the letter and/ or recipients. Fig. 5.
92 :: Data Entry Operations
Let us select “Start from a Template” and the select a blank document. When you select this option, Mail Merge Wizard will display the following sub menu option to select a template. Here you can select various templates that suit your requirement or you can select a blank document to create your own customised letter. Let us select “Blank Document” to create our own customised letter.
- Leave some space (approximately 6 to 7 lines by pressing ENTER key) to insert addresses through merge fields later. Do not type any thing in this space. We will learn how to insert addresses from data source through data fields later in this unit. You can also insert fields anywhere in the body of the letter. The following Figure shows an example of form letter created to send the letters to all the students admitted for DIT programme offered by National Institute of Open School. We have left some space below the date to insert name address fields of students. The enrolment number field also can be inserted at ‘Your enrolment number is ‘ later when data source is ready. Type the body of the letter.
Fig. 5.
Save your document.
5.4.3 Creating a Data Source
The 3rd^ step in Mail Merge Wizard is to select a list of recipients or address to whom the drafted letter will be addressed and dispatch.
94 :: Data Entry Operations
- Should you want to C u s t o m i s e Columns the filed in the new address list to remove or add any other field as new your requirement, click on the customised button located on the lower right side of the New Address List dialog box.
- This will display a list of available data field to which you can add a customised data filed, delete or rename an exiting data field in the list. Once done click on the “OK” button.
- When you finish specifying the required data fields to the new address list, click OK. The Save As dialog box appears.
- Locate the folder that you want to save the data source in, type a file name, and then click Save As in the Save As dialog box. The file will be saved with an extension name .mdb (Microsoft Database).
(b) Editing Existing Data Records To edit the existing data records in the data source file, follow these steps:
- Open the data source file and then select Use an exiting list option from the Select Recipients dialog box displayed in step 3 of the Mail Merger Wizard. The toolbar will appear on the screen.
- Now click on the Browse option to display the Select Data Source dialog box. Now search the folder where you have stored the data file which you want to use and the click on Open button to access the data file.
- You can open various data file format such as Access database, Excel files, Word File, Rich Text format etc.
Fig. 5.
Mail Merge :: 95
Fig. 5.
- Once the data file is selected, based of the type of data file is selected, Mail Merger will ask you to define how to distinguish between data fields and data record.
- Once it is done, the data file will be loaded in to Mail Merger and you can now click on Edit Recipient List button to be able to edit the list as per your requirement.
- To locate a data record that you want to change, move to the record number you want change its contents by clicking the arrow keys or typing the record number; or click Find, and then search for information that you know the record contains.
- Edit the records that you want to change and save the changes.
(c) Creating a Data Source Using Word Table
In fact, the Mail Merge Wizard guides you step by step through setting up a Word table that contains your names, addresses, and other data. Instead of taking advantage of Mail Merge Wizard, you can also create a data source by entering field names and data directly in a Word table. Follow these steps to do this:
- Insert a table by selecting tab Insert→Table command on the main tab bar and create a table as given below.
- Type the data field names on the top row of the table. Start typing the data records from the second row.
- When you finish entering all the data records, save the table as a Word document. Your data source document is ready.
Mail Merge :: 97
Fig. 5.
- Using Insert Address Block you can select the individual address field to be inserted into the main letter.
Fig. 5.
- After you complete the main document and insert all of the merge fields, click on the Office Button to save Save As option. Now select “Word Document” to save the file as a Word 2007 document or Select “Word 97-2003 Document” to save it as Word 97 or 2003 compatible ducument. Name the document, and then click Save. Now your main document will work as merge document.
98 :: Data Entry Operations
5.4.5 Merging the Data into the Main Document
Merging the data into the main document is the last step of the Mail Merge Wizard. Click on the << or >> button to display the preview of the main letter with address data before you close the merge document and take the printout of the letter.
Fig. 5.
Once finished click on the “Next: Complete the Merge” option on the dialog box to complete the merging process.
Fig. 5.
5.5 CREATING MAILING LABELS BY MERGING AN
ADDRESS LIST
If you have already created a data source (say address list) as explained earlier, it is easier to merge this address list with your
100 :: Data Entry Operations
Fig. 5.
- Once the data file is selected, based of the type of data file is selected, Mail Merger will ask you to define how to distinguish between data fields and data record.
- Once it is done, the data file will be loaded in to Mail Merger and you can now click on Edit Recipient List button under the sub task Start Mail Merge to be able to edit the list as per your requirement.
- To locate a data record that you want to change, move to the record number you want change its contents by clicking the arrow keys or typing the record number; or click Find, and then search for information that you know the record contains.
- Edit the records that you want to change and save the changes.
- Select Mailings→→→→→Write & Insert Fields sub-task and click on the Insert Merge Field to insert merge fields where you want to merge addresses from the data source to be inserted on the labels document. Click Insert Merge Field and then click the field name you want to be inserted and click OK. The selected data field or filename will get inserted on to the labels document and you can continue selecting the entire set of data field name you want to appear on the label document.
Mail Merge :: 101
Fig. 5.
- Merge the Data into the Main Document: In the Mailings tab bar, click on the Preview Results to display the merged labels with actual data from the selected data source before the labels are printed. This will help you to view the label as they will get printed and take any corrective measures if required before the labels are finally printed. You can also move around the set if data fields to preview all the labels using < and > button available under Preview Results sub- task.
Fig. 5.
- Merge the data with the document. If you want to send the merged labels directly to a printer, click Finish & Merge sub-task under Mailings tab, and then click Print Documents.
- The merged labels will be printed and will look like
Fig. 5.
Mail Merge :: 103
you want to create new address list or use and exiting one.
- Select Use Existing List to display the Select Data Source dialog box. Browse to the location where you have created your data source (address list), and then click Open button.
- You can open various data file format such as Access database, Excel files, Word File, Rich Text format etc.
Fig. 5.
- Once the data file is selected, based of the type of data file is selected, Mail Merger will ask you to define how to distinguish between data fields and data record.
- Once it is done, the data file will be loaded in to Mail Merger and you can now click on Edit Recipient List button to be able to edit the list as per your requirement.
- To locate a data record that you want to change, move to the record number you want change its contents by clicking the arrow keys or typing the record number; or click Find, and then search for information that you know the record contains.
- Edit the records that you want to change and save the changes.
- In Mailings Tab under Write & Insert Fields sub-task, click on the Insert Merge Field to insert merge fields where you want to merge addresses from the data source to be inserted on the labels document. Click Insert Merge Field and then click the field name you want to be inserted and click OK. The selected data field or filename will get inserted on to the envelope and you can continue selecting the entire set of data field name you want to appear on the envelope document.
104 :: Data Entry Operations
Fig. 5.
- Merge the Data into the Main Document: In the Mailings tab bar, click on the Preview Results to display the merged labels with actual data from the selected data source before the labels are printed. This will help you to view the label as they will get printed and take any corrective measures if required before the labels are finally printed. You can also move around the set if data fields to preview all the labels using < and > button available under Preview Results sub-task.
Fig. 5.
- Merge the data with the document. If you want to send the merged labels directly to a printer, click Finish & Merge sub-task under Mailings tab, and then click Print Documents.
INTEXT QUESTIONS
- What is the difference between main document and merge document in Main Merge?
- In Mail Merge, a data source can be created using ——— —— or—————.
- You can merge the data records to—————— or ———.
- To send the merged documents for electronic mailing, it is necessary that your computer has the ————— connection.
Fig. 5.
