Prakash Nair
New Member
Dear Friends,
I don't know anything about VBA or Macros. But I want the excel to send a reminder e mail 30 days prior to the expiry of an item from a list of items. I have googled and found this VBA code. It works fine, but only if I select RUN on the VBA page. I am not sure whether I have done the complete procedure to set it up. I only pasted the code from internet to the Excel VBA page. I opened the VBA page by right clicking the sheet1 tab and selecting view code.
I would like the excel to send e mail to the email address automatically when ever the expiry date is 30 days away and whenever the PC is powered on. Or when the PC is signed in. The PC is always on. I shall upload the file created. Kindly help me to fix it.
Thanks & Best regards
Prakash
I don't know anything about VBA or Macros. But I want the excel to send a reminder e mail 30 days prior to the expiry of an item from a list of items. I have googled and found this VBA code. It works fine, but only if I select RUN on the VBA page. I am not sure whether I have done the complete procedure to set it up. I only pasted the code from internet to the Excel VBA page. I opened the VBA page by right clicking the sheet1 tab and selecting view code.
I would like the excel to send e mail to the email address automatically when ever the expiry date is 30 days away and whenever the PC is powered on. Or when the PC is signed in. The PC is always on. I shall upload the file created. Kindly help me to fix it.
Thanks & Best regards
Prakash