Create Weather Report Dashboard and Send Email

Dear Sir,

I am trying to create a weather Dashboard report and save PDF to send Email to all my Managers.

I took some code in forum to create PDF and sending Email list in Email Sheet. i can able to create PDF on Today date by filename but i cant able to send outlook with file attachment not attached also Email address of To & CC.

Kindly please help to modify or give me a new solution to create PDF file & send email.

Moreover if possible for Great help to create a Dash board of weather report sample picture i attached in file.

Data Sheet: if i enter the values in data sheet to display in weather Report dashboard on daily basis. please give your idea how to make it.



I trying to post the code but its getting error to Sucuri WebSite Firewall - Access Denied.
i attached the excel file too.


http://www.vbaexpress.com/forum/show...417#post400417

Thanks,

Hi
you can post the code, but be careful to leave a space before the < or > characters. Sucuri does not like them