I am new to QlikView and want to make a macro that would automatically copy/paste data from yesterday to excel, which would then be sent to MS.Outlook both as an attachment and as a picture in the E-mail's body section.
While writing the macro and searching through forums for answers I stumbled on three roadblocks:
1. How can I make my macro check beforehand, whether yesterday's data has been loaded ? (There is one entry that is generated and could be used as a reference)
2. At the beginning of a new month, the macro should still take last month's data, how could I structure the "IF/THEN" argument to help with this problem? (e.g. check if the "Day" filter selection has only 1 day and thus the macro understands that it should take last month)
3. is it possible and, if it is, how could I paste the tables either from QV or Excel to Outlook's E-mail body section?
(Maybe there is a way to directly change the Email body through VBScript?)
Since the code is quite long, I have attached a dummy file with it.