topic Re: How to connect Qlikview to Outlook 2007 for extract Data Calendar and Mails in QlikView

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

bruno_martins_l — Sat, 16 Feb 2013 15:01:21 GMT

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

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

marcus_sommer — Sat, 16 Feb 2013 17:56:39 GMT

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

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

bruno_martins_l — Sun, 17 Feb 2013 10:13:17 GMT

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

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

marcus_sommer — Sun, 17 Feb 2013 10:47:24 GMT

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).

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

bruno_martins_l — Sun, 17 Feb 2013 11:38:04 GMT

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'

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

marcus_sommer — Sun, 17 Feb 2013 14:31:27 GMT

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

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

Marc_Kaiser — Sun, 17 Feb 2013 15:01:04 GMT

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

not sure about calendar entries...

Marc

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

bruno_martins_l — Sun, 17 Feb 2013 20:26:31 GMT

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.

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

samuel_brierley — Thu, 16 Jan 2014 12:58:31 GMT

thanks guys thats got it

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

datanibbler — Thu, 14 Aug 2014 09:48:07 GMT

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