peacepanda
New Member
- Outlook version
- Outlook 2013 64 bit
- Email Account
- IMAP
Hi All,
I want to write a script that will do couple of things but at a high level I will list the tasks that the script needs to do.
The high level tasks involved are:
Regards,
I want to write a script that will do couple of things but at a high level I will list the tasks that the script needs to do.
- Read an incoming mail and save the attachment (The attachments are of format ABC_XYZ_YYYYMMDD.csv.zip) to a new folder everytime I receive the mail with a folder created with the file name of the attachment.
- The attachment are seven files with the name format I have given.
- I want to open the files and perform some excel operations on the files and prepare a new file
- Then I want to attach this new file as a reply to the mail that I had received with a custom message
The high level tasks involved are:
- Saving the attachments in a new folder same as the file name
- Opening of excel files and saving them all in a single workbook
- Performing operations like vlookup and other and creating a new modified file
- Attaching the new file as a response to the mail received with a customized body message.
Regards,