Multiple worksheet content in one mail body

[aabhi2251]

Hi,


I require an urgent VBA help:


I have a workbook which has 3 sheets in it..In sheet1 range A1 to D20 is filled..In sheet2 range A1 to e20 is filled and In sheet1 range A1 to D20 is filled..


Now i have my requiremnt is I want a macro which will create a mailbody of outlook which has content of this three sheet ...one below another..


I mean in mailbody first sheet1 range a1 to d20 content then below it sheet2 then below it sheet3...like wise in one mail body..


Please help its an urgent requiremnt of macro...