Find Jobs
Hire Freelancers

Write two VBA subs connecting Excel with Outlook for basic automation

$30-250 USD

Completed
Posted about 5 years ago

$30-250 USD

Paid on delivery
I need two VBA subs written to automate certain portions of my workflow. 1. Write a sub that triggers when I receive an email from "______" sender with "_____" subject name. Sub is simple... open email attachment, copy contents, open file on desktop, paste contents, save desktop file, close desktop file, close email attachment. 2. Write a loop that checks a list of clients, creates an email for each client that attaches a file from my desktop (specific to that client by using the client name as part of the file name), and sends it to the client. Please comment the VBA code such that I know where to update the path/file names, customize the email subject and message content, etc. I'll attach a more descriptive explanation of the functionality for each sub, please let me know if you have any questions here.
Project ID: 18550546

About the project

6 proposals
Remote project
Active 5 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
I have done this exact task before and would be happy to use my skills to solve your problem! I'll provide an elegant solution that is easy to customize and scale to work with your data. Due to the government shutdown, I'm a furloughed NASA aerospace engineer with 13 years of Microsoft Office VBA experience. I may be new to freelancing, but I am an experienced and skilled engineer with lots of time on my hands! I will go above and beyond to meet your needs!
$55 USD in 3 days
0.0 (0 reviews)
0.0
0.0
6 freelancers are bidding on average $115 USD for this job
User Avatar
Hello. Nice to meet you. I have checked your project description carefully and i'm interest to your project. Excel/VBA is my top skill and i 'm sure i can do your project perfectly. I hope to work with you. Thank you.
$140 USD in 1 day
4.6 (18 reviews)
4.9
4.9
User Avatar
I have more than 5 years of experience in advanced excel, VBA automation and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed couple of automation tools for Earnest and Young also. You can get your work done here quickly with highest quality at lowest price. I accept only once you are fully satisfied with the work done. Looking forward to work with you
$120 USD in 1 day
4.6 (16 reviews)
4.0
4.0
User Avatar
Hi I have Read Your Requirements I am Excel VBA Expert Experianced in VBA Macros & Web Scraping Script... I can finish any kind of vba task in 1 day only pls see my previous projects for my vba experiance Thanks
$55 USD in 1 day
4.9 (16 reviews)
3.4
3.4
User Avatar
HELLO I CAN START RIGHT NOW - I AM EXPERT IN Excel Microsoft Outlook and I BET YOU CANNOT FIND BETTER FREELANCER THAN ME ... pLEASE MESSEGE ME AND LETS DISCUSS THE THINGS THANKS
$155 USD in 3 days
5.0 (1 review)
3.0
3.0
User Avatar
Hi! I believe I can accomplish your task within the following week. Can you gather all your requirements in a document (.txt file is enough) and send it to me? Relevant Skills and Experience I've done following VBA projects earlier: -Data exchange between Word and Excel -File operations, Excel -Using Excel to obtain data from Rockwell PLC's
$166 USD in 8 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
West Valley City, United States
0.0
0
Payment method verified
Member since Jan 18, 2019

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.