Openoffice mail merge

English Applications
1

I have a question and I don’t know if it belongs here in this section or even on this site.

I have a number of Word files, containing names and addresses of clients.I have been entering them into the database on my laptop (Win XP) so that when I print out large number of letters I can use them in the mail merge section to automatically print the names, addresses and telephone numbers on the letters and the usual names and addresses on the envelopes or labels.

The database I have entered this data into is a MS Access database. I can access using MS Access, and of course, MS Word.

My question is this. Is there any way I can get the contents of this database, names, addresses, email addresses, etc, and use them in Openoffice? I have Openoffice installed on my laptop and on my Suse 10.3 PC.

Thanks for your help and suggestions.

2

The simple answer is no unless you are using SQL Server for your Access tables which OO can be set up to access. If you are using the basic Access tables, then exporting them as CSV or Excel spreadsheets and importing them into OO Base is the quickest route.

3

It can certainly be done. You just need to export your address info into something Openoffice can read such as an .xls or .csv file like the above post stated. The Openoffice.org forums have good discussions on this type of situation and may have some walkthroughs if you get stuck.