I am in need of a Process automation expert highly skilled in Coding, VBA and process automation to develop macros/plugin for outlook and excel to automate few tasks. An overview of my requirement is as below.
Outlook Macro
- This macro when executed would fetch the data from the excel file attachment of the active email and populate the data onto the next available line of an another excel file ( Lets call it “Master File AT”, worksheet name “Application Tracking”) saved in my computer. The attachment excel file received in the email and the “Application Tracking” sheet on my computer would have the same fields except for one column. All the actions should be executed without a need of opening either of the excel file.
Excel Macro
An excel macro to
- Fetch data from outlook emails; based on one or multiple criteria such as; email received date and time, email id, subject and copy it onto an sheet excel file ( Master File AT, worksheet name Email Fetcher). This sheet should enable me to send an email with an attachment and content to the selected lines from the Email Fetcher worksheet.
- Transfer data from an excel file (Master File AT, worksheet name Applicant Tracking ) to another by matching the keywords onto another excel file (Lets call it Rec Tracker) when an action is triggered. Data should not be duplicated on the Rec Tracker file.