I have been able to almost create a mail merge using the query,
Readeraddresses, from the registered database, Media. (The actual
database is Media_without_Macros.).
On the Create a Salutation, I use the field, Salutation, to indicate
which person is a female. Since this field contains Mr. for men and Mrs.
for women, I have placed Mrs. as the Field value. When I click at the
bottom of the Preview window to change documents, I get Dear Mr. for the
men and Dear Mrs. for the women. After adjusting the place where the
salutation should be on with relationship to the Address Block of the
letter, I click Finish.
The salutation that appears in the letter is the following three lines
for the first person who is a male:
Dear Mrs. Lederstrumpf,
Dear Mr. Lederstrumpf,
As I use the Data to Field button to go from one person to the next one,
the Address Block is correct, but the salutation obviously is not. Why
isn't the top two lines exactly the same as the Preview that I had seen
in the Mail Merge Wizard? How do I get it to show what I need:
Dear <salutation> <LastName>, where salutation is either Mr. or Mrs.
depending upon value in the Salutation field?
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
- [libreoffice-documentation] More problems with Mail Merge · Dan Lewis
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy