Ask Your Question

Sharing variable values across documents [closed]

asked 2013-10-16 20:42:54 +0100

satvikberi gravatar image

I use a lot of templated documents, such as leases, where I'll enter parameters such as someone's name, phone number, etc. and have them appear several times in the document. Currently I do this by setting up User Variables for each template, then editing those variables when I want a new lease for a specific situation.

But I have several writer documents per lease. So I have to enter redundant information in the user variables of each document. Ideally I'd like to just enter these variables into one Calc file and have my writer documents insert values from cells in this Calc file. What's a good way to do this?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-12 02:09:41.927666

1 Answer

Sort by » oldest newest most voted

answered 2013-10-17 19:33:57 +0100

w_whalley gravatar image

Mail Merge should work for you. Mail Merge can use a spreadsheet as a data source and several Writer documents can use the same data source. Mail merge is covered in Chapter 11 of the LibreOffice Writer's Guide. This link offers a shorter version using the Mail Merge Wizard.

Assuming you have spreadsheet and documents already: Register your spreadsheet as the data source (see documentation or Edit>Exchange Database or Tools>Mail Merge Wizard)

In the Writer document, view data sources (F4)

Click on the field titles in the tabular data source display and drag the fields to the places in the document where you want them. Save the document.

Print the document--answer yes to the form letter question.

In the Mail Merge dialog be sure you are using the correct data source.

Choose the records to print. If you just want one, click the data margin to select it

Print to Printer or File.

edit flag offensive delete link more


Thanks! This is precisely what I needed.

satvikberi gravatar imagesatvikberi ( 2013-10-22 21:38:14 +0100 )edit

Question Tools

1 follower


Asked: 2013-10-16 20:42:54 +0100

Seen: 283 times

Last updated: Oct 17 '13