LO will not send emails via mail merge.
I’ve used LO 5.5 and 6, on Windows 7 and 10, at work and now at home, two different smtp servers (one gmail, one for work), and more security/authentication/port combinations than fit on two bingo cards, and nothing works.
Tools->Options->LO Office Writer->Mail Merge Email->Test Settings can frequently be successful on both lines with both gmail and my work smtp; but even when a configuration passes that test Writer is still not successful at actually sending email. When you click [send email messages] I frequently get “connection…established” “17 of 17 emails sent” (erroneous tho, none are actually sent) then right below it, the awful truth at the bottom line: “Emails not sent: 17.” Then down below it shows “sending failed” on on the individual emails.
I get indistinguishable behavior whether I’m using the gmail server or my work server. With both I can find multiple authentication/security/port combinations to pass the test, but none that will actually send email. Until I can get it to work with gmail my work ISP just wants to blame LO doesn’t want to help me but I have to do this for work
Last but not least, during my tests Google sent me a security warning that an unauthorized app was trying to access my account and it asked me if I wanted to authorize “less secure app access.” So I turned that on, thinking FINALLY I had solved it, but no. Still sent no sent emails from Writer. Thanks for helping.
update: work’s ISP is getting no authentication requests from me on their logs when I try to send the emails. They say they have not blocked Libre in a firewall or similar and they basically shrugged their shoulders and will no longer help me. They say basically it looks like Libre’s signals aren’t leaving my office–at least, they aren’t reaching the email server at the ISP.