sending email with specific range as email body vba modification

**KK1234** · 05-19-2014, 06:22 AM

Hi this is one of the best solution I found on MS help site.
This helps in sending email with certain cells from sheet as email body.

Please Login or Register  to view this content.

I am trying to modify this code to include:
1. Range from A2:H5000 ( Only rows having data in it)
2. When Receiver replies & edits cells, the colour of text added is RED in email body
3. If I go ahed with sending email, but after display I change my mind, I should be able to cancel it. Currently I dont know how to do it, as email envp there is no provision

Help requested
Kind regards

**satabp** · 05-19-2014, 06:54 AM

Hi,

Lets try this..

If you use the following code, the envelope will sent without any confirmation.

Please Login or Register  to view this content.

But, if you use it as following, then it will display first and then you need to click send to send out.

Please Login or Register  to view this content.

Thanks,

**KK1234** · 05-19-2014, 07:52 AM

Hi Satabp,
Thanks. This is known to me.
I am trying the following.
1. Range from A2:H5000 ( Only rows having data in it)
Resolved it by: adding few lines as follows:

Please Login or Register  to view this content.

2. When Receiver replies & edits cells, the colour of text added is RED in email body
3. If I go ahed with sending email, but after display I change my mind, I should be able to cancel it. Currently I dont know how to do it, as email envp there is no provision

Item 2, 3 are still under experimentation and need help.
Thanks

**KK1234** · 05-19-2014, 11:24 AM

2 . HTML tags worked out to solve issue in 2 above
3. This method closing envp is tricky and not necessary anymore.
With this the thread has been solved.
Thanks