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