Display Outlook Data from more than one Folder like SQL JOIN

Status
Not open for further replies.
E

escamoteur

Hi

if I want do get a result datas set that contains fields from two tables I can do a simple JOIN query with SQL.

Is it possible (probably not) to create Outlook Views that combine fields from different folders. E.g. Taskfields together with

Contact fields depending on certain field values.

If not, is is possible to fill a explorer window with y fully custom view? Where I fill the rows from my plugin??

I'm using Outlook 2007

Best

Tom
 
K

Ken Slovak - [MVP - Outlook]

You'd have to gather the data from one folder at a time and aggregate it

yourself. You'd need a form with something like a grid control, an Explorer

can't show items from more than one folder at a time in its grid control.

"escamoteur" <mail@burkharts.net> wrote in message

news:BA68ACCD-9CCA-43D5-980C-CD0E92A5D8A7@microsoft.com...
> Hi

> if I want do get a result datas set that contains fields from two tables I
> can do a simple JOIN query with SQL.

> Is it possible (probably not) to create Outlook Views that combine fields
> from different folders. E.g. Taskfields together with Contact fields
> depending on certain field values.

> If not, is is possible to fill a explorer window with y fully custom view?
> Where I fill the rows from my plugin??

> I'm using Outlook 2007
> Best
> Tom
 
E

escamoteur

I was already fearing you would tell me that. Is there a way to display my own control instead of an Explorer View?

Best

Tom
<kenslovak@mvps.org> schrieb im Newsbeitrag news:%23CPIBAMJKHA.4232@TK2MSFTNGP02.phx.gbl...
> You'd have to gather the data from one folder at a time and aggregate it
> yourself. You'd need a form with something like a grid control, an Explorer
> can't show items from more than one folder at a time in its grid control.

> >

>

> "escamoteur" <mail@burkharts.net> wrote in message
> news:BA68ACCD-9CCA-43D5-980C-CD0E92A5D8A7@microsoft.com...
> > Hi
>

>
>> if I want do get a result datas set that contains fields from two tables I
> > can do a simple JOIN query with SQL.
>

>> Is it possible (probably not) to create Outlook Views that combine fields
> > from different folders. E.g. Taskfields together with Contact fields
> > depending on certain field values.
>

>> If not, is is possible to fill a explorer window with y fully custom view?
> > Where I fill the rows from my plugin??
>

>> I'm using Outlook 2007
> > Best
> > Tom

>
 
K

Ken Slovak - [MVP - Outlook]

Only by using an overlay using a window created using Win32 API calls and

then overlaid over the existing grid window, called the SuperGrid.

For Outlook 2007 you could display an Explorer Custom Task Pane with a grid

in it, that's an alternative but only for Outlook 2007 (or 2010).

"escamoteur" <mail@burkharts.net> wrote in message

news:7B4B307F-4E02-4A29-84A2-B31708A06A26@microsoft.com...
> I was already fearing you would tell me that. Is there a way to display my
> own control instead of an Explorer View?
> Best
> Tom
 
Status
Not open for further replies.
Top