https://bugs.documentfoundation.org/show_bug.cgi?id=120850
Bug ID: 120850
Summary: Mail Merge does not work properly on Ubuntu 18.04.1
with LO 6.0.6.2
Product: LibreOffice
Version: unspecified
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Writer
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: csc...@gmail.com
When creating Mail Merge data via query from a registered Base database, Mail
Merge Wizard does not merge the result set into the document.
To create this situation, one must define a query on a Base database where the
database is registered in the Libreoffice environment. Assuming that query
exists, the following steps will demonstrate that Mail Merge does not populate
a Writer document.
1. Open a template file (ott) or a new Writer document;
2. If the file is a template, skip to Step 4;
3. If a new document, create any constant information on the document. For
example, if you are merging names into a document that has name tag labels, you
may want some constant data to appear such as a logo or organization name on
all name tags;
4. Go to Insert>Field>More Fields>'Mail merge fields' and in the right window,
choose your query name and expand it. You will see the Field names assigned to
the output of the query. Insert the first field that is to appear on the name
tag;
5. Repeat Step 4 for as many fields as are to appear on the name tag;
6. Go to View>Toolbars> and click on Mail Merge to activate the Mail Merge
toolbar;
7. On the Mail Merge toolbar, click on the icon that is titled 'Data Source of
Current Document'. Two windows will open immediately below the Mail Merge
toolbar;
8. In the left hand window, click on the query name that you want to populate
the document;
9. The right window will now contain the query results. Click on the upper
left box beside the field names row to select all rows;
10. At this point, one can go through the Mail Merge Wizard, but it does
nothing. In fact you can go to Insert Address Block in the Mail Merge Wizard
and choose the database to which the query belongs which doesn't change the
outcome;
11. On the Mail Merge toolbar, click Saved Merged Documents. You will see a
counter that corresponds to the rows you have in your query result;
12. Another document will appear containing your original constant information
and merge fields, but nothing has been merged.
The process described above should work, but does not.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs