View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Excel Help! Excel Help! is offline
external usenet poster
 
Posts: 26
Default Automatic email based on date

I'm searching for information to complete the following task: I have an excel
file which contains the following information. Column A: Name; Column B: Date
training completed; Column C: email address. I would like to write a macro
to search thru column B for an date, if there's no date, it would send an
email to user's email address in colum C? It's bvious I would need the macro
stop if there no name in Column A. Thanks in advance.