How to open an item in WSS?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John Riddle - 25 Mar 2005 20:23 GMT

Hello,

I've created a linked server to Exchange from SQL Server 2000. Everything
works fine. I can query and retreive the data from the \\.\BackOfficeStorage
just fine. My questions are:

What fields do I have to retrieve in order to be able to open up an item?
That is, if I construct a query that retrieves only one row, how would I
then open up that item to view it as an email message? (assuming the content
class is "message") What methods would I use to open the item? How do I
retrieve the list of attachments?

Thanks,

John

Reply to this Message

Tom Rizzo [MSFT] - 28 Mar 2005 05:45 GMT

You can retrieve just the DAV:href and then use CDO to open the item using
the Message object. Hopefully you know that SQL and Exchange have to be on
the same machine for distributed queries to work, right? :)

Tom

Signature

Looking for a good book on programming Exchange, Outlook, ADSI and
SharePoint? Check out http://www.microsoft.com/MSPress/books/5517.asp

This posting is provided "AS IS" with no warranties, and confers no rights.

> Hello,
>
[quoted text clipped - 13 lines]
>
> John

Reply to this Message