Send eMail using outlook based on excel data

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