Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

bruno_martins_l
Contributor

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

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

9 Replies

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

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
Contributor

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

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

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
Contributor

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

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

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

kaisemar
New Contributor III

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

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
Contributor

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

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
Contributor

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

thanks guys thats got it

datanibbler
Esteemed Contributor

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

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

Community Browser