Bug 158517 - Mail merge does not produce the required documents
Summary: Mail merge does not produce the required documents
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
7.6.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Mail-Merge
  Show dependency treegraph
 
Reported: 2023-12-04 14:11 UTC by claudio
Modified: 2024-09-30 06:58 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
the three files mentioned in the description (33.06 KB, application/x-zip-compressed)
2023-12-04 14:26 UTC, claudio
Details
file zip (33.06 KB, application/x-zip-compressed)
2024-07-17 13:52 UTC, claudio
Details

Note You need to log in before you can comment on or make changes to this bug.
Description claudio 2023-12-04 14:11:53 UTC
Description:
Goal: To create documents to link to a general database of addresses of people and companies, through Mail Merge Wizard... produce individual documents for the names of interest found in the general address database.


    1) I created a spreadsheet (addresses.ods) in which I entered the addresses of three people.
    2) I created a database (addresses1.odb) by importing the data from the spreadsheet.
    3) In write I created a document (printerseriesaddresses2.odt) in which I enter the address I take from the database and through mail merge (Tools → Mail Merge Wizard...) 
    4) I create separate documents with the Save Merge Documents command, for the three people in the database.
The procedure so far, (steps 1 through 4), works correctly, at the end I get the three documents.
Steps 1 through 3 give no problems.
Things don't work correctly in step 4 if I start selecting the documents I want to create, i.e., I exclude one or two addresses with the Exclude recipient checkbox, and execute the command with the Save merged documents button, the procedure does not return me the only requested documents.
I assume that this malfunction also affects the Edit individual Documents, Print Merged Documents, Send Email Messagges commands.

Steps to Reproduce:
1.in description
2.
3.

Actual Results:
in description

Expected Results:
in description


Reproducible: Always


User Profile Reset: No

Additional Info:
in description
Comment 1 claudio 2023-12-04 14:26:14 UTC
Created attachment 191228 [details]
the three files mentioned in the description

To quickly get to the bottom of the problem
Comment 2 Dieter 2024-07-14 14:07:17 UTC
Claudio, it seems, that nobody could confirm your bug report for more than six month. Could you please retest with actual version LO 24.2.5 and give feedback?
Thank you.

=> NEEDINFO
Comment 3 claudio 2024-07-17 13:52:40 UTC
Created attachment 195356 [details]
file zip
Comment 4 claudio 2024-07-17 13:56:26 UTC
(In reply to Dieter from comment #2)
> Claudio, it seems, that nobody could confirm your bug report for more than
> six month. Could you please retest with actual version LO 24.2.5 and give
> feedback?
> Thank you.
> 
> => NEEDINFO
Data: 2024/07/17
Version: 24-02-05
Write
Funzione: Mail Merge wizard
Same conditions as previous report:
	- calc table imported from Base to create a database of names with addresses
	- write sheet with the database linked.
I use the database to automate the production of documents when needed,
same text and variable part linked to the database.
I used the same system some ten years ago with word-excell.
The documents to be produced almost never concern all the names in the database, in fact I usually only produce one document at a time.

In this particular case, used specifically to test the ‘Mail Merge wizard’ function, the database contains 3 names.
I select the ‘Exclude recipient’ check box for the first two names in order to exclude them and print only the third.
I press ‘save merged documents’ I complete the window with what is required and get a document, 
I check its contents and inside instead of finding only the third call sign I find all three, and this is wrong.
The function, except in a few cases, always fails to produce only the requested documents.

The files I used I already attached last time, in 3 minutes you can check for yourself if what I say is true.
If I can, I will attach the three files to this message.
I hope I have been clear and helpful, however practice refines grammar, 
before asking for further clarification, please execute the procedure I have described,
try other cases and draw the consequences.
Cordially Claudio
Comment 5 claudio 2024-09-30 06:58:36 UTC
Even with version 24.8.1.2, the bug manifests itself.
It is impossible to perform a check on the documents that are created; the only solution is to create them all and then delete the unwanted files or sheets by hand.