Hi,
does anybody now how the fields in a writer-doc have to be named when
using the code todo an automatic mail-merge?
---8---
Object dbContext = xMSF.createInstance(com.sun.star.sdb.DatabaseContext);
XNameAccess nameAccess =
(XNameAccess)UnoRuntime.queryInterface(XNameAccess.class, dbContext);
Object dataSource = nameAccess.getByName(mailMerge);
if( dataSource != null ) {
Object mService =
xMCF.createInstanceWithContext(com.sun.star.text.MailMerge,
xComponentContext);
System.out.println(Before Query is registered!);
registerQuery(dataSource);
System.out.println(Query is registered!);
XPropertySet oObjProps =
(XPropertySet)UnoRuntime.queryInterface(XPropertySet.class, mService);
oObjProps.setPropertyValue(DataSourceName, mailMerge);
oObjProps.setPropertyValue(Command, SELECT a, b FROM bla );
oObjProps.setPropertyValue(CommandType,new
Integer(com.sun.star.sdb.CommandType.COMMAND));
oObjProps.setPropertyValue(OutputType,new
Short(com.sun.star.text.MailMergeType.PRINTER));
oObjProps.setPropertyValue(DocumentURL, templateFile);
XJob job = (XJob) UnoRuntime.queryInterface(XJob.class, mService);
System.out.println(Print job is getting started!);
try {
job.execute(new NamedValue[0]);
System.out.println(Print job is started!);
}
catch (com.sun.star.lang.IllegalArgumentException iae) {
System.err.println(Caught IllegalArgumentException: + iae);
}
catch (com.sun.star.uno.Exception e) {
System.err.println(Caught UNO Exception: + e);
}
---8---
The main problem is that I don't want OO to pop-up and that's why I can
register a query because it needs an opened OO-Window.
When using an registered Query the field holds myquery.a, myquery.b is
there any default?
Tom
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]