Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Several years ago, on a different PC and under a different set of IS
policies, I used the following code as part of a larger process to generate automated emails from Excel and put images of an Excel range in each email (customized by recipient). I'm trying to adapt that code to do the same type of thing on a new project, but with a totally different PC, and I'm having trouble getting it to run. The current setup is Outlook 2003 on XP, which is the same as the other setup where this code did work. The error message I'm getting (see highlighted line below) is "compile error: user defined type not defined" which suggests that there is no valid reference registered. I'd appreciate any suggestions- I'm stuck! Thank you, Keith The checked references include: Visual Basic for Applications Microsoft Excel 11.0 Object Library OLE Automation Microsoft Office 11.0 Object Library Microsoft Outlook 11.0 Object Library Microsoft CDO for Windows 2000 library (which is strange, since I'm using XP?) The top part of my code: Function EmbeddedHTMLGraphicDemo(SendToName As String, SendFileCount As Integer) ' Outlook objects Dim objApp As Outlook.Application Dim l_Msg As MailItem Dim colAttach As Outlook.Attachments Dim l_Attach As Outlook.Attachment Dim oSession As MAPI.Session '<-- debug highlights here ' CDO objects Dim oMsg As MAPI.Message Dim oAttachs As MAPI.Attachments Dim oAttach As MAPI.Attachment Dim colFields As MAPI.Fields Dim oField As MAPI.Field 'etc |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Call Outlook Contacts from Excel Userform | Excel Programming | |||
Call Excel Macro from Outlook | Excel Programming | |||
Tools...References shows "MISSING:" in front of 2 references | Excel Programming | |||
References.Remove References(1) DOES NOT WORK for "MISSING:" Refs | Excel Programming | |||
Missing References between Excel Versions | Excel Programming |