Macro for e-mailing cell range

[trinibigboy]

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.

 

[Gord Dibben]

Have a look at the code at Ron de Bruin's site.

Cell range as text in the body of email.

http://www.rondebruin.nl/mail/folder3/mail4.htm

If not to your liking hit Ron's "Index" link for more options.


Gord Dibben MS Excel MVP