To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=113118
Issue #|113118
Summary|macro with mailmerge & mysql trows last DB row
Component|scripting
Version|OOO320m12
Platform|PC
URL|
OS/Version|Linux
Status|NEW
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|code
Assigned to|kr
Reported by|edonia
------- Additional comments from edo...@openoffice.org Tue Jul 13 09:34:36
+0000 2010 -------
I'm working with OOo 3.2.0 on ubuntu 10.04 and mysql 5.1.41
I have a macro with the following code:
Sub serienbrief
Dim MailMerge as Object
Dim DocumentURL as String
MailMerge = createunoservice("com.sun.star.text.MailMerge")
Mailmerge.DataSourceName="db-cn-mysql"
MailMerge.DocumentURL=ConvertToUrl("/path_to_doc/mydoc.ott")
MailMerge.CommandType=1
MailMerge.Command="my query"
MailMerge.OutputType=3
MailMerge.Subject="my subject"
MailMerge.AddressFromColumn="email"
MailMerge.SendAsAttachment=0
MailMerge.execute(Array())
MailMerge.Dispose()
End Sub
The database is an mysql DB, the connector mysql(native).
If I run this basic, the last row from the DB are not used. If I do open the
query, all entries of the query are shown. If I do send a mailmerge, with the
GUI, all entries in the query get an mail. Using this marco, all entries except
the last in the query get an email.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@script.openoffice.org
For additional commands, e-mail: issues-h...@script.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
