Hello,
I am new to this site and Excel VBA.. Thank you all in advance for your assistance.
I am trying to automate the workflow of a spreadsheet in my business.
Currently operators fill out a spreadsheet (template) and manually submit this to the reviewing team, who review and confirm the request and submit to the processing team.
Once processed, they return it back to the reviewing team who stores the request for record keeping.
In the new purposed solution, I want the spreadsheet to be emailed to the reviewing team. Once reviewed, the spreadsheet is saved to a Hdrive location for processing, and once processed the spreadsheet is printed to PDF and stored in another HDrive location.
Now I got all the movements to work, my ONLY issues is when the file is reviewed (and saved to HDrive location), the email remains in the mailbox, and therefore can lead to the requesting being accepted twice.
So I want the spreadsheet attachments, one confirmed and saved to the HDrive to either move the related email to a specific folder or mark the mail with say a 'green' flag - Outlook 2003.
I hope this makes sense... your assistance is very very much appriciated.
Thank you.
I am new to this site and Excel VBA.. Thank you all in advance for your assistance.
I am trying to automate the workflow of a spreadsheet in my business.
Currently operators fill out a spreadsheet (template) and manually submit this to the reviewing team, who review and confirm the request and submit to the processing team.
Once processed, they return it back to the reviewing team who stores the request for record keeping.
In the new purposed solution, I want the spreadsheet to be emailed to the reviewing team. Once reviewed, the spreadsheet is saved to a Hdrive location for processing, and once processed the spreadsheet is printed to PDF and stored in another HDrive location.
Now I got all the movements to work, my ONLY issues is when the file is reviewed (and saved to HDrive location), the email remains in the mailbox, and therefore can lead to the requesting being accepted twice.
So I want the spreadsheet attachments, one confirmed and saved to the HDrive to either move the related email to a specific folder or mark the mail with say a 'green' flag - Outlook 2003.
I hope this makes sense... your assistance is very very much appriciated.
Thank you.
