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