|
| 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
November 29th 07, 03:29 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
recipients from a MAPITABLE
Hello,
I want to collect the recipients from a mail message. We use this SQL query in MAPITable.ExecSQL "SELECT Recipients,Body,SenderEmailType,SenderEmailAddress FROM Folder" If this QUERY is correct, how can I get the items from Recipients? I use the latest Outlook Redemption v. 4.4 and PowerBuilder 11.1 - BEGIN POWERBUILDER CODE - loo_ADOrecordset = io_folder.Items.MAPITable.ExecSQL('SELECT Recipients,Body,SenderEmailType,SenderEmailAddress FROM Folder') DO WHILE (loo_ADOrecordset.EOF = FALSE) // How can I read this out? st_recipients = loo_ADOrecordset.Fields.Item("Recipients").Value // Working correct! st_sendermail = loo_ADOrecordset.Fields.Item("SenderEmailAddress") .Value loo_ADOrecordset.MoveNext() LOOP - END POWERBUILDER CODE - King regards, Stèphan Eizinga 
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Redemption MAPITable Question | Patrick Pirtle | Outlook and VBA | 8 | November 20th 07 05:45 AM |
| SQL filters with MAPITABLE | DENNIS BROWN | Outlook and VBA | 1 | July 21st 07 10:50 PM |
| How do I get a propertyvalue from a mapitable | [email protected] | Outlook and VBA | 1 | October 4th 06 07:51 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 |
Threaded Mode