Find Jobs
Hire Freelancers

Process Automation Expert - VBA & Coding skills

$30-250 USD

Completed
Posted over 3 years ago

$30-250 USD

Paid on delivery
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.
Project ID: 28942159

About the project

4 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, as per our discussion, please come on chat so we can start the work. its kashif baig from pakistan. can you please initiate the chat window.
$240 USD in 15 days
4.6 (6 reviews)
3.4
3.4
4 freelancers are bidding on average $285 USD for this job
User Avatar
Hi I've coded many outlook vba automations. I can detail . Regards, Zurab Ms Access/Excel/vba expert
$500 USD in 7 days
4.9 (17 reviews)
5.0
5.0

About the client

Flag of SAUDI ARABIA
Riyadh, Saudi Arabia
5.0
1
Payment method verified
Member since Jan 17, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.