Adding a Range to an Email Body

[djfatboyfats]

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

[nathansav]

Try without the select at the end.

[apo]

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

[djfatboyfats]

Would RonDeBrins method attach the workbook and paste a range into the body or just paste everything into the body? As i need it to attach the work book and take some data and paste that into the body of the message.

Nathansav - Thanks for the help but that didn't work.

[apo]

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..

[djfatboyfats]

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

[apo]

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

[djfatboyfats]

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

[Norie]

What have you tried?

[djfatboyfats]

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

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

[Norie]

This will add a range to the body and add the activeworkbook as an attachment.

Please Login or Register  to view this content.

Note, this is basically the snb's code from the link apo provided, the only thing I added was the attachment part.

[djfatboyfats]

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.

[Norie]

You would need Ron de Bruin's code for that.

[djfatboyfats]

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