Thread: Email from vba
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ADK ADK is offline
external usenet poster
 
Posts: 89
Default Email from vba

What if a user does not have Outlook?

If a user has Outlook Express, would it work?

I want to place the auto emailing code in with my error sub so I get an
email when a user getsan error in the office.

Clip from code:

Sub Mail_small_Text_Outlook()
' Is working in Office 2000-2007
Dim OutApp As Object
Dim OutMail As Object
Dim strbody As String

Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon
Set OutMail = OutApp.CreateItem(0)
--------------------------------------------------------------