Hi!

You can't do it for various reasons.

Some first names are not gender-specific (e.g. Evelyn).

Some names are not organised as first/last name as you expect. (e.g.
Chinese).

Some names will be of recent origin and not in any pre-existing
database. (After all, every name was new at some point in its history:
and you should see some of the neologisms I have seen...)

Best collect the salutation from the target: that way you stand a good
chance of getting it right.

Alf


--
AlfD
------------------------------------------------------------------------
AlfD's Profile: http://www.excelforum.com/member.php...fo&userid=4785
View this thread: http://www.excelforum.com/showthread...hreadid=474155