Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"User-defined type not defined" error when trying to send e-mail
Dear all,
I want to send e-mail via a list in a excel document so i try to write a macro. In my macro, for outlook i use the code; Dim OutApp As New Outlook.Application Dim OutMail As Outlook.MailItem Set myOlApp = New Outlook.Application Set myItem = myOlApp.CreateItem(olMailItem) But i got an error " user-defined type not defined" I selected the Visual basic for applications Microsoft Excel 11.0 Object library OLE Automation Microsoft Office 11.0 Object Library Microsoft DAO 3.6 Object Library. So i wonder where the problem is and need your help in this situation... Kind regards, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Message "user defined type not defined" | Excel Discussion (Misc queries) | |||
User-defined data type; Error: Only User-defined types... | Excel Programming | |||
"User-defined type not defined" vb msg | Excel Programming | |||
"Application-defined or object-defined error" while printing excel report | Excel Programming | |||
Why "User-defined type not defined" | Excel Programming |