Extraction of data from email attachment

rt_new_user — Fri, 28 Sep 2018 00:06:24 GMT

Hi QV users

I am a beginner and would appreciate a little help if i can from the experts out here.

I am hoping to achieve the below:

I am using outlook on my computer for my emails. I receive an email every night with a report attached as a .xls file. The report however is always in the format: DynamicReport.xls

The attachment always has the same name andthe only way i can change the date is by saving it and renaming it on my laptop. Is there a way QV can query my email account and look for this email arrival and extract the attachment which has the data need to use in my charting?

The attachment name is same every day and you cannot identify the date the data belongs to until you open the attachment.

Regards

Re: Extraction of data from email attachment

marcus_sommer — Fri, 28 Sep 2018 07:09:29 GMT

You could look if the outlook-connector (Beta Connectors) is applicable for your version and supports this feature or you could use a macro for it (I think there will be multiple examples within the office- and vba forums).

But I suggest you tries to change the source in this way that the sender stores the data within a common storage or enabled a sql/ftp/web-access to these data.

- Marcus

topic Re: Extraction of data from email attachment in QlikView

Extraction of data from email attachment

Re: Extraction of data from email attachment