Inserting an excel table in mail body

**Raghukumarn** · 04-24-2014, 12:21 AM

Hi Team,

I have written a small macro which uses the static data provided in the excel spreadsheet and generates a new mail and displays the same.

Macro is able to capture all the information required except for the table in the range("A6:D27").

Attached is the sample file for the same, request anyone's assistance in fixing the sameassistance.

Regards,
Raghu

**jaslake** · 04-29-2014, 01:31 PM

Hi Raghukumarn

Try this

Please Login or Register  to view this content.

**Raghukumarn** · 05-10-2014, 04:23 AM

Hi Jaslake,

Apologies for the late response. Was out of station for few days.

Your code works exceptionally well and serves the purpose. Thanks a lot.

Regards,
Raghu

**jaslake** · 05-10-2014, 08:48 AM

You're welcome...glad I could help.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

If this resolves your issue please mark your Thread as SOLVED.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save