Subdivide worksheets and send with macros

[billy2willy]

Hi,

I have about 30 departments that I send month end information to in Excel. I have a Macro that divides the spreadsheets and sends each one through Microsoft Outlook to the destination email address. In the process of sending the worksheet it appears that the Macros don't send with the worksheet. I would like to send the other Macros I have programed with the worksheet. Below is the Subdivide and send macro. Any suggestions....

Please Login or Register  to view this content.

[Leith Ross]

Hello billy2willy,

Please wrap your code using code tags.

Sincerely,
Leith Ross