Email Worksheet CONTAINING a Macro?

[rcreek09]

Windows XP, Excel 2003.

I have a workbook with several sheets. Each sheet has a macro button. The macro is resident in this workbook, not my personal workbook. All works great.

Challenge:
I want to email each sheet independently to different recipients (using the RDB mail routines that are GREAT!). I do not want to have to save each sheet as it's own file then send.

Currently, when I send a single sheet, the buttons are of course useless because the macro is not going with the sheet.

Any ideas on how to get the macro to accompany each sheet? This is something I do on a weekly basis, so I need a 'system'.

Thanks so much!
Deb

 

[Andrew Poulsom]

You will have to save a copy of the workbook, open it and remove the unwanted sheets, then save and send it.

 

[Shalbriri]

http://www.rondebruin.nl/sendmail.htm

maybe this will help ?