emailing worksheet

[Guest]

I use this code to email a workbook:
Sub SendIt()
Application.Dialogs(xlDialogSendMail).Show _
arg1:="email address", _
arg2:="subject"
End Sub
The questions I have are, how can I just send one worksheet instead of the whole workbook?

And, I have outlook and express on my computer, will or how can this work on other email software,ie.AOL,Lotus Notes?

Thanks,

 

[y2k]

I use lotus notes. I just tried it and it works! I can't say I'd ever have been able to come up with that code and I think it's pretty cool! I see somebody else has a question regarding how to do this at http://www.mrexcel.com/board/viewtopic.php?topic=1594&forum=2&0. Maybe you could help?
This message was edited by y2k on 2002-03-08 02:50

 

[Dave Hawley]

Hi

All you need to do is use some code like:

Sheet1.Copy

This (by deafault) will create a copy of your Worksheet in a Workbook that only contains the one sheet.