mail merge and page break

[rbag]

Hi all,

I try to do something and it don't seems to be possible, i'd like to have your opinion.

the objective is to display tabular data with the mail merge, ie:

Page 1
header
record1 => field1 field2
record2 => field1 field2
record3 => field1 field2
record4 => field1 field2
footer

I succed to display the header only on the first page and the footer on the last page (with hidden paragrah), but I can't figure how to remove (or not to display) the page break between each record.

moreover the record data are displayed in a table and I don't want any line break between two records (to make a kind of table display)

someone has an idea ?

[JohnV]

In a new Writer document do F4, open your DB, open the Tables item and click your table. Select the records you want to display with the boxes to their left (upper left selects all) and click the Data to Text icon found above the field names.

You should be able to handle it from there and after you do you can insert both a header and footer for all pages because they will all have the same page style (header/footer is a property of the page style).

[rbag]

It's more a workaround than a solution :-/

my data source comes from an application, the mail merge must be done automaticaly, the users should not have to make any manipulation on the document to be printed :-/

this is quite easy on ms office but we would like to propose the same functionnality with OOo.

[JohnV]

[rbag]