Apache OpenOffice Community Forum

Greetings:

I have several writer documents that use the mail merge facility to import data from my database.

What I am trying to do now is convert those documents (or rewrite) as form documents so that I can use the form and subforms to control what is displayed in the document. While I can insert fields anchored as characters, I can't find a way to make the fields resize to fit the contents. Does anyone know a way to do this?

Hello,
IMPOV an unnecessary approach.
Why not filling the datas for each mail into the database, then maybe use a query or view to combine them as desired, one row for each letter.
Then mail merge all in one step.
That's the intend of mail merge.
R

F3K Total wrote:Hello,
IMPOV an unnecessary approach.
Why not filling the datas for each mail into the database, then maybe use a query or view to combine them as desired, one row for each letter.
R

Even though I referred to mail merge, I was referring to the tool, not that I am trying to accomplish a mail merge.

What I have is several tables in the DB with one to many relationships. A much simplified version would be like this:

Project People (Note; This is NOT good design and I know it. But it works and fixing it is not what this post is about.)

There is a filter table to select the project and queries that extract project info and manager info into a one line record as you suggest. There are two other queries that generate a list of people in roll1 and another for roll2. I need to be able to have documents that have the project details entered at a variety of spots, then list all the roll1 people and contact info, then more text and list all the roll2 people. Basically, to "merge" I have to open data sources, select the project query, and click data to fields, then find the roll1_query, select all records and click data to fields, then the same for roll 2.

I can do all of the same using form controls in the document. It needs to look like a word-processed document though.