In code create a new single sheet workbook
paste in your data

Activeworkbook.SendMail Recipient:= , Subject:=


--
Regards,
Tom Ogilvy

"Maury Markowitz" wrote in
message ...
I'm trying to make a macro to send out a spreadsheet every night. The
manual
operation consists of selecting the active range, then using Send To from
the
File menu and filling out an e-mail address.

When I try to record these steps as a macro, the resulting code only
contains the selection action. The Send To doesn't appear!

Anyone know what's going on here?

Maury