Use Mail Merge To Create Form Letter. The manual method of creating a form letter described in Creating a form letter provides the most control over the result and is therefore recommended. For the Many To One Merge with Attachments and Merge to Individual Docs utilities the data source may be either a table or query in an Access database or in the form of an Excel worksheet and that worksheet must be the first sheet in the Excel workbook.
You can enter a description of the template. This video demonstrates how to perform a mail merge to create individualized form letters using Microsoft Word and Microsoft Excel. Using the Mail Merge Wizard to create a form letter The recommended way to create a form letter is the manual method described in Creating a form letter.
Select Get Data.
As you make selections in this box other selections will become available. For the Many To One Merge with Attachments and Merge to Individual Docs utilities the data source may be either a table or query in an Access database or in the form of an Excel worksheet and that worksheet must be the first sheet in the Excel workbook. Select the source file containing the data set. As you make selections in this box other selections will become available.