I am a very limited user of spreadsheets. I have created a Libre calc sheet of about 75 businesses that I need to email a flyer to. This is not spam, it concerns an upcoming event. What I need help with is getting those email addresses into an email that I can send out with the information. I want to do this painlessly which is why I posted here. I would probably eventually figure it out but this will make it much quicker and less frustrating. I really appreciate any help you folks can give.
If an email client is configured to be called this way you can create emails to the addresses collected one by one clicking a hyperlink in your sheet. Please note that the hyperlink for mailing always has to start with “mailto:”. mailto:Some.One@any.dom will work (if the address exists, of course).
Exporting addresses into an existing mail under editing is a completely different task and surely much more complicated.
To create a mail using multiple addresses (visible to all the addressees) you have to concatenate the strings “mailto:”&‘FirstAddress’&";"&‘NextAddress’ and so on and use the HYPERLINK() function to make it work. This might not be what you want seeing yourself as a ‘limited user’