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: claudio
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Mail-Merge
  Show dependency treegraph
 
Reported: 2023-12-04 14:11 UTC by claudio
Modified: 2025-03-20 15:57 UTC (History)
4 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
in reply to comment #6 (43.21 KB, application/pdf)
2024-12-30 16:13 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.
Comment 6 Dieter 2024-12-27 11:44:45 UTC
Sorry for the very late reply.

I've tested with
Version: 24.8.3.2 (X86_64) / LibreOffice Community
Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92
CPU threads: 12; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Vulkan; VCL: win
Locale: de-DE (de_DE); UI: en-GB
Calc: CL threaded

but I can't confirm the problem

My Steps:
1. Create a mail merge with mail merge wizard and database from attachment 195356 [details] Open file StampaSerieIndirizzi2.odt from attachment 195356 [details]
2. File -> Print
3. Answer "Yes" to the question "Do you want to print a form letter?"
4. In mail merge dialog select second and third data -> OK (I've selected "File" as output)

Actual and expected result
Document with two letters (if you select "Save as Single Document" or two documents Iif you select "Save as individual documents")
Comment 7 claudio 2024-12-30 16:13:39 UTC
Created attachment 198327 [details]
in reply to comment #6
Comment 8 claudio 2024-12-30 16:20:02 UTC
(In reply to Dieter from comment #6)
> Sorry for the very late reply.
> 
> I've tested with
> Version: 24.8.3.2 (X86_64) / LibreOffice Community
> Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92
> CPU threads: 12; OS: Windows 11 X86_64 (10.0 build 22631); UI render:
> Skia/Vulkan; VCL: win
> Locale: de-DE (de_DE); UI: en-GB
> Calc: CL threaded
> 
> but I can't confirm the problem
> 
> My Steps:
> 1. Create a mail merge with mail merge wizard and database from attachment
> 195356 [details] Open file StampaSerieIndirizzi2.odt from attachment 195356 [details]
> [details]
> 2. File -> Print
> 3. Answer "Yes" to the question "Do you want to print a form letter?"
> 4. In mail merge dialog select second and third data -> OK (I've selected
> "File" as output)
> 
> Actual and expected result
> Document with two letters (if you select "Save as Single Document" or two
> documents Iif you select "Save as individual documents")


ou can find the answer to your comment #6 in attachment 198327 [details] --- risposta.pdf
Comment 9 BogdanB 2024-12-30 17:49:47 UTC
For all testing this bug, please read bug https://bugs.documentfoundation.org/show_bug.cgi?id=164287. This seems like a duplicate of that bug.
Comment 10 claudio 2024-12-31 17:45:13 UTC
(In reply to BogdanB from comment #9)
> For all testing this bug, please read bug
> https://bugs.documentfoundation.org/show_bug.cgi?id=164287. This seems like
> a duplicate of that bug.

In response to comment #9
Sounds like the same problem to me too.
My first report of this issue, which then over time evolved for the worse, was with bug 151029 on 2022/09/17 which did not lead to any positive results, ...
I then repeated the same issue with bug 158517 on 2023/12/04. In conclusion if we are talking about duplicates read the dates of reporting, the message you sent me should be sent to the person who reported bug 164287 which seems to be a duplicate of my report.
Comment 11 alfero 2025-01-23 15:52:32 UTC Comment hidden (spam)
Comment 12 alfero 2025-01-23 15:54:04 UTC Comment hidden (spam)
Comment 13 Katene 2025-01-24 07:21:50 UTC Comment hidden (spam)
Comment 14 Martin Emma 2025-02-07 09:33:35 UTC Comment hidden (spam)
Comment 15 claudio 2025-03-20 15:57:10 UTC
The bug is also present with the new version:
Version: 25.2.0.3 (X86_64) / LibreOffice Community
Build ID: e1cf4a87eb02d755bce1a01209907ea5ddc8f069