Gender Variants

Aloha all,

I have searched for this and have not had much success. I am looking for a way to perform a mail merge or even better a database that has a document with several variants of gender. One excwl column has Male/Female but in the text of the document it has a spots that says HE and another that says HIS and HIM. Same for female gender variables HERS, HER, SHE.

So I need whatever will work to see what the column shows as the gender and then further down the document use the correct verbiage.

I assume I could use a function in excel to see if column x was male and then enter HIS in column y and HE in z and so forth thru all the genders, but that method has too many possible holes.

This is wide open to how ever it is easiest. I am not a huge fan of mailmerge, I just know it can do the task I am asking for. In the end I will probably build a DB linked to a monthly query which outputs to excel. That way I can do a lookup and populate all fields on the report with minimal user input. Since the document has so many gender variables I want to reduce the possibilities of typos and avoid having a document with 3 male genders with a female SHE thrown in on accident because it was missed.

Thank for all your possible ideas, I am only semi literate in MS products so I might need some handholding but hopefully not too much.

No one has any help? Did I put this in the wrong area?