![]() The only difference with the 1 st option is that in this case the pages corresponding to the selected records will be printed directly.ģ. ![]() If you click on this option, you will also get the Merge to New Document dialog box. The resulting document can then be printed or saved on your computer. This is particularly useful if you want to modify the pages for a few records. In this case, a new document corresponding to the selected records is created. rows, from the linked Excel list that will be used for the merge. This dialog box allows you to select the records, i.e. If you click on this option, the Merge to New Document dialog box appears. The 1 st option: Edit individual Documents. You can disable this display mode by clicking on this command again.īy clicking on the Finish & Merge menu on the Mailings tab of the ribbon, 3 options are available:ġ. If you need to highlight merge fields, which is useful when the document contains a large number of fields, use the Highlight Merge Fields command on the Mailings tab of the Ribbon. You can also enter a number in the Go to Record field and press Enter on the keyboard to go to the corresponding record. Use the buttons in the Preview Results group on the Mailings tab of the Ribbon to navigate between the records in the list. If you want to deactivate the Preview Results mode, click on this command again.ĥ. Notice that the column headers are replaced by the data retrieved from the list. Click the Preview Results command on the Mailings tab of the Ribbon. The merge fields are displayed as the column headers of the linked list surrounded by inverted commas.Ĥ. Repeat steps 2 and 3 for the text "First name", "Last name" and "City". Each copy relates to a subscriber of the association. Each cell value in column C will be inserted into the document producing 1474 copies. The Title submenu is the header of column C of the linked Excel sheet. Open the Insert Merge Field menu on the Mailings tab of the Ribbon and click on Title In this step, we will replace the text Mr/Mrs, First name, Last name and City in the template document with the information from the list of subscribers in the Excel sheet. However, no information from the list of members is yet integrated into the document. ![]() If you click on the Last Record button, the value 1474 is displayed in the Go to Record field.If you open the Insert Merge Field menu, you will see the column headers of the linked Excel sheet.The controls on the Mailings tab of the Ribbon that have become active. ![]() Remember that an Excel file can contain many sheets. This opens the Select Table dialog box, allowing you to select the sheet where the list of subscribers is written. Then use Windows File Explorer, which opens, to point to the Excel file containing the list of members. This requires Outlook to be configured on your computer.įor our example, use the 2 nd option Use an Existing List.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |