Macro for e-mailing cell range



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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question