How to connect Qlikview to Outlook 2007 for extract Data Calendar and Mails

[bruno_martins_l]

Hello,

I want to connect QLikview to my Outlook to load the Calendar and my emails to create a Activity Dashboard.

I don't find an ODBC connector, I would that the data are load in the reload of my application to have the new datas.

Do you have an idea for help me please?

Kind regards,

Bruno

[marcus_sommer]

I think per ODBC is it not possible, but per vbs you can access to outlook.

Set oolApp = CreateObject("Outlook.Application")

Set email = oolApp.CreateItem(0)

email.Recipients.Add("me@myemail.com")

Search per google for further information (vbs/vba).

- Marcus

[bruno_martins_l]

Hello,

Sorry I don't know VBA code.

Can you help me to understand how I can use this please ? In the Script of alimentation or in the part Macro?

Because when I put this code in the Macro, I have the message

'Un composant ActiveX ne peut pas créer un objet.: 'Outlook.Application''

Thanks a lot.

Kind Regards,

Bruno

[marcus_sommer]

I cannot to provide an ready script for this because I have very little experience with outlook-scripting. When your tasks are more complicated, it would be easier to use vba in outlook as vbs in qlikview and made a trigger on open outlook. Perhaps you can use a native export function from outlook per trigger.

Your error message comes from missing security rights in macro module, you must allow extern access (left side from macro editor).

See also here for possible solutions.

http://community.qlik.com/message/125410#125410

http://community.qlik.com/message/80399#80399

http://community.qlik.com/message/120630#120630

- Marcus

[bruno_martins_l]

Thanks,

When a clik in Test in the macro page, I dont't have error message but nothing appen too. What is the goal of this script?

I have see this post before but I have a problem with Access because I have the error :

Assistant Importation Exhange / Outlook : L'objet ou la classe  ne gère pas le jeu d'évènement'

[marcus_sommer]

The code snippet was only an example to show how create outlook-objects. All things in outlook are objects which have items and properties and they can read and write - but how exactly, I don't know.

The simplest way to beginning will be, search and use native functions in outlook manually, then try this function in vba (you know now after which you search) and then you can try it in qlikview-vbs and/or create a trigger for this routine.

- Marcus

[Marc_Kaiser]

There is a connector to load emails: http://www.qvsource.com/wiki/MailBox-Connector-For-QlikView.ashx

not sure about calendar entries...

Marc

[bruno_martins_l]

Thanks for your link, but the solution QVSrouces is not free.

I think VBScript can be the solution but I don't know how use VB Script.

[samuel_brierley]

thanks guys thats got it

[datanibbler]

Hi Marc,

do you know if there is also a connector available for tasks managed in Outlook?

Many teams in our company do that and if tasks could be automatically loaded into QlikView, that would certainly boost the usage of QlikView as a working_tool.

Thanks a lot!

Best regards,

DataNibbler