Extract from MS Exchange

[livezone]

Hi,

Is there a way to extract exchange data using SQL Server?

I have designed an outlook form in Organizatinal library. I want to get the list of all emails using this form with date sent.

Thanks
Shafiq

 

[mrdenny]

You can use xp_readmail to read emails from an exchange mailbox. Is that what you are trying to do?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[livezone]

Is there a way to query using select statement as you do with other linked servers?

Thanks
Shafiq

 

[mrdenny]

What info are you trying to query? The address list or the emails?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[livezone]

In our company exchange server I have created an email type form in our Organizational library. This form contains serveral predefined text box and check boxes. I need to get the count of emails generated for that form and also the create date.

I know the Message Class which is IPM.Note.ServiceTicket.

You can check your own organization form in outlook using

New --> Choose Form
Then a dialog box will display all user defined forms.
Thanks
Shafiq

 

[mrdenny]

You'll need to read the messages with the xp_readmail procedure and log them into a table then do counts from the table.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[livezone]

Hi

xp_readmail reads a mail message from the Microsoft® SQL Server™ mail inbox.

But I want to read from a Public folder in Excahnge

Thanks
Shafiq

 

[chrissie1]

you could make it into a linkedserver using the oledb for exchange provider wich is on the exchange cd.

Christiaan Baes
Belgium

I just like this --> [Wiggle] [Wiggle]