emailing worksheet

Mar 7th, 2002, 09:40 AM

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 · Mar 8th, 2002, 03:49 AM

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/viewtop...1594&forum=2&0. Maybe you could help?

[ This Message was edited by: y2k on 2002-03-08 02:50 ]

Dave Hawley · Mar 8th, 2002, 04:01 AM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 7th, 2002, 09:40 AM	#1
Guest Posts: n/a	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,

Mar 8th, 2002, 03:49 AM	#2
y2k Board Regular Join Date: Feb 2002 Location: Ireland Posts: 133	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/viewtop...1594&forum=2&0. Maybe you could help? [ This Message was edited by: y2k on 2002-03-08 02:50 ]

Mar 8th, 2002, 04:01 AM	#3
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	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.