Macro to send email without outlook

[puuts]

Is it possible to send an email thru excel macro without outlook?

I just want to create a Vacation Leave tracker, and when the user hit the submit button, it will send a notification from the approver.

[judgeh59]

you have fill in a few blanks for this to work....you can also pass in parameters to make it more dynamic....HTH

Please Login or Register  to view this content.

[puuts]

Hi judgeh! thanks for reply, what is the exchange server address for yahoo? i'm just want to try the code that you've provided but i don't know the exchange server address of yahoo.

[judgeh59]

I don't know....I have never tried using this through yahoo....you would need a valid yahoo username and the SMTP server address...it's possible that yahoo block this also....I use this working through my work exchange server....you don't need outlook, but need exchange....or a valid email server....I just don't know....sorry

[puuts]

ah i see, i will try it in my office later. by the way it gives me an error "Object doesn't support this property or method", it highlighted in

Please Login or Register  to view this content.

[judgeh59]

that's because it should objmessage.TextBody = "Sample" - thanks for catching that...

[puuts]

Now it seems working. I've got an error "The transport failed to connect to server" maybe because my smtp server is wrong. Thanks Judgeh!. BTW do you have any idea for a Vacation Leave Tracker?

[judgeh59]

sweeeeet....yes, I believe that is the error you get with the wrong connection....if you are familiar with telnet you can use telnet to verify username/password and server address...

[puuts]

I'm not familiar with telnet. Thanks judgeh!

[judgeh59]

you can do a search for "using telnet to test SMTP connection" and it should give you a few options....you do need to be connected and authenticated to you network....