Send Sheet as part of macro

[Joe S.]

The final barrier I'm running into in my quest for
automation of my reports is emailing them properly.
Currently I email my reports within Excel, using
the "Send this sheet as part of the body of the email"
option.

I'm wondering if this operation can be performed within a
macro. Right now I'm using the "ActiveWorkbook.SendMail
Recipients:=" command in vb, but this sends the mail as
an attachment. I could edit my macro to trim the file
down to the nessary data, but I'd rather continue to send
the report the way I always have been.

Any help is appreciated.

Thanks tons for all the help.
Joe

 

[Bob Phillips]

Joe,

See Ron's site at

www.rondebruin.nl/sendmail.htm

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)