There is any auto email format?
 

Hi All,

I know some one can help me in this regard, that I am using excel for
Insurance expiry date list more then 2000 list I have. Now what my question
is everyday I cant able to find every expiry date. I want some solution from
that if there is any formula like if insurance date was expired how can I get
the email for me? Like the date is 8/3/2010 and number is 123456 at the same
day automatically I want email from for warning so that I can renewal the
same.

If there is any formula or something pls help me. I am very struggling for
this.

There is any auto email format?
 

Have you tried Conditional Format? For the Expiry Date column, use
FORMAT, Conditional Format, Cell Value is Greater than or Equal to, =Today()
and set the actual Pattern to Color Red.

"Rohinikumar" wrote:

Hi All,

I know some one can help me in this regard, that I am using excel for
Insurance expiry date list more then 2000 list I have. Now what my question
is everyday I cant able to find every expiry date. I want some solution from
that if there is any formula like if insurance date was expired how can I get
the email for me? Like the date is 8/3/2010 and number is 123456 at the same
day automatically I want email from for warning so that I can renewal the
same.

If there is any formula or something pls help me. I am very struggling for
this.

There is any auto email format?
 

Hi Wilpeter i have done that..but everyday i have to check which was in red
colour.....if there is any chance to get an email if date was expired?

"Wilpeter" wrote:

Have you tried Conditional Format? For the Expiry Date column, use
FORMAT, Conditional Format, Cell Value is Greater than or Equal to, =Today()
and set the actual Pattern to Color Red.

"Rohinikumar" wrote:

Hi All,

I know some one can help me in this regard, that I am using excel for
Insurance expiry date list more then 2000 list I have. Now what my question
is everyday I cant able to find every expiry date. I want some solution from
that if there is any formula like if insurance date was expired how can I get
the email for me? Like the date is 8/3/2010 and number is 123456 at the same
day automatically I want email from for warning so that I can renewal the
same.

If there is any formula or something pls help me. I am very struggling for
this.

There is any auto email format?
 

Hi Wilpeter i have done that..but everyday i have to check which was in red
colour.....if there is any chance to get an email if date was expired?

"Wilpeter" wrote:

Have you tried Conditional Format? For the Expiry Date column, use
FORMAT, Conditional Format, Cell Value is Greater than or Equal to, =Today()
and set the actual Pattern to Color Red.

"Rohinikumar" wrote:

Hi All,

I know some one can help me in this regard, that I am using excel for
Insurance expiry date list more then 2000 list I have. Now what my question
is everyday I cant able to find every expiry date. I want some solution from
that if there is any formula like if insurance date was expired how can I get
the email for me? Like the date is 8/3/2010 and number is 123456 at the same
day automatically I want email from for warning so that I can renewal the
same.

If there is any formula or something pls help me. I am very struggling for
this.