Send eMail using outlook based on excel data

Closed
arunsny Posts 1 Registration date Thursday October 13, 2011 Status Member Last seen October 13, 2011 - Oct 13, 2011 at 12:34 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 15, 2011 at 07:50 AM
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



Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Oct 15, 2011 at 07:50 AM
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.
0