Can emails be automatically generated from Excel?
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 _
", _
Subject:="Test Subject"
End Sub
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...
"suek" wrote:
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?
|