Excel Macro to send mails automatically on a specific date

[7jitesh]

Hello,

This is my first query at this forum, I'm very new with Macro.

I have an excel sheet for which I need a macro to send email automatically on specific dates.

I prefer to open up the sheet daily, if any one the fields has today's date then it should shoot up a mail by picking up the entire row in which it exist.

I wondered whether this is possible.

Please find attached, Kindly guide me.

One more thing, I have been through that link to send emails www.rondebruin.nl/sendmail.htm ,
wherein different examples are provided, but I had many permutations and combination, due to which I got confused... and I seem to go nowhere

Thanks

 

[daverunt]

Hi,

Have a look at an example I posted a while back.

http://www.mrexcel.com/forum/showthread.php?t=512138

It checks the range in Sheet3 E1 to E100 for todays date when the workbook is opened then sends an email using information in offsets from the specific cell.

It's a starting point.

 

[Ruddles]

I prefer to open up the sheet daily...

And you'd use the Windows Task Scheduler to do this bit.