Ask Your Question

mailmerge salutations

asked 2020-12-15 22:26:01 +0100

Pansmanser gravatar image

updated 2020-12-15 22:27:45 +0100

LO mailmerge in writer says it has a way of creating conditional salutation. Can anything useful be done with this feature? It appears to allow different greetings for male or female recipients based on criteria from the database. However the field list suggested is not the field list of the database concerned, but an totally unconnected list of fields. Am I being stupid (quite possible) or is this a serious bug - an incomplete feature released prematurely by the look of it? (the third tag was meant to say 'salutation', but it does not seem possible to correct it.)

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-12-16 04:37:50 +0100

Ratslinger gravatar image

updated 2020-12-16 19:46:42 +0100


Have no problem with male/female choice of DB fields:

image description

Now the custom salutations:

image description

also work if the fields were associated (Match fields). For this it is best to refer to the LO documentation here -> LibreOffice Writer Guide. Look at Chapter 14 - Mail Merge. There is a section on the address block, matching fields and creating the salutation. This will give you a better idea of what is going on.

Edit 2020-12-16:

I hope this will help. It, in my opinion, is not the easiest to work with.

First on the Create Salutation page, I selected a field name (used ID) and left value blank. Now all records will use Male personalized salutation. I then assigned the fields using `Match Fields' button to get to dialog.

Now I select New button for Male salutation. First element used was <text> and in Customize salutation entered Dear:

image description

Next element inserted was for <last name="">:

image description

Now selecting OK gets back to:

image description

and I can scroll through the salutations. They would all be the same as the value for Female will never exist.

Hope that helps.

edit flag offensive delete link more


Thank you for your answer, Ratslinger. I think I am getting nearer to understanding this. I had not grasped 'Match fields'. So I 'Create Salutation', leave the gender boxes blank and select a 'New' male salutation. Now I select 'Salutation' with Custom Salutation 'Dear', and 'Forename' and click OK. The Preview panel displays 'Dear Forename'. I go to 'Match fields', and match 'Forename' to my field 'greeting'. However the preview panel is unchanged, and 'Next' is greyed out. Where am I going wrong?

Pansmanser gravatar imagePansmanser ( 2020-12-16 12:19:08 +0100 )edit


Please see edited answer.

Ratslinger gravatar imageRatslinger ( 2020-12-16 20:00:16 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-12-15 22:26:01 +0100

Seen: 32 times

Last updated: Dec 16 '20