Forum Discussion
Email merge from High School Classmates Spreadsheet
have an Excel workbook with High School Class information. Some entries (class members) have email addresses and some do not. I would like to send a personalized email to all those with addresses ski...
Hi Larry,
use your Excel file as is and follow the steps in this article:
https://support.microsoft.com/en-us/word/mail-merge-using-an-excel-spreadsheet
In step 2 "Mail Merge Recipients" you'll see a note and in there is the link to the sub article
https://support.microsoft.com/en-us/word/query-options-filter-dialog
Simply filter the data to include only recipients with email addresses. That's it.
Andreas.