Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Email from Excel on due date

0

Hi Team,

I am seeking your help in here please regarding the excel macro related to Send email from excel.

i have the data in excels as below 

To in column A

CC in column B

CC in Column C

Subject in Column D

Body in Column E

Set Date in Column F

i need excel to send email with content from above with 

Set date + 20 days to "TO + CC" only

Set date + 25 days to "TO + CC + CC" only

Also if there is a possibility to include a comment if 20 days remainder is sent and 25 days remainder is sent on separate columns ?

this might be too much but appreciate your help on this.

Thank you

excel
posted by: SriramV on Mon May 17, 2021 at 12:04 pm
Answer
Discuss

Discussion

Google for "Ron de Bruin". He is the one who wrote a lot of code for sending emails from Excel. You can download all his tested and proven examples. With that as a base, start introducing your own requirements. See how far you get.
If you get stuck, publish the code you will then have, describe the problem you are having and ask for help here.
Variatus (rep: 4889) May 17, '21 at 8:11 pm
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login