Objectives

1. Objectives

2. Chapter 16: Merging DocumentsPerformance Objectives • Complete a Merge • Create a Data Source File • Create a Main Document • Preview a Merge • Check for Errors • Merge Documents • Merge Envelopes • CHECKPOINT 1 • Merge Labels • Merge a Directory • Edit a Data Source File • Insert Additional Fields • Merge with Other Data Sources • CHECKPOINT 2

3. Complete a Merge • A merge generally takes two files: a main document and a data source file. • The main document contains the standard text and/or the fields that identify where variable information will be inserted during the merge. • The data source file contains the variable information that will be inserted into the main document.

4. Complete a Merge…continued Mailings tab

5. Create a Data Source File • Before you actually create the main document, you must determine the type of variable information you will need to insert into that document and create a data source file. • Word provides predetermined field names for this purpose. • Use these field names if they represent the data you are creating. • Variable information in a data source file is saved as a record. • A record is a series of fields, and each record contains all of the information for one unit (for example, a person, family, customer, client, or business). • A data source file is a series of records.

6. Create a Data Source File…continued To create a data source file: • Click the Mailings tab. • Click the Select Recipients button in the Start Mail Merge group. • Click the Type New List option at the drop-down list. • Type the data in the predesigned or custom fields. • Click OK. Select Recipients button

7. Create a Data Source File…continued The fields in one row make a record. Type text in a field in this dialog box and then press Tab to move to the next field.

8. Create a Data Source File…continued To customize the predesigned fields: • At the New Address List dialog box, click the Customize Columns button. • Click the Add, Delete, or Rename buttons in the Customize Address List dialog box. • Click OK or Yes at any confirmation dialog boxes. • Click OK to return to the New Address List dialog box. Customize Address List dialog box

9. Create a Main Document To create a main document: • Click the Mailings tab. • Click the Start Mail Merge button in the Start Mail Merge group. • Click the desired document type at the drop-down list. • Type the main document text and insert fields as needed. Start Mail Merge button

10. Create a Main Document…continued To insert address fields: • Click the Mailings tab. • Click the Address Block button in the Write & Insert Fields group. • At the Insert Address Block dialog box, click the OK button. Address Block button

11. Create a Main Document…continued Insert Address dialog box

12. Create a Main Document…continued To insert greeting line fields: • Click the Mailings tab. • Click the Greeting Line button in the Write & Insert Fields group. • At the Insert Greeting Line dialog box, make the desired changes. • Click OK. Insert Greeting Line dialog box

13. Create a Main Document…continued To insert a field: • Click the Mailings tab. • Click the Insert Merge Field button arrow in the Write & Insert Fields group. • Click the desired field in the drop-down list. Insert Merge Field button arrow

14. Preview a Merge To view the main document: • Click the Mailings tab. • Click the Preview Results button in the Preview Results group. Preview Results button

15. Preview a Merge…continued First Record button Previous Record button Go to Record button Next Record button Last Record button

16. Preview a Merge…continued To find a record: • Click the Mailings tab. • Click the Find Recipient button in the Preview Results group. • At the Find Entry dialog box, type the specific field entry in the Find text box. • Click the Find Next button. • Continue clicking the Find Next button until there are no more entries. • Click OK. Find Recipient button Find Entry dialog box

17. Check for Errors To automatically check for errors: • Click the Mailings tab. • Click the Auto Check for Errors button in the Preview Results group. • At the Checking and Reporting Errors dialog box, click the desired option. • Click OK. Auto Check for Errors button Checking and Reporting Errors dialog box

18. Merge Documents To merge documents and create a new document: • Click the Mailings tab. • Click the Finish & Merge button in the Finish group. • Click the Edit Individual Documents at the drop-down list. • Make sure All is selected in the Merge to New Document dialog box. • Click OK. Finish & Merge button

19. Merge Documents…continued • You can identify specific records you want merged with options at the Merge to New Document dialog box. • Display this dialog box by clicking the Finish & Merge button in the Mailings tab and then clicking the Edit Individual Documents option at the drop-down list. Merge to New Document dialog box

20. Merge Envelopes To merge envelopes: • Click the Mailings tab. • Click the Start Mail Merge button in the Start Mail Merge group. • Click the Envelopes option at the drop-down list. • Click OK at the Envelope Options dialog box. Envelopes option

21. Merge Envelopes…continued Envelope Options dialog box

22. Merge Envelopes…continued To identify an existing data source file: • Click the Mailings tab. • Click the Select Recipients button in the Start Mail Merge group. • Click the Use Existing List option at the drop-down list. • At the Select Data Source dialog box, navigate to the folder that contains the data source file you want to use and then double-click the file. Use Existing Listoption

23. Merge Envelopes…continued To insert the AddressBlock field: • Click in the envelope to position the insertion point where the recipient’s address should appear. • Click the Address Block button in the Write & Insert Fields group. • Click OK. insertion point

24. CHECKPOINT 1 • This document contains the standard text and/or the fields. • main • data source • standard • default • The AddressBlock field is an example of this type of field that groups a number of fields together. • coordinate • collaborate • composite • collective Answer Answer Next Question Next Question • Variable information in a data source file is saved as this. • a file • a record • a field • a code • If you want to search for and preview merged documents with specific entries, click this button. • Find • Replace • Find and Replace • Find Recipients Answer Answer Next Question Next Slide

25. Merge Labels To merge labels: • Click the Mailings tab. • Click the Start Mail Merge button in the Start Mail Merge group. • Click the Labels option at the drop-down list. • Select the desired label at the Label Options dialog box. • Click OK. Labels option

26. Merge Labels…continued Choose the desired label product number from this list box. Click this down-pointing arrow to display a list of available label vendors.

27. Merge Labels…continued To update all labels: • Click the Mailings tab. • Click the Update Labels button in the Write & Insert Fields group. Update Labels button

28. Merge a Directory • When you merge letters, envelopes, or mailing labels, a new form is created for each record. • For example, if the data source file merged with a letter contains eight records, eight letters are created. • If the data source file merged with a mailing label contains twenty records, twenty labels are created. • In some situations, you may want merged information to remain on the same page. • This is useful, for example, when you want to create a list such as a directory or address list.

29. Merge a Directory…continued To merge a directory: • Click the Mailings tab. • Click the Start Mail Merge button in the Start Mail Merge group. • Click the Directory option at the drop-down list. Directory option

30. Edit a Data Source File To edit a data source file: • Open the main document. • Click the Mailings tab. • Click the Edit Recipient List button. (continues on next slide) Edit Recipient List button

31. Edit a Data Source File…continued • At the Mail Merge Recipients dialog box, click the data source file name in the Data Source list box. • Click the Edit button. • Make the desired changes in the Edit Data Source dialog box. • Click OK to return to the Mail Merge Recipients dialog box. Edit button

32. Edit a Data Source File…continued Edit the fields in the records in the data source file at this dialog box.

33. Edit a Data Source File…continued Select specific records by removing the check marks from those records you do not want included in the merge.

34. Insert Additional Fields • Word’s Merge feature contains a large number of fields that you can insert in a main document. • One such field, the Fill-in field, is used to input information with the keyboard during a merge. • In some situations you may not need to keep all variable information in a data source file. • Insert a Fill-in field in a main document to input variable information into a document during the merge using the keyboard.

35. Insert Additional Fields…continued To insert a fill-in field in the main document: • Click the Mailings tab. • Click the Rules button in the Write & Insert Fields group. • Click the Fill-in option at the drop-down list. • Type the prompt text. • Click OK. • Type the text to be displayed in the document. • Click OK. Fill-in option Insert Word Field: Fill-in dialog box

36. Insert Additional Fields…continued • When you merge the main document with the data source file, the first record is merged and the Microsoft Word dialog box displays with the message you entered displayed in the upper left corner. • Type the required information for the first record in the data source file and then click OK. • Word displays the dialog box again. • Type the required information for the second record in the data source file and then click OK.

37. Insert Additional Fields…continued • If you are merging a small number of records, you can look at each merged document to determine if all records merged and printed. • If you have a large number of records in a data source and want to ensure that each document merges and prints, consider inserting a Merge Record # field in the document. • This field will insert a record number in each merged document. • With the merge record number in each letter, you can ensure that all letters print.

38. Insert Additional Fields…continued To insert a record number in each merged document: • Click the Mailings tab. • Click the Rules button in the Write & Insert Fields group. • Click the Merge Record # option at the drop-down list. Merge Record # option

39. Insert Additional Fields…continued To use an If…Then…Else… field: • Click the Mailings tab. • Click the Rules button in the Write & Insert Fields group. • Click the If…Then…Else… option at the drop-down list. • Specify the options in the Insert Word Field: IF dialog box. • Click OK. If…Then…Else… option

40. Insert Additional Fields…continued Click the down-pointing arrow at the right of the Field nameoption box and then click the field name you want Word to compare. Click the down-pointing arrow at the right of the Comparison option box and then click the desired value option you want Word to use when comparing the specified field. Type in this text box the specific field value you want Word to use when comparing text in the specified field.

41. Insert Additional Fields…continued • Once you have established the field name and specific field entry, you then type in the Insert this text text box the text you want inserted if the field entry matches, and type in the Otherwise insert this text text box the text you want inserted if the field entry is not matched. • You can also leave the Otherwise insert this text text box empty. • This tells Word to not insert any text if the specific entry value is not met. • By default, an If…Then…Else… field does not display in the document.

42. Merge with Other Data Sources • Word saves a data source as an Access database with the .mdb file extension. • You can use other data sources to merge with a main document such as a Word document containing data in a table, an Excel worksheet, an Access database table, and an Outlook contacts list.

43. Merge with Other Data Sources…continued To match fields: • Click the Mailings tab. • Click the Match Fields button in the Write & Insert group. • At the Match Fields dialog box, click the down-pointing arrow at the right side of the field you want to match. • Click the desired field at the drop-down list. Match Fields dialog box

44. Merge with Other Data Sources…continued To use an Access database table as a data source: • Click the Mailings tab. • Click the Select Recipients button in the Start Mail Merge group. • Click the Use Existing List option at the drop-down list. • Navigate to the desired folder and double-click the desired file. • At the Select Table dialog box, click the desired table. • Click OK. Select Table dialog box

45. CHECKPOINT 2 • Select this type of main document when you want to create a list. • letter • label • envelope • directory • A Fill-in field is inserted in a main document by clicking this button. • Insert Merge Field • Rules • Edit Recipient List • Find Recipient Answer Answer Next Question Next Question • If you do not want a specific record included in a merge, remove this in the Mail Merge Recipients dialog box. • arrow • check mark • dash • circle • The Mail Merge wizard guides you through the merge process in how many steps. • 2 • 4 • 6 • 8 Answer Answer Next Question Next Slide