Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / September 2007

Tip: Looking for answers? Try searching our database.

VBA code to email 1 worksheet in a workbook

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lisab - 13 Sep 2007 22:18 GMT
VBA code to email 1 worksheet in a workbook -

I would like to code a function that will email one worksheet in a multi
sheet workbook.  I know you can use the SendTo option on the file menu to
send the current sheet to a reciepient as the email body.  However, I would
like to know the VBA code that will do the same thing and allow you to enter
the name of the worksheet you want to send.

Any help will be greatly appreciated
Thanks.
Ron de Bruin - 13 Sep 2007 22:23 GMT
Hi Lisab

See the examples on my site
http://www.rondebruin.nl/sendmail.htm

You can use the example workbooks to test the code

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> VBA code to email 1 worksheet in a workbook -
>
[quoted text clipped - 6 lines]
> Any help will be greatly appreciated
> Thanks.
Lisab - 14 Sep 2007 15:22 GMT
Thank you very much!

> Hi Lisab
>
[quoted text clipped - 13 lines]
> > Any help will be greatly appreciated
> > Thanks.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.