Re: $$Excel-Macros$$ Help on macros - Mail sent from Excel

2009-12-24 Thread kvc praveen kumar
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 > >

Re: $$Excel-Macros$$ Help on macros - Mail sent from Excel

2009-12-23 Thread kvc praveen kumar
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