I have got an Excel spreadsheet data source with the following four headings in A1:D1:
First Last Email1 Email2
First is the first name.
Last is the last name.
Email1 is the simple email address: email@example.com.
Email2 is the display as form: John Doe (firstname.lastname@example.org).
The workbook has been named and saved to a folder.
I have written the mail merge document in MS Word and gone through all the steps to insert the fields. The only thing I can remember is how/where to insert or designate the email addresses (using column C, Email1).