help getting code from ron de bruins site

[funkymonkUK]

Hi

I am looking for excel VBA code to send email with the activeworkbook
attached and subject line & message. I have searched this site and all
the solutions which all point to Rons website however due to our IT
security have blocked his website and I cannot view his code for this
problem I have.

If somebody could check on his site and then paste it on here for me I
would be most grateful.

Many Thanks

Funkymonk
(THE FUNKIEST VBA CODER ON THE FORUM)

 

[Bob Phillips]

This is all you need to send it

Sub Mail_workbook_1()
ActiveWorkbook.SendMail "(e-mail address removed)", _
"This is the Subject line"
End Sub

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"funkymonkUK" <[email protected]>
wrote in message
news:[email protected]...

 

[Ron de Bruin]

Hi

security have blocked his website

No adds and almost only text, Why???

See this on MSDN from me
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_xl2003_ta/html/odc_xlmail.asp