« More Brilliant People Saying that Office 2007 Is A Whole Different Program, So Why Not Just Use OpenOffice.org? | Main | Getting Started With Firefox »

January 23, 2007


thanks a lot... i was really searched all the web about mail merge including openoffice.org... your tutorial only helped to understand about mail merge... i really want to thank you once again...

Thanks a lot, it was very helpful.

I actually have a related question: what does it happen if I change the data source (aka the DabaBase)? I would expect the change reflected in the database embedded in the text file. That happens NOT to be the case in my Oo2.3!

Conversely, if I changed the database embedded in the text document, the change would NOT be reflected in the original DB. Strange, isn't it?

It is as if the original DB and the embedded one were a two different things!



Thanks, Solveig, for the clear and very useful instructions on mail-merge.


Thank you for this tute. I'd been trying to figure this out for days, having spent weeks building my source spreadsheet. Now have my mail merge behaving.



Hi Philip,
Glad it helped -- mail merge works reliably but the simplest way is not obvious. ;>


is there any way to do what micro$oft word does with a catalog merge where it merges all data to a single file without page breaks?

essentially I would like to merge a database into a file with similar wording in between each entry, but I do not want each entry in a separate file or separate page.


Name of product: "MERGE FIELD ONE"
--->Line Break<----

Then when I merge, it repeats this process for whole database in a single document with just the single line break between each entry.

Output would look like this:

Name of product: Computer 1
price: $200
Size: 5 GB

Name of product: Computer 2
price: $400
Size: 10 GB

Name of product: Computer 3
price: $600
Size: 20 GB


Hi rudy,


I used your instructions to create my first BASE dB and it went without a hitch. But when I tried to create a second new database I am not able to get the headings to import as field names. The only thing that shows in the wizard is the A B C column titles. The first row instead of importing as titles import as data in the first record. Also the first time I remember a comment in the instructions about cutting and pasting or drag/drop the spreadsheet to the "table" field in BASE and it would set up the table which it did. I just cannot find that set of instructions. Can you provide the link.

I wonder why OpenOffice doesn't allow merging from the text or especially the spreadsheet files directly. What's the rationale behind first having to convert these files to "data sources"? I notice the Mail Merge Wizard automatically converts and registers spreadsheet files as data sources. This doesn't seem to be the case in View -> Data Sources. There seems to be no way simply to drag the spreadsheet file into the explorer window or anything like that, or just to use the spreadsheet file "as is" for a merge without converting it. It must be converted to a "data source" manually first for some reason. I wonder why this is necessary. Doesn't it mean that any future changes to the spreadsheet file will require converting the spreadsheet again and registering the data source anew? Or is the new data source "linked" to the spreadsheet file?

Hi Charlotte,

You get a lot of power from creating the data source, plus it's quick and you only need to create it once. Once you've got the .odb database file, then if you want to create a new document that's merged with the text file or spreadsheet, then bam, just view data sources, drag in your fields, and you're good.


I followed the steps above, with no problem.

However, when I click on the table I get this error message.
"The connection to the data source ____ could not be established. The file _____ could not be loaded.

Any help.


Either the database you're pointing to is deleted, or if the database is based on a spreadsheet, you might be in, or have open, the spreadsheet it's based on.

As a control, do the same type of thing just on a plain spreadsheet and it should work.


The spreadsheet is a Lotus 1-2-3-file, with a .123 extension. I tried different Lotus files, .123 extension and WK1 extensions, still no luck. Is there a known problem with OpenOffice not converting Lotus spreadsheets into databases?

If I open the Lotus file in Calc, save the spreadsheet as ods, then the operation works. That's a run around though.

Thank You for these useful instructions!

I wanted to prepare something else than mass-mail - a series of sheets for checking attendance at classes /* I'm sorry for my English */. There were a number of groups, all having classes on different days in different rooms. I worked hard to put this data into a OOo database (which I want to write about in a minute), and tried to produce such sheets, with changing times, dates, lesson topics and group names. However - the tools for "mass-mailing" (I have a localized version of OOo, so my command translations are a clumsy round-trip from Polish) wanted a fixed, unflexible "address block" and my database query "did not fit" as data source - it had no "title" "name" "surname" etc., just date, hour, group_name etc. Also, trying to generate a report from the OOo Base did not produce the result I wanted.

This "data source view" in a simple text document just helped me out! Still, the key to success was the keyword "print" - that's when the document is generated - I might have to print it somewhere else, where my datasource would be completely unavailable.

So, Ms. Haugland, I think You're doing great work, showing all these simple tricks! For some time now, when having trouble with OOo, I have googled for some keywords (like "change impress slide background"), and looked for results from Your blog, as these were most likely to point in the right direction.

Now - for the database part (it is less connected to this article, so I'll keep it short): is it possible to create forms with comboboxes which return data from other tables as keys, but display nice captions made up of other fields (or at least one field). I got it working with 1 column tables, without a primary key:
table rooms: room(varchar)
in my table "classes" there is a field "room" also of type varchar.
A typical database-like situation would be, when there were two columns:
table rooms: id(int, autoinc), room(varchar)
and a reference field in "classes" "room_id"

Now I want a form for classes, which has a combobox "Room", which displays rooms' names, but stores room ids in the classes table. I haven't got this working like this, though: I had to redesign my tables. Perhaps I have missed something.

With regards,

http://www.batterygoshop.co.uk/batterycharger/fujitsu/fujitu-19v-3.16a-60w.htm New OEM Fujitsu Lifebook T-4020 T4020D T4020 AC 3.16A ,

Just a remark: You need to have OO Base installed. I didn't have it and didn't have Database in Create new menu.

I have the same question posed by Rudy (April 12, 2008 at 02:09 PM), namely that my mail merge prints one page per data line but I want to have three on a page to save paper. Note that I don't mean three copies of the same person's data per page, but the next three people in the data source on one page. Following the link to http://openoffice.blogs.com/openoffice/2007/05/wayyyyy_simpler.html as suggested did not seem to address that issue, or if it did I am unable to find the information. Am I just blind? By the way, I'm using 3.0.1 now if that makes a difference.

Never mind, I solved the multiple-items-per-page thing by setting them up as custom-sized labels rather than as a mail merge. It works great!

Nice way of explaing difficult things.

You get a lot of power from creating the data source, plus it's quick and you only need to create it once. Once you've got the .odb database file, then if you want to create a new document that's merged with the text file or spreadsheet, then bam, just view data sources, drag in your fields, and you're good.


It's simpler to keep using M$Word, sadly. Bye bye OO.

Nice way to perform the mail merge operation. I have been trying to do this using my custom desktop blogging engine but got more options here in open Office and process, too, was rather simpler.

thanks a lot. It is very nice description about Mailmerge.

vijayan calicut

The comments to this entry are closed.

GetOpenOffice Consulting

Get Book Resources

Search This Blog