Recipients is a collection, not a property. You need to get the actual
message and retrieve and iterate the Recipients collection for what you
want. Get the EntryID of the item in question and use that to get the email
object and then retrieve and iterate the Recipients collection.

The same would apply to any other collection such as Attachments.

If you just want whatever is in the To, Cc and Bcc fields you can use those
string properties but those may not be what you want. They could return
display names or email addresses or a mix of both for any one recipient and
for a received email the Bcc field will always be blank of course.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"Stèphan Eizinga" wrote in message
...
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