I have different departments (about 18) that I report on, but have them combined in one workbook. I would like to send them the applicable worksheet as an attachment and just the worksheet that applies to them. Is there some way I can load a different email address for each worksheet, press a button and have them all sent at once, only containing the applicable information for their department?