Issue 107581 - Mail Merge: personal salutation field selection
Summary: Mail Merge: personal salutation field selection
Status: CLOSED DUPLICATE of issue 41413
Alias: None
Product: Writer
Classification: Application
Component: code (show other issues)
Version: OOO310m19
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: writerneedsconfirm
QA Contact: issues@sw
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-12-10 10:30 UTC by nfilus
Modified: 2013-08-07 14:44 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Template created with mail merge wizard (25.16 KB, application/vnd.oasis.opendocument.text)
2009-12-11 13:52 UTC, nfilus 		no flags Details
Addreslist used in the mail merge wizard (11.20 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-12-11 13:53 UTC, nfilus 		no flags Details
wizard_step4 (82.12 KB, image/png)
2009-12-11 13:54 UTC, nfilus 		no flags Details
field matching (54.51 KB, image/png)
2009-12-11 13:55 UTC, nfilus 		no flags Details
salutation placing (80.39 KB, image/png)
2009-12-11 13:55 UTC, nfilus 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description nfilus 2009-12-10 10:30:52 UTC 
In Mail Merge Wizard, step 4, insert personalized salutation the entry in "Field
name" for indicating a female recipient is not used. The value specified in
"Match fields" is ignored too. Instead a hardcoded language-specific field name
like "Gender" or "Geschlecht" (german) is used. If the address list doesn't
contain such a field, the male recipient salutation is used for all recipients.
The used field name can be checked in step 6, edit document. The condition for
hidden paragraph is defined like:
([adresslist.Sheet1.Gender] != "Frau" OR NOT [adresslist.Sheet1.Name]) OR
(![adresslist.Sheet1.Name])
Comment 1 Oliver Specht 2009-12-11 12:09:44 UTC 
I just checked it in a OOO310m19 and the column 'Booktitle' of the Bibliography
database and got conditions like this for the hidden paragraph fields:
([Bibliography.biblio.Booktitle] != "test" OR NOT [Bibliography.biblio.Type]) OR
(![Bibliography.biblio.Type])

Would you please explain what you are doing and maybe attach a sample document
and database?
Comment 2 h.ilter 2009-12-11 12:13:58 UTC 
btw. the merge will take effect at step 7
Comment 3 nfilus 2009-12-11 13:52:19 UTC 
Created attachment 66607 [details]
Template created with mail merge wizard
Comment 4 nfilus 2009-12-11 13:53:22 UTC 
Created attachment 66608 [details]
Addreslist used in the mail merge wizard
Comment 5 nfilus 2009-12-11 13:54:19 UTC 
Created attachment 66609 [details]
wizard_step4
Comment 6 nfilus 2009-12-11 13:55:06 UTC 
Created attachment 66610 [details]
field matching
Comment 7 nfilus 2009-12-11 13:55:46 UTC 
Created attachment 66611 [details]
salutation placing
Comment 8 nfilus 2009-12-11 13:59:31 UTC 
I attached the sample documents and screenshots. I retried the steps on
linux/ubuntu with OO.org 3.1.1 (m19) and with 3.1 on Windows.
Comment 9 h.ilter 2010-01-12 09:05:28 UTC 
This issue is double to 41413 and fixed in OOo3.2.

*** This issue has been marked as a duplicate of 41413 ***
Comment 10 h.ilter 2010-01-12 09:06:09 UTC 
Closed.