[Libreoffice-bugs] [Bug 117221] New: MailMerge: Not recognising outgoing SMTP Server password when supplied by macro
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Wed Apr 25 07:57:02 UTC 2018
https://bugs.documentfoundation.org/show_bug.cgi?id=117221
Bug ID: 117221
Summary: MailMerge: Not recognising outgoing SMTP Server
password when supplied by macro
Product: LibreOffice
Version: 6.1.0.0.alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: BASIC
Assignee: libreoffice-bugs at lists.freedesktop.org
Reporter: mcmurchy1917-bugzilla at yahoo.co.uk
Because the password is stored in registrymodifications.xcu in clear text. See
Bug 96672 - Outgoing mail server password in clear text inside the
registrymodifications.xcu file
I elected to supply the Outgoing mail server password using a text box and
supplying the password to MailMerge using this property OutServerPassword
within a macro as in the following code snippet.
oMailMerge = CreateUnoService("com.sun.star.text.MailMerge")
oMailMerge.DocumentURL = ConvertToUrl(strSelectedTemplate)
oMailMerge.DataSourceName = "MySQLDataBase"
oMailMerge.CommandType = 0 'Command
oMailMerge.Command = "MySQLDataBase.tbl_temporary"
oMailMerge.OutputType = com.sun.star.text.MailMergeType.MAIL
oMailMerge.Subject = strTitle
oMailMerge.AddressFromColumn = "Email_Address"
oMailMerge.OutServerPassword="XXXXXXX YYYYYYY"
oMailMerge.SendAsHTML = True
oMailMerge.execute(Array())
It didn't work! Returned this information in an Error Message Box -
BASIC runtime error.
An exception occurred
Type: com.sun.star.uno.Exception
Message: Mail merge failed. Sorry, no further information available..
--
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180425/ab54409a/attachment.html>
More information about the Libreoffice-bugs
mailing list