How to Link LibreOffice Writer Labels to Database

users
#1

Can someone tell me how to link Libreoffice Writer to a LibreOffice Base
Database so that opening the saved label file will automatically bring up
any changes that has been made to the database without any prompts.

At present I either see a way to bring up a saved mail merge file that will
bring up the same data (old if the database has changed), or will bring up
the pre-merged file that needs to have the sequence to use the mailmerge
tool to update the information.

These are the current steps I have to do to see or print the new data:

Click on Merge file -> Answer the prompt to get the most recent data (now I
have one page of the first record) -> Click Tools -> Mail Merge Wizard ->
Next -> Next -> Next -> Next -> Next -> Next -> (click) Save starting
document -> Finish

Now I have the updated data.

I'm hoping to have a way to save a file where one click on the file will
bring up the updated data without any prompts.

Thanks in advance for any input on this.

-- L. James

#2

Hi :slight_smile:
The Base Handbook might be able to help with this
https://wiki.documentfoundation.org/Documentation/Publications

First it is worth quickly skimming through the "Getting Started" guide's
chapter on Base.

There is also an Faq that might lead you through something very similar
https://wiki.documentfoundation.org/Faq

It is generally better to base such "reports" or "forms" off Queries rather
directly off Tables. It makes the system more flexible for the future as
it allows changes in the underlaying Table to be abstracted away so that
the Form/Report can still get the same inputs that it expects.
Regards from
Tom :slight_smile:

#3

Thanks for the links, TomD.

I had done a lot of research and reading the FAQ before posting my message. It might be possible that what I was trying to do can't be done (a one click to bring the fresh data to a labeling merge).

I put the objective in to words the best way I could. There is a chance I might not be describing it the best way. I was hoping someone in the community might understand the question well enough to maybe assist me in clarification as well as how to do it if it could be done, or some close workaround.

I really don't have any problems with the 6 to 10 clicks to print a new list. I was mainly trying to make it easy for office workers with little computer and data skills to perform a single click and have the new data and print a new labels.

As you suggested I'll study closer the features of LibreOffice Base for setting up the objective in forms. I already undestand that it can be done that way. But again, I was looking for a way to perform this in LibreOffice Word because I wanted to use the same feature for using linked fields in other databases such as mysql.

If I learn of a better way to clarify this task, I'll update the thread.

Thanks again for the input, as well as input from anyone else that might have some insight on this.

-- L. James