How do I use VBA in excel to send an email via Outlook?

What are you sending? A worksheet? A Workbook? Just a message?


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=549012

Bearacade wrote:
What are you sending? A worksheet? A Workbook? Just a message?


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=549012

Hi would be either, pref would be to sent a workbook

you need to reference in vba script before you use this macro

Sub Mail_workbook()
ActiveWorkbook.SendMail ", _
"This is the Subject line"
End Sub

i have seen far more indepth ones but if it is a quick workbook send
this shall do it

check out this website on this exceltip.com
by ron de bruin
absolute magic


http://www.exceltip.com/se/2.html


--
Zygan
------------------------------------------------------------------------
Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
View this thread: http://www.excelforum.com/showthread...hreadid=549012