Dears
I need to know how I can send an auto email reminder. My data is inside excel and I want the email to be sent through outlook automaticly.
for example:
in cell C2, the cell countains IF function where
the value of cell will be either ok , waiting or late.
I want excel to send an email automatically theough outlook to the concern person when the value cell C2 is late.
I have total 5 person where Iam selecting their
names from drop down list located in D2.
When I have new information.
i will move to next row ans so on.
Know, for example
I entered my data in second row. Then entered Selected the concern person from drop down list, then C coulm shows late. How excel can send an automatic mail to the person whom selected in the Cell D to remind him about bla bla bla.
thank you