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.
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
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.
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
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
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
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