Can emails be automatically generated from Excel?

[suek]

Hello,

I have a spreadsheet of costs, which when the costs for a certain job are in
excess of 10 per cent of the contract price, (which is a calculated cell in
the spreadsheet), then I would like certain people to get automatically
emailled to advise that the contract amount is in excess of what is permitted.

Can this be done in Excel?

 

[Sheeloo]

Yes, it can be done however you need VBA code to do it.
Also it sends the workbook as attachment, so if you just want to send a row
then you have to copy that to a new workbook and then send that workbook...

basic code
Sub SendActiveWorkbook()
ActiveWorkbook.SendMail _
Recipients:="(e-mail address removed)", _
Subject:="Test Subject"
End Sub

 

[Ron de Bruin]

See
http://www.rondebruin.nl/mail/change.htm