Ask Your Question
0

How can I drag and drop field names from Data Sources for a mail merge form letter? [closed]

asked 2014-01-22 13:18:54 +0100

nickr8 gravatar image

updated 2015-09-05 01:13:41 +0100

Alex Kemp gravatar image

I'm wanting to do mail merge. So In the ODT Document I hit F4 to view the Data Sources. I then go to the correct sheet in my database. When I then try to drag the header of the column from the data source to the actual document nothing happens (the header should actually be displayed in brackets, so that the word can be replaced with the words in the column for mail merge...).

Any help/workaround would be greatly appreciated.

I'm using version: 4.1.4.2 Build ID: 0a0440ccc0227ad9829de5f46be37cfb6edcf72 on Mac OSX 10.9.1

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 2016-02-24 20:58:13.853917

Comments

I'm having the same problem. I can select individual data elements that turn into a small green circle with a '+' in the middle and drag them to the document but when I try to drag a field heading it gives me a small black square that immediately jumps back to the data source.

Any suggestions?

Using Version: 4.1.5.3 Build ID: 1c1366bba2ba2b554cd2ca4d87c06da81c05d24 Mac OXS 10.9.2

ntisjim gravatar imagentisjim ( 2014-04-07 12:10:17 +0100 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2014-04-07 12:49:51 +0100

ntisjim gravatar image

I think I answered my own question. Try this. Instead of selecting the field header (as described in the documentation LibreOffice 4.0 Writer Guide Page 310), select and drag any row of data to the document, I just used the first row. You will see a dialogue asking if you want to insert as 'Table' 'Fields' of 'Text', select 'Fields' and choose the field/s you want to insert. Once you get them into the right order and format, click 'ok'. The selected fields carry forward through each occurrence of the data for each merged document. It seems to be working.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-01-22 13:18:54 +0100

Seen: 574 times

Last updated: Jun 07 '14