Dynamically determining .From address when using CDO
 

I am using CDO to email (from Outlook) worksheets to a list of emai
addresses. I would like to dynamically determine what the submitter'
default email address is. Is there a way to do this?

I know that it is optional when using some of the other email tool
like SendMail but I chose CDO because I can suppress the securit
warnings.

Any help would be appreciated.

Thanks,
-Bruc

--
Message posted from http://www.ExcelForum.com