Hi,
I meant it this way
.HTMLBody = strbody & vbNewLine & RangetoHTML(rng) & Signature
On Thu, Dec 24, 2009 at 12:27 PM, Vinod N wrote:
> Hi Praveen,
>
> Do you mean .htmlbody should read as below:
>
> .HTMLBody = Please clarify the following:" & vbNewLine & RangetoHTML(rng) &
> Signature
>
>
Hi Vinod,
Can you try using vbnewline in .htmlbody directly instead of using it in
strbody?
On Wed, Dec 23, 2009 at 10:29 PM, Vinod N wrote:
> Hi Excel Gurus,
>
> In the attached file, the following string is not working
>
> strbody = "Please clarify the following:" & vbNewLine
>
> Initially, t