Cannot be done within Excel.
Read the replies you have to your previous posts.
Or can you not find those replies? I do not use the CDO Interface as you do so
cannot advise on how to find them.
You could google on your name to find posts.
http://tinyurl.com/5wqkl8
Gord Dibben MS Excel MVP