I am in need of a VBA Expert to develop macros for outlook and excel to automate few tasks. The purpose served with macros are as below.
- 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.
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.
11 freelancers are bidding on average ₹8177 for this job
Hi, I am expert vba programmer with more than 20 year of experience in programming and office automation, I can do this task with 100% satisfaction, please come on chat so we start.
I can take your project and complete it as per your requirements. I have automated many projects and saved thousanda of hours and manual efforts. I can compete your project in the best price.