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.
Thread starter Similar threads Forum Replies Date
M In Outlook Calendar remove the buttons: 'Today' and '<' (Back a day) and '>' (Forward a day) that are below the Ribbon and above the calendar display. Using Outlook 0
E How to display "Change Folder" in Change Default Email Delivery Location in Exchange Outlook 2016 Using Outlook 1
C Outlook Mobile app email order randomized and display names stripped Using Outlook 6
I How to display sender's name instead of email address in outlook 2013 message Using Outlook 5
J Outlook 2016 message content does not display - outlook.com; exchange Using Outlook.com accounts in Outlook 9
soadfan Outlook rules look up display name only Using Outlook 4
T outlook 2010 mail item count doesnt match display Outlook VBA and Custom Forms 3
P How to make outlook display alert appear on top of other windows whenever a new email is received? Outlook VBA and Custom Forms 1
T Outlook 2016 Calendar multiday event display Using Outlook 4
Diane Poremsky Display the Created Date field of any Outlook item New Slipstick.com Articles 0
K Display sub-folders in body of outlook Using Outlook 1
O How to display multi-line task in To-Do List - Outlook 2010 Using Outlook 1
Diane Poremsky Pictures don't display in Outlook messages New Slipstick.com Articles 4
M Outlook VBA Macro that could retrieve/display the (From, Subject, Date Received) Outlook VBA and Custom Forms 2
William Yeack Outlook/Exchange - Changing display of “From” user Using Outlook 3
M Display as name in outlook contacts changes Using Outlook 5
Maybear Sudden change in Outlook, no image display, email no longer offers suggestions for address Using Outlook 8
B Display of Sending Account in Outlook 2007 no longer works Using Outlook 2
P Outlook can not display picture inline. Using Outlook 7
O Outlook 2013 contacts - Where to find "Display as"-field Using Outlook 2
J Outlook 'From' and 'Display As' Using Outlook 1
D Outlook Calendar Display Using Outlook 10
F Outlook 2010 contact e-mail Display as: does not show contact name Using Outlook 2
C Optimize your Outlook 2013 screen display for touch Using Outlook 1
J outlook having sort by date or from unable to display sender name. Using Outlook 2
G Outlook 2013 display the wrong font Using Outlook 7
C [outlook-users] Display Name Using Outlook 3
B Outlook cannot display this view Using Outlook 1
B Outlook 2010 People Pane doesn't display appointments Using Outlook 2
A Messages sent from Outlook 2010 display incorrect 'sent to' name in Hotmail Using Outlook.com accounts in Outlook 4
N Outlook 2010 will not add or display new email accounts Using Outlook 3
L Anyway to Display entire category list in Outlook 2007 automatically? Using Outlook 1
Y Outlook 2007 not display conversation history on Reply or Forward Using Outlook 0
J Display the Weather in Outlook Calendar? Using Outlook 1
C 20 Seconds to Display Messages in Folder in Outlook 2007 Using Outlook 2
F Add-In Tab won't display in Outlook 2010 Ribbon Using Outlook 1
H Outlook 2007 slow folder content display after installing kb2412171 Using Outlook 33
K Outlook 2007 ribbon does not display "encrypt" and "sign" buttons Using Outlook 2
M Cannot display the folder. Outlook cannot open this item. The item may be damaged. __ Using Outlook 1
E Getting all items in Outlook contact activities to display properly Using Outlook 2
I Outlook email content display issue Using Outlook 3
T "Look up Outlook Contact" from a received email does not display all of the contact information Using Outlook 9
T Outlook Today does not display in Oultook 2010 Using Outlook 3
B Outlook opens but will not display a home page. I can't see anything except the very top toolbar____ Using Outlook 1
J Customize Outlook view to fit Smartphone display via i.e. Citrix Receiver ? Using Outlook 1
F Outlook 2010 Incoming Meeting Requests display as text / code, cannot accept these invites (includes Using Outlook 4
B Outlook Mailbox display name Using Outlook 2
D Outlook 2007 Display Sent item not correctly Using Outlook 1
W Microsoft Outlook 2010 Instant Search Encountered a Problem While Trying to Display Results. Using Outlook 1
I Unable to display web embedded pictures in outlook mail Using Outlook 1
Similar threads


















































Top