![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
Well, this seems like it should be simple. So, I assume I'm
overlooking something small. Here's my code: Public Sub TestMapiTable() Dim oRecordset As Object Dim oTable As Object Set oTable = CreateObject("Redemption.MAPITable") oTable.item = Outlook.Session.GetDefaultFolder(olFolderContacts) .Items Set oRecordset = oTable.ExecSQL("SELECT * from Folder") While Not oRecordset.EOF Debug.Print (oRecordset.Fields("Email1DisplayName").Value) oRecordset.MoveNext Wend End Sub The line beginning "Set oRecordset = oTable.ExecSQL" gives me an error "Object doesn't support this property or method." TIA for any help as to what I'm missing. ____________________________________________ The impossible just takes a little longer... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Redemption - general question | WhytheQ | Outlook and VBA | 3 | October 31st 07 02:05 PM |
Redemption Question - showaddressbook and saveas | [email protected] | Outlook and VBA | 5 | July 7th 07 11:30 PM |
Redemption MAPITable - how to deal with empty fields | SummerSky | Outlook and VBA | 2 | December 20th 06 05:27 PM |
Redemption - MapiTable : BusyStatus | Tadwick | Outlook and VBA | 4 | August 10th 06 07:36 PM |
Redemption MAPITable | Dmitry Streblechenko | Add-ins for Outlook | 1 | January 12th 06 05:09 AM |