To all the dumb spammers and legitimate info brokers out there, this is the most simple code snippet I could write in affordable time.
1a. Extract the Python module to <profile>/Scripts/python/
1b. Edit the SMTP settings on top of the module. You can open Python modules with Writer but do not change the line indentation. Just edit the double-quoted values between the hash fences.
2. Select a 3-column list of spreadsheet cells: (1)mail addresses, (2)subject line, (3)multi-line body text
The selection must not be a filtered range. Copy any filtered range to another area and select that adjacent range. The selection should not include any header row (column labels). Any columns beyond #3 will be ignored.
3. menu:Tools>Macros>Python... sendMailsFromRangeSelection
You can use Calc's concatenation methods and text functions to compose the messages on the sheet. If you can't even do that, there is not the faintest reason to use a spreadsheet anyway.