Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bruno_martins_l
Partner - Creator
Partner - Creator

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
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
Partner - Creator
Partner - Creator
Author

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
Partner - Creator
Partner - Creator
Author

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
Partner Ambassador
Partner Ambassador

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
Partner - Creator
Partner - Creator
Author

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
Creator
Creator

thanks guys thats got it

datanibbler
Champion
Champion

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