does anyone know the code for copying cell entries to outlook contacts
list i.e

set ws = sheets("Personal Details")
contact name = range("E1")
Mobile phone number = range("C10")
and
email address = range("C11")

upon deactivation of worksheet send all these details to ms outlook
coincidable ranges

thanks in advance


--
short_n_curly
------------------------------------------------------------------------
short_n_curly's Profile: http://www.excelforum.com/member.php...o&userid=21576
View this thread: http://www.excelforum.com/showthread...hreadid=384090