Repeat step 2 as needed, and choose Close when done.įor more information about adding fields from your spreadsheet to the merge document, see Insert mail merge fields.In the Insert Merge Field dialog box, under Fields, choose a field name (column name in your spreadsheet), and then choose Insert.On the Mailings tab, in the Write & Insert Fields group, choose Insert Merge Field.To insert data from your spreadsheet in an email message or a letter Under Greeting line for invalid recipient names, choose an option in the salutation list.Under Greeting line format, change the salutation if necessary by choosing the greeting ( Dear is the default), the format for the recipient name, and the ending punctuation (a comma is the default).and.In the Insert Greeting Line dialog box, do the following:.On the Mailings tab, in the Write & Insert Fields group, choose Greeting Line.To insert a greeting line in an email message or a letter In the Insert Address Block dialog box, choose a format for the recipient’s name as it will appear on the envelope.On the Mailings tab, in the Write & Insert Fields group, choose Address Block.To insert an address block for an envelope, a label, an email message, or a letter You can insert one or more mail merge fields that pull the information from your spreadsheet into your document. For more information about sorting and filtering items, see Sort and filter the data for a mail merge. Note: You also can sort or filter the list to make it easier to find names and addresses.

Mailings tab excel