I created a log in excel to manage our incoming documents and need to
get a macro that will bring up a new outlook email with the subject as
the name of the workbook and the body of the email as the text inputed
with in a cell. I can get it to automatically email the entire sheet,
but only need it to e-mail the information in the last updated cell of
a particular column. This is the macro that I am currently using:

Sub SendSheet()
ActiveWorkbook.SendMail Recipients:="email address"
Application.ScreenUpdating = True
End Sub

Thanks in advance for any help provided.