Завершено

Write two VBA subs connecting Excel with Outlook for basic automation

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 для приложений

Показать больше excel visual basic routine, excel visual basic bid price, excel visual basic function howto, outlook.application vba reference, macro to send email from excel with body, macro to send email from excel using outlook, excel macro to send email automatically, outlook automation using vba, excel vba create email but don't send, vba code to send email from excel to outlook, vba code to send email from outlook with attachment, convertir excel visual basic, excel visual basic chart, vba split separate excel, mssql excel visual basic script, write vba excel 2007, write vba script outlook 2007, visual basic sending email excel outlook, write excel visual basic 2008, excel outlook access automation

О работодателе:
( 0 отзыв(-а, -ов) ) West Valley City, United States

ID проекта: #18550546

Поручен:

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 Больше

$55 USD за 3 дней(-я)
(0 отзывов(-а))
0.0

6 фрилансеров(-а) в среднем готовы выполнить эту работу за $115

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 Больше

$140 USD за 1 день
(18 отзывов(-а))
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 Больше

$120 USD за 1 день
(16 отзывов(-а))
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 Больше

$55 USD за 1 день
(16 отзывов(-а))
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 за 3 дней(-я)
(1 отзыв)
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 Больше

$166 USD за 8 дней(-я)
(0 отзывов(-а))
0.0