Mail Merge from different tables in database?

users
#1

Dear all:
Can I create a mail merge that include data from different tables in
database?
Suppose that I have a ods file with 2 sheets (sheet1 and sheet2), I setup a
connection to this spreadsheet in Base for using Mail Merge.

Then I creat a odt file that linked some data in database from
Table1(sheet1) and Table2(sheet2) respectively.

And the results of Mail Merge can not include data Table1(sheet1) and
Table2(sheet2) at the same time.

Do you know how to include data the come from different database Tables
when using Mail Merge?

Thank you~

Regards,
Minhsien0330

#2

Hi Minhsien0330

Suppose that I have a ods file with 2 sheets (sheet1 and sheet2),
I setup a connection to this spreadsheet in Base for using Mail
Merge.

[...]

Do you know how to include data the come from different database
Tables when using Mail Merge?

Look for the odb-file representing your data source, which is
possibly based upon an ods-file . You can edit this database
connection using LibreOffice Base. Create a query in Base that joins
your two tables. In Writer refer to this query as your data source.

Cheers,
Stefan