Automated email

Hi,

I am trying to send out an automated email to notify users that a job has been completed I am trying to get the macro to send out an email whenever the date in column 27 equals todays date. In the subject I would like to have the job name inserted this can be found in column 5 of the spreadsheet.

Anyone have any ideas?

Please Login or Register  to view this content.

Originally Posted by Vlad999

Hi,

I am trying to send out an automated email to notify users that a job has been completed I am trying to get the macro to send out an email whenever the date in column 27 equals todays date. In the subject I would like to have the job name inserted this can be found in column 5 of the spreadsheet.

Anyone have any ideas?

Please Login or Register  to view this content.

Assuming the Job Name is in E1 (column 5 as stated), just change the .Subject line to:

Please Login or Register  to view this content.

HTH

Thank you,

But how do i actually get it to send out an email based on the conditions I specified?

Thanks I worked it out.