Write two VBA subs connecting Excel with Outlook for basic automation

Fullført Lagt ut 5 år siden Betales ved levering
Fullført Betales ved levering

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.

Excel Microsoft Outlook Visual Basic Visual Basic for apper

Prosjekt-ID: #18550546

Om prosjektet

6 bud Eksternt prosjekt Aktiv 5 år siden

Tildelt til:

brettables

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 Mer

$55 USD på 3 dager
(0 omtaler)
0.0

6 frilansere byr i gjennomsnitt $115 for denne jobben

lightingdavid

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 Mer

$140 USD på 1 dag
(18 Omtaler)
4.9
bhupendrayadav

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 o Mer

$120 USD på 1 dag
(16 Omtaler)
4.0
Mokshith30

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 T Mer

$55 USD på 1 dag
(16 Omtaler)
3.4
anshsparkle

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 på 3 dager
(1 anmeldelse)
3.0
gambina1557

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 Mer

$166 USD på 8 dager
(0 Omtaler)
0.0