To add a block to the document, click OK. Select Address Fields to insert standard fields or Database Fields to insert custom fields from a data table in the window that opens.

To add individual placeholders, click More items. These blocks contain ready-made formatting for inserting data from the source file, which you can check immediately using the preview from your recipient list. The program offers ready-to-use placeholders filled with data from the table by clicking on Match Fields on the ribbon or in the 'Address block' / 'Greeting line' window. The data to fill in the fields will be suggested depending on which source you selected in the previous step. Once you've got the recipients selected, proceed to Step 4, 'Write your message'.Ĭreate the message text and add placeholders in the right places to be filled in with individual data from an Excel spreadsheet or ready-made template options. This is primarily a selection of the recipient list from the existing data-source list, Outlook contacts, or a new list that can be created right here. In Step 3, select the data source for the mail merge. Merge data source with a message template Select a saved mailing message template and continue editing. Select starting document you want to use as the basis: In Step 1, 'Select document type,' check the Email messages box and go to Step 2, 'Starting document'. Start the 'Step-by-Step Mail Merge Wizard': on the Mailings ribbon tab, click Start Mail Merge, and at the bottom of the drop-down list, select Step-by-Step Mail Merge Wizard. To combine data from the source table with the mailing text, you need to create a message template with fields for this data.

After you finish entering data into the table, save it. The table columns must contain a header, and personal information is in separate rows for each recipient. In general, the data table looks like this: Discover more about creating an Excel Data Table in our article on how to mail merge from Excel to Outlook. The program will then add that information to the indicated fields, i.e., merge the data from the file with the message template. To add personal information to your message template, you must first assemble it into a data table. Try For Free Create an Excel data file with personal information

How to do mailmerge