Ask Your Question

How do I not get duplicate salutations in mail merge if I don't know the recipient's gender?

asked 2013-06-01 07:10:24 +0200

bkarlan gravatar image

updated 2014-07-05 00:37:55 +0200

bencomp gravatar image

This is bizarre problem that comes from trying to be too Politically Correct. You insist on creating a Salutation for Females and Males. I don't care what sex they are, I just want the first name to appear at the beginning of an email. I have no identifiers for their sex and it's over 500 contacts so I'm not going through it one by one just for your program.

Because of this problem, the First Name appears twice because it doesn't know the sex of the individual. Is there a fix for this? If not, the program is trash to me because it's primary function to me makes it unusable.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2015-02-13 01:29:23 +0200

trishf42 gravatar image

If you uncheck "insert personalised salutation" and go to "general salutation", you can edit the general salutation (I usually take whichever one is showing - say the "Hello" salutation and delete it and add what I want).

Then type in (for instance)

Dear <First Name>,

and the preview box below will show you what will go into the merge. To make sure you type the correct field name between <>, hit F4 to show your data above the document, and use the field name from the top of the address list.

Hope this helps!

edit flag offensive delete link more

answered 2014-07-05 00:35:40 +0200

bencomp gravatar image

If you don't want different salutations based on the recipient's sex, you should not enable the option. You can use the general salutation that includes a field for the first name.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2013-06-01 07:10:24 +0200

Seen: 366 times

Last updated: Feb 13 '15