Hi Maury

Try
http://www.rondebruin.nl/mail/folder3/mail4.htm


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


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

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

Activeworkbook.SendMail Recipient:= , Subject:=

I take it back, this does NOT work. It sends the entire book as an
attachment. What I want is the selection to appear inside the mail message,
as it would when I used Send To.

I looked at the docs on the SendMail method, it appears to have no switches
and can only be applied to the workbook object, not a sheet or selection.

Ideas?

Maury