Can emails be automatically generated from Excel?

S

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?
 
S

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:="[email protected]", _
Subject:="Test Subject"
End Sub
 
Top