Coupling Outlook to SQL Server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Kevin Terry » Coupling Outlook to SQL Server

19 posts, Page 1 of 2

1 2 »»

Coupling Outlook to SQL Server

Rate Topic

Display Mode

Topic Options

Author

Message

Kevin Terry

Posted Thursday, January 20, 2005 12:40 PM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:48 PM
Points: 258, Visits: 200

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/kterry/couplingoutlooktosqlserver.asp

Post #156795

Dinesh Asanka

Posted Monday, January 31, 2005 11:31 PM

SSC Eights!

Group: General Forum Members
Last Login: Friday, February 22, 2013 9:30 PM
Points: 912, Visits: 198

seems to be a good article
but
is this query correct

CREATE TABLE [tblCpls] (
[cplNum] [int] NULL ,
[cplName] [varchar] (4000) NULL ,
[cplDesc] [varchar] (1000) NULL,
CONSTRAINT [PK_tblList] PRIMARY KEY CLUSTERED
(
[cplnum]
) ON [PRIMARY]
)
) ON [PRIMARY]
GO

how can u create a Clustered index on nullable column ??

My Blog: http://dineshasanka.spaces.live.com/

Post #158689

Dinesh Asanka

Posted Tuesday, February 01, 2005 12:41 AM

SSC Eights!

Group: General Forum Members
Last Login: Friday, February 22, 2013 9:30 PM
Points: 912, Visits: 198

Post #158700

Jamie Thomson

Posted Tuesday, February 01, 2005 2:11 AM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 1:03 AM
Points: 877, Visits: 185

Great article Terry, I enjoyed reading it.

I'm interested in the following:

"I did come across a driver that could be used to directly access exchange as a linked server (I hoped)"

What driver was this?

Why did it not work?

Why is it limited to having Exchange and SQL Server on the same physical machine?

Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson

Post #158708

Logicom (New York)

Posted Tuesday, February 01, 2005 2:36 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, August 13, 2007 8:36 PM
Points: 10, Visits: 1

That's the "Exchange OLE-DB driver"; It has that and a number of other limitations. The example code Microsoft published in an MSDN article for using the driver has some glaring ommissions (e.g., the code snippets shown just plain will not work!!).

This article Kevin did is a good illustrative article of what is possible using ActiveX script in Microsoft SQL Server.

Between this article and the Lotus Notes ODBC driver article of a few days ago, I'd say this season is shaping up to be a SQL Server messaging extravaganza at SQL Server Central!!

Respectfully,

Steve
logicom-inc..com

Post #158712

Kevin Terry

Posted Tuesday, February 01, 2005 7:14 AM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:48 PM
Points: 258, Visits: 200

I am really intersted on this article
but how can find those IDs in my enviroment

strOlStoreID = "18DE200A0C99D6DC800AA002FC45A06000000504B435654303100D"
strOlEntryID = "5B7D1118DE200A0C99D6DCCCBA91795B7D11145A06000000504B435654300000"

----------------
First, yes you're right, that column should be not null (I just auto-generated a template of QA, and changed col names, without really looking at it).
If you navigate to the particular folder you're interested in, storeid and entryid are properties, accessible that way. Our resident outlook guru gave me the following code to get them (just cut and paste into notepad and save as vbs file, then run):

Dim objOutlook
Dim NmSpace
Dim myfld
Dim objFilesys
Dim objtxtfile
Dim txtIDS

Set objOutlook = WScript.CreateObject("Outlook.Application")

Set NmSpace = objOutlook.GetNameSpace("MAPI")

Set myfld = NmSpace.PickFolder

Set objFilesys = WScript.CreateObject("Scripting.FileSystemObject")

Set objtxtfile = objFilesys.CreateTextFile("C:\IDinfo.txt")

txtIDS = "The Store ID: " & myfld.StoreID & Chr(13) & Chr(10) & "The Entry ID: " & myfld.EntryID

WScript.Echo txtIDS

objtxtfile.WriteLine txtIDS

objtxtfile.Close

Post #158775

Martin Vrieze

Posted Tuesday, February 01, 2005 8:09 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, December 07, 2010 8:19 AM
Points: 327, Visits: 123

Very good article Terry!!!

Do you know where to get properties/elements to be able to read data elements for the inbox?

Is is also possible to delete items in the inbox via ActiveX code from SQL Server?

Post #158789

Michael Teff

Posted Tuesday, February 01, 2005 9:21 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, April 29, 2009 11:12 AM
Points: 3, Visits: 2

Very Interesting and wonderful article.

But I have a question on the EntryID and StoreID. From the article, it is my understanding that you need the EntryID and StoreID of the Form that you want to query information on.

The script you posted here, wouldn't that just get the EntryID and StoreID of just the public folder. Or is that all we need.

Thanks.

Post #158813

Logicom (New York)

Posted Tuesday, February 01, 2005 10:16 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, August 13, 2007 8:36 PM
Points: 10, Visits: 1

In answer to the Id questions: Outlook Spy!!

Dmitry Streblechenko offers an eval version.

Many developers use it...

Respectfully,

Steve
logicom-inc..com

Post #158840

Kevin Terry

Posted Wednesday, February 02, 2005 11:45 AM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:48 PM
Points: 258, Visits: 200

Whether or not you can delete probably has more to do w/ permissions than anything else, but yes there is a Delete method (and a Remove method, depending on what your trying to get rid of).

Outlook comes w/ an object model available under Help (at least w/ Outlook 2003 which we have here), which gives you all properties, methods, objects etc.

Post #159148

« Prev Topic | Next Topic »

19 posts, Page 1 of 2

1 2 »»

Permissions