how do i select recipients for email mail merge from a spreadsheet

Hello DennisJeffrey1,  

Welcome to the Microsoft Community.

To use the mail merge feature, you should initiate it from Word, and the data source for contacts and other information can be imported via an Excel spreadsheet. This article provides a detailed explanation of this feature for your reference: Use mail merge in Word to send bulk email messages - Microsoft Support

In general, to use an Excel spreadsheet as the data source for mail merge, you need to ensure the format is correct. For format requirements, please refer to: Prepare your Excel data source for a Word mail merge - Microsoft Support

Once your spreadsheet is ready, in Word, select Mailings - Select Recipients - Use an Existing List.

Word will automatically recognize the contents of these tables and create emails based on the recipients and email addresses in them.

Please note that mail merge requires an email client that supports MAPI, such as Outlook rather than Outlook (new).

If you think this information is helpful, or if you still have any questions about it, feel free to let me know in your reply!Best RegardsEliac | Microsoft Community Support Specialist