VBA / Macro to distribute different excel sheets via email using a distribution list
Posted on 2004-09-18
I have an excel report which is made up of different sheets for each cost centre. This report has to be emailed to people on a distribution list. However not everybody should get the same report;
I need email recipients to only receive the sheets that relate to them.
I need to automate this process as I am sick to death of doing it manually and creating a separate excel document containing the appropriate cost centre sheets for each manager! Please help a VBA novice!