Yes that was Tom's suggestion

I posted also two links that do that

http://www.rondebruin.nl/mail/folder1/mail4.htm
Or
http://www.rondebruin.nl/mail/folder2/mail4.htm

And see this for info about the security warning
http://www.rondebruin.nl/mail/prevent.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Maury Markowitz" wrote in message
...
"Tom Ogilvy" wrote:

You said you want to send a spreadsheet every night.

What I suggested would send a single sheet workbook/spreadsheet with just
the active range. (possibly you can't implement the suggestion)

Just to be sure I understand this statement, your code would make a workbook
with a single sheet in it, and mail that as an attachment, correct?

Maury