Email generated from Excel database

[Emma]

Hi,

I have a file tracking contracts for my department. When A contract is
coming close to expiring I want an email to be generated.

In column D I have the expiry date and in Column E I have the notification
date (the number of days before the expiry date I want the appropriate buyer
to be notified). Column F has a formula checking if we have reached the
notification period or if we are still 'OK'.

Column G has the buyers name (I can also change if to their email address if
it helps). I would like excel to continuously monitor for contracts that hit
the notification period and at this point send just 1 email out to that Buyer
to notify them the contract is almost expired. In the email I want to nclude
the material name, supplier name and site name (columns H+I+J). No
attachments are necessary in the email just some fixed text and the data in
columns H, I, J. Is this possible?

Ideally the emails would be able to be sent even without me opening the file
- But I can imagine this is not possible with excel, so if I could just open
up the file and run a macro that would be great.

Oh and by the way I only want the email to be sent once - the first time I
open the file and now() is greater than the notification date in column E.

I am using Excel 2003 and lotus notes email (sorry my companies choice not
mine!). I still have the ability in excel to use the file -> send to
function if that is of help....)

Thank you in advance for any help! I know how to record macros within excel
but have never actually written any code of my own (only tweaked code already
written).
If my explanation is not clear enough please let me know.

Thanks
Emma

 

[Madiya]

Hi,

I have a file tracking contracts for my department.  When A contract is
coming close to expiring I want an email to be generated.

In column D I have the expiry date and in Column E I have the notification
date (the number of days before the expiry date I want the appropriate buyer
to be notified).  Column F has a formula checking if we have reached the
notification period or if we are still 'OK'.

Column G has the buyers name (I can also change if to their email address if
it helps).  I would like excel to continuously monitor for contracts that hit
the notification period and at this point send just 1 email out to that Buyer
to notify them the contract is almost expired.  In the email I want to nclude
the material name, supplier name and site name (columns H+I+J).  No
attachments are necessary in the email just some fixed text and the data in
columns H, I, J.  Is this possible?

Ideally the emails would be able to be sent even without me opening the file
- But I can imagine this is not possible with excel, so if I could just open
up the file and run a macro that would be great.

Oh and by the way I only want the email to be sent once - the first time I
open the file and now() is greater than the notification date in column E.

I am using Excel 2003 and lotus notes email (sorry my companies choice not
mine!).  I still have the ability in excel to use the file -> send to
function if that is of help....)

Thank you in advance for any help!  I know how to record macros within excel
but have never actually written any code of my own (only tweaked code already
written).
If my explanation is not clear enough please let me know.

Thanks
Emma

This can be done. Only you need to add a status column which will be
updated once a mail is sent.
There are many examples available in this NG. Just search for Lotus
notes mail.
Also have a look at following.
http://www.rondebruin.nl/tips.htm
http://www.excelkb.com/?cNode=1X5M7A
http://www.experts-exchange.com/Applications/Email/Lotus_Notes_Domino/Q_20782076.html

Regards,
Madiya