Hi ,
I have a sheet with a dropdown list in it. Under dropdown 50 items are there and on every selection whole data gets change.
Its a dashboard of the performance of 50 different branches.
Range would be same.
I want to auto populate the sheets one by one and send them individually to different 50 mail ids via outlook.
Sheet should be paste in mail body (may be an image or simple pasting is ok).
So what code or trick is needed.
Plz help.
50 dashboard to 50 different branches. Each branch should get it's dashboard via mail. Under CC option is also required.
If PDF copy can also be attached will be good but its optional.
Thanks.
I have a sheet with a dropdown list in it. Under dropdown 50 items are there and on every selection whole data gets change.
Its a dashboard of the performance of 50 different branches.
Range would be same.
I want to auto populate the sheets one by one and send them individually to different 50 mail ids via outlook.
Sheet should be paste in mail body (may be an image or simple pasting is ok).
So what code or trick is needed.
Plz help.
50 dashboard to 50 different branches. Each branch should get it's dashboard via mail. Under CC option is also required.
If PDF copy can also be attached will be good but its optional.
Thanks.