VBA Script > Excel Values to email distribution list

[samibo]

Hi, I have a source table that feeds 20 pivot tables with sickness data. Each Pivot table gets sent to a department in an excel format.

Each month the source is updated and new reports are sent out.

Is there a VBA script that would send out the email for me, without me having to do it manually?

I have an email distribution list on seperate sheet that the code would need to pick from.

I'm not too confident with VBA so please be kind.

Thanks

Samibo

 

[Trevor G]

Check out the datapig tutorial to see if it helps you.

http://datapigtechnologies.com/ExcelMain.htm

Scroll down the list until you find Using Excel Macros

 

[samibo]

Thanks Trev