Help getting excel to send emails on a date

[ryan james hardy]

Hi,
I need some help getting excel to send emails to a list of people dependent on the dates in another column. Preferably this would happen automatically but if i have to open the excel file and click a button that would be ok to. Bascially the macros would check column C for dates, and if the date is 3 days away then send an email to the email address in column B. Ideally the email would be automatically populated with a standard response or the macros could get the email subject/msg from cell data.
thanks in advance,
Ryan

 

[JimH]

In the line:

Set Rng = Range(Range("C1"), Range("C" & Rows.Count).End(xlUp)) what is the part after the equal sign doing?

Should I replace the whole line with:

Set Rng=Range(C10:C109).Value

 

[daverunt]

Hi

It is selecting the range in column C down to the last filled cell so the range is set as C1 to the last filled cell. The range is automatically expanded as you fill in more cells in the column and the advantage is you don't need to modify the code.

Yes replace the complete line.