see my other reply.....

--
Cheers
Nigel



wrote in message
oups.com...
Ok..some developments...

I just got Ron's method to work. It work the way I wanted it...Thanks
Ron.

I don't know what exactly fixed the problem..these things were done...

1. Gave Excel permission to send mail in ZoneAlarm
2. Changed the From Email address from to my actual
Email address (of my SMTP server).
3. In Outlook Express, ToolsAccountsMailPropertiesServersOutgoing
Mail Server, unchecked 'My server require Authentication'.

Now luckily I have two SMTP servers, one requiring authentication and
one that do not. How do I give a password authentication through VBA if
I were to use the SMPT server which need authentication...

Shall appreciate if someone can also help why first method is
failing...

Thanks in advance