[script-issues] [Issue 113118] macro with mailmerge & my sql trows last DB row
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113118 User os changed the following: What|Old value |New value CC|''|'hi' Keywords| |needmoreinfo --- Additional comments from o...@openoffice.org Fri Nov 5 08:41:47 + 2010 --- ->edonia: To find the reason it would be helpful if you could provide some additional information. - Instead of output to email try to output to file (needs OutputType=1, and OutputURL set). Does this resulting file contain all entries? - If the former works try with SaveAsSingleFile = True. - If both fail try to use the bibliography data as data source. - 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
[script-issues] [Issue 113118] macro with mailmerge & my sql trows last DB row
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113118 User oj changed the following: What|Old value |New value Assigned to|oj|os --- Additional comments from o...@openoffice.org Thu Nov 4 14:31:46 + 2010 --- Could you please have a look at it or delegate it? Thanks. I don't know who is responsible for that. - 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
[script-issues] [Issue 113118] macro with mailmerge & my sql trows last DB row
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113118 User kr changed the following: What|Old value |New value Assigned to|kr|oj --- Additional comments from k...@openoffice.org Thu Nov 4 13:31:15 + 2010 --- Ocke, please have a look. - 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
[script-issues] [Issue 113118] macro with mailmerge & my sql trows last DB row
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
+ 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
