Sending email without using outlook

[waspandbee]

Hello,

I have 2 worksheets.
The first worksheet is called MailInfo. This worksheet only contains the email addresses of 3 users.
The second worksheet, is called Password, containing the passwords of all 3 users.
These 2 worksheets have something in common, the Column A has unique values which are the users' names; user 1, user 2, user 3.

I need help to send an email to hotmail addresses without using outlook.

NOTE: Assuming that the password worksheet is a private one.
For example if user 1 wants to know his password, he clicks on a button and an email will be sent, containing his details from the second worksheet (Password).

I have attached a copy of the excel workbook. Please help.

[Blade Hunter]

You can use CDO to send mail from the SMTP server as opposed to using outlook:

http://www.rondebruin.nl/cdo.htm

Hope that helps you.

Dan