Send an excelsheet using vba

**aman1234** · 12-05-2013, 06:58 AM

Hi guys

I am writing the following code to send excelsheet through email but it doesn't work.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**Pepe Le Mokko** · 12-05-2013, 07:01 AM

Perhaps you will want to have a look at Ron de Bruin's solution
The mail add-in he built is very easy to use, and the code is available if needed

**nathansav** · 12-05-2013, 07:02 AM

You need to copy the function rangetoHTML also.

**aman1234** · 12-05-2013, 07:26 AM

I copied the following code but still doesn't send an email.

Please Login or Register  to view this content.

**aman1234** · 12-05-2013, 08:13 AM

The above code works fine for excel 2003 but why not for excel 2007.

Please help me out in this.

Thanks

**moonsaga** · 12-05-2013, 10:17 AM

maybe try this..

Please Login or Register  to view this content.

Re: Send an excelsheet using vba