[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