Ask Your Question
2

How to change datasource in form letter / mail merge imported from MS-Word [closed]

asked 2012-02-18 19:29:35 +0200

rverrips gravatar image

updated 2013-02-03 10:27:23 +0200

qubit gravatar image

Hi

I have a form letter, i.e. a document previously written in MS-Word which contacts data pulled from a MYSQL database via Microsoft-ODBC query. When I open the document (saved as odt) in LibreOffice the form fields correctly show as field, but they're still all pointing to the Microsoft-ODBC Query.

Within MS-Word the ability exisits to select a new datasource, which then updates all form fields to the new one - I tried selecting the datasource in LibreOffice but it doesn't update the exiting fields.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-05 04:42:19.451913

1 Answer

Sort by » oldest newest most voted
2

answered 2012-02-18 19:43:30 +0200

cloph gravatar image

If Edit|Exchange Database doesn't work, then try to edit the fields directly, (i.e. put the cursor in front of a field and choose Edit|Fields… or use "Fields…" from the context-menu when right-clicking a field), you can change the database association.

But the point of the Exchange Database function is exactly your usecase and described as such in help http://help.libreoffice.org/Writer/Exchange_Database

For example, if you inserting address fields in a form letter from an address database, you can then exchange the database with another address database to insert different addresses.

so it would be worth to file a bug if you can reproduce with a new document.

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-02-18 19:29:35 +0200

Seen: 6,741 times

Last updated: Feb 18 '12