Auto generate email

  • Thread starter Thread starter Phil P
  • Start date Start date
P

Phil P

Hi All,

I have a register of items stored in an excel file. Each of the item
has a different date associated with them and I would like to be abl
to get Excel to generate emails (all to the same address) notifyin
someone of the item number once the date is within X days.

I am fairly familiar with excel so I have no problem in writin
formulas which identify when the X (currently 30, but could change i
the future) days warning period has started. The problem is tha
currently someone must open the workbook and examine the lookup page t
see if any actions are required. It would save a lot of time if I coul
get the workbook to generate emails.

All help warmly received...

Cheers
 
Phil said:
Hi All,

I have a register of items stored in an excel file. Each of the items
has a different date associated with them and I would like to be able
to get Excel to generate emails (all to the same address) notifying
someone of the item number once the date is within X days.

I am fairly familiar with excel so I have no problem in writing
formulas which identify when the X (currently 30, but could change in
the future) days warning period has started. The problem is that
currently someone must open the workbook and examine the lookup page
to see if any actions are required. It would save a lot of time if I
could get the workbook to generate emails.

All help warmly received...

Cheers.
Click to expand...

Take a look at http://www.rondebruin.nl/sendmail.htm
 
Back
Top