How to send e-mail to multiple e-mail addresses from Calc

Hello,

I have been trying to figure out how I can send out an e-mail to multiple e-mail addresses I have on a list in Calc in various cells outside of having to select certain groups of them then do something in order for them to show up in the To field at some point but haven’t had much luck with this and thought I could try here.
Thank you in advance if you reply to this.

Use the Mail Merge Wizard in Writer and in Select Address List add the spreadsheet document and sheet. You can setup a filter there. See also the Mail Merge chapter in the Writer Guide.