Yes, thats the ticket.........essentially we were at that point, but unable
to figure out how to make the "new" workbook send out by email from a macro
in the original workbook.........any help there would be appreciated.......

Vaya con Dios,
Chuck, CABGx3







"mudraker " wrote in message
...
Personally I would have the macro in the workbook that has all your
other macro's.

Build the macro to create a brand new workbook, copy the required data
into the new workbook then send the new workbook by email.

This way no macros are sent and the receiver does not have to worry
about the validity of any macro's.


---
Message posted from http://www.ExcelForum.com/