Hi,
I've created a scheduler in our Cognos reporting system that emails me an updated data extract each morning. What I would like is a macro that identifies this daily email (perhaps when I open outlook?) and copies the attachment to a defined area on the network and overwrites the previous attachment. If it helps the email address, subject name and attachment name are always the same. For the purposes of this let's say they are as follows:
Email - Snook@hotmail.com
Subject - Cognos Data Extract
Attachment - Data Extract.xlsx
Network Address - \\network\performance management
What would also be useful is if the email could be moved to another folder within my inbox once the attachment has been extracted, e.g. named 'Cognos Data'.
If you require any further info just give me a shout.
Thanks in advance,
Snook
I've created a scheduler in our Cognos reporting system that emails me an updated data extract each morning. What I would like is a macro that identifies this daily email (perhaps when I open outlook?) and copies the attachment to a defined area on the network and overwrites the previous attachment. If it helps the email address, subject name and attachment name are always the same. For the purposes of this let's say they are as follows:
Email - Snook@hotmail.com
Subject - Cognos Data Extract
Attachment - Data Extract.xlsx
Network Address - \\network\performance management
What would also be useful is if the email could be moved to another folder within my inbox once the attachment has been extracted, e.g. named 'Cognos Data'.
If you require any further info just give me a shout.
Thanks in advance,
Snook