Adding a Range to an Email Body

Good afternoon,

I'm trying to add a range to this email code that will then paste the information into the body of this email however instead of getting the data I need i'm getting "-1" in the body instead.

I've tried defining the range below and adding that line to the main code but it doesn't work, the code will run but i get "-1" in the body.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks in advance

You need to use RonDebruins RangetoHTML method..
http://www.rondebruin.nl/win/s1/outlook/bmail2.htm

or.. if your range is contiguous..

Try snb's method (much less code)
http://www.snb-vba.eu/VBA_Excelgegev...len_en.html#L4

As the name suggests.. it will convert a range to html and allow that to be used in the .HTMLBody of the email..

The link i gave has a pretty good example..

I personally prefer snb's method.. much less code.. and you can make it work on non contiguous ranges by filtering/copying the data to a temp sheet to make it a contiguous range..

Cheers Apo. So as far as you know there isn't any way to send the workbook as an attachment AND copy a range of data into the body of the email? It has to be one or the other, either an attachement or HTML in the body.

Regards

DJ

Hi..

Sorry.. i must have misunderstood your question.. yes.. you can send the Workbook as an attachment and also insert a range into the .htmlbody of the email..

I don't think one negates the other...

Again.. I refer to my bible:

http://www.snb-vba.eu/VBA_Excelgegev...len_en.html#H3

I cant get this to work, could someone be kind enough to send the code or a sample workbook that will send the file as an attachment and place a range into the body of an email?. I would be truly grateful

Thanks

DJ

I've been looking at RonDeBruin's website any trying numerous different codes, I can get an email to send in the HTML body and I can get an attachment in the email but I cant do both. I have also looked at

HTML Code: 

but still the same. I've also tried adding ranges to the Body part of the code but nothing is working.

Thanks in advance

DJ

Thanks very much. Do you know if there is a way to keep the formatting in the HTML body? When it copy's the range into the email it loses all the colour and it has some kind of grid line around it.

OK, Thank you very much for your help so far, its appreciated. I will have a look at Ron's website and see if I can figure it out.

Regards

DJ