Write two VBA subs connecting Excel with Outlook for basic automation

Completado Publicado hace 5 años Pagado a la entrega
Completado Pagado a la entrega

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 para aplicaciones

Nº del proyecto: #18550546

Sobre el proyecto

6 propuestas Proyecto remoto Activo hace 5 años

Adjudicado a:

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 Más

$55 USD en 3 días
(0 comentarios)
0.0

6 freelancers están ofertando un promedio de $115 por este trabajo

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 Más

$140 USD en 1 día
(18 comentarios)
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 Más

$120 USD en 1 día
(16 comentarios)
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 Más

$55 USD en 1 día
(16 comentarios)
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 en 3 días
(1 comentario)
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 Más

$166 USD en 8 días
(0 comentarios)
0.0