Send report automatically via email

First of all thanks to all Excel masters,

I need help to build such reports so that I can send desired reange from report to desired email ids automatically without doing manual labour.

Poinsts - Every month I prepare huge branch report in a single sheet, in which I have name of branches in a particular column, and I want report should auto deliver to concern email ids branch wise. But any branch should not receive report of other branchs.


Kindly let me know in case my points are not clear

Thanks Roy for the link..

If this does exist it will be a boon to so many people whose lives run on Excel as Mine does but unfortuantely not a pro..

In my previous organisation ( Lotus Notes) I could just Copy_Paste the Image of any Exel Table in the email for a first look..

But this is great!

Wish someone had an example!

Regards
e4excel