Send eMail using outlook based on excel data

[Closed]
Report
Posts
1
Registration date
Thursday October 13, 2011
Status
Member
Last seen
October 13, 2011
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello everyone,

i'äm new to this forum hope you experts can help me solve my problem, I have an excel file which consists of calibration date of some machines. What I need is that excel automatically sends mail to the responsible person of the particular machine 15 days before the next calibration due date. please let me know your views. i'm very new to vba. please help!!!

thanks

Arun



1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
depends on what you have in mind what how excel is supposed to send email

If you are thinking that file is closed and excel itself would send email, that will not be possible.

If you meant that excel file is opened and then it send email, that might be more doable.