Outlook

[PhilM]

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

[Bearacade]

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

[PhilM]

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

[Zygan]

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

Sub Mail_workbook()
ActiveWorkbook.SendMail "[email protected]", _
"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