Getting Excel to send a range of data from excel via Outlook

Evening all,

Long time since i last posted

I'm reasonably familiar with getting VBA to send an email via outlook by attaching the workbook to the email, however i'd like to only send a range from excel in the email body.
Here is the code i sue for emailing the worksheet:

Please Login or Register  to view this content.

But i'm not sure how to amend this to only send out a specific range from excel, which is H2:L24.
Any help would be pretty bang on!

Rich

John,
I've had a little play with the code from the link you provided, however i'm coming across a couple of issues.
How i've slightly changed the code:

Please Login or Register  to view this content.

I need to take out this line

Please Login or Register  to view this content.

otherwise it throws up an error "Compile Error: Sub or Function not defined".
When that line is taken out the code appears to work on all aspects other than copying in the data range to the email, i see your sample email address in the 'To' section, i see the subject line showing what i have asked for.

Am i missing something simple?

Rich

.
Give this a try :

Please Login or Register  to view this content.

Ha, cant get more simple than the instructions on the initial guide...... :D

Thanks for the input gents!