Hi
This won't run if you do not have Outlook. I was working on the
assumption that you had Microsoft Office. If you don't have Excel,
then this code is no good to you at all, and you should be asking your
question in a Lotus notes newsgroup.
Do you have Excel? If you do, get back to me and we can go through
what to do with this code and try and get round the Outlook Express
issue. If you do not have Excel, then I can't help.

regards
Paul

sae wrote in message ...
I do not have outlook installed, only outlook express and lotus notes.
Is this macro supposed to run automatically on opening the
spreadsheet?

YOu made this comment "-You can call this sub from your WorkBook_Open
event in the
ThisWorkBook module-" so I am wondering if I have to do something to
the code you provided in order to make it run automatically.

Thanks for your help, it is much appreciated.