View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Billie Mac[_2_] Billie Mac[_2_] is offline
external usenet poster
 
Posts: 2
Default Send email based on date value

Hi all,

I have a spreadsheet that stores re-certification details for people. What
I need to be able to do is look in a cell in a row, and if the date in that
cell is within 90 days of todays date, send an email using an email address
stored in another cell of the same row.

I have the code for the email worked out okay, but I can't figure how to
select which people (rows) to send the email to

Thanks in advance for your help.

Cheers