How do I use VBA in excel to send an email via Outlook?
P PhilM Jun 7, 2006 #3 Bearacade said: What are you sending? A worksheet? A Workbook? Just a message? Click to expand... Hi would be either, pref would be to sent a workbook
Bearacade said: What are you sending? A worksheet? A Workbook? Just a message? Click to expand... Hi would be either, pref would be to sent a workbook
Z Zygan Jun 7, 2006 #4 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 sen this shall do it check out this website on this exceltip.com by ron de bruin absolute magic http://www.exceltip.com/se/2.htm
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 sen this shall do it check out this website on this exceltip.com by ron de bruin absolute magic http://www.exceltip.com/se/2.htm