topic READ OUTLOOK EMAILS BY USER, SENDER & SUBJECT in QlikView

READ OUTLOOK EMAILS BY USER, SENDER & SUBJECT

christian77 — Tue, 31 May 2011 09:45:11 GMT

Hi everybody:

I’d like to read mails from Outlook. I’ve searched already in the discussions.

Do I use a macro? Do I use the script? Does anybody have any idea or suggestion? Has anyone done that before?

Thanks.

READ OUTLOOK EMAILS BY USER, SENDER & SUBJECT

brenner_martina — Tue, 31 May 2011 09:50:01 GMT

Please open Outlook!

READ OUTLOOK EMAILS BY USER, SENDER & SUBJECT

christian77 — Tue, 31 May 2011 10:02:48 GMT

I want to do it with QV. Is there anyway?

READ OUTLOOK EMAILS BY USER, SENDER & SUBJECT

Alexander_Thor — Tue, 31 May 2011 14:47:37 GMT

Hi Christian,

Outlook comes with its own built in export function. From Outlook you should be able to export folder contents into a csv or tab seperated file.

For Outlook 2007: File -> Import and Export -> Export to a file -> Choose your format.

If you want to pull statistics from an exchange server I would suggest you look into the available cmdlets.

READ OUTLOOK EMAILS BY USER, SENDER & SUBJECT

christian77 — Tue, 31 May 2011 15:01:28 GMT

Thanks.

The discussion is wrongly set by me. I made a mistake. I didn´t really want the messages. What I wanted were the attachments.

I already have a macro taking those pst files and extracting (I don´t know how in the hell, somebody else did it for me) the attachments and placing them in C:\Temp. It works fine.

I haven’t tried yet with the messages but I think it would be possible, since for attachments it is.

Exporting from Outlook is great too. The thing is, you know, some clients don´t want to do any effort. They don´t even want to click twice. They just want all to be automatic.

Re: READ OUTLOOK EMAILS BY USER, SENDER & SUBJECT

Anonymous — Wed, 18 Jun 2014 19:24:19 GMT

Hi,

I don't know if this is still of use, have a look at this thread.

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

Cheers,

Antoine