 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2004One worksheet through mail
Hi I had a excel file containing 5 worksheets. I need to send someone only the 2nd worksheet through e-mail. How can i send it? Please suggest. Hi have a look at http://www.rondebruin.nl/sendmail.htm#Sheet  SignatureRegards Frank Kabel Frankfurt, Germany > Hi > I had a excel file containing 5 worksheets. [quoted text clipped - 4 lines] > > Please suggest. Isn't there some simpler solution... > Hi > have a look at [quoted text clipped - 13 lines] > > > > Please suggest. Hi Deepak! It doesn't get much simpler once you have downloaded and installed Ron's SendMail Addin. It puts a SendMail Entry on your Tools menu Select the sheet you want to send Tools > SendMail Select "Send Active Sheet Go Thereafter it's straightforward filling in of details of addressee. You can also download a User Guide should you need help installing an addin or with finer points on all of the options available. SignatureRegards Norman Harker MVP (Excel) Sydney, Australia njharker@optusnet.com.au Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. > Isn't there some simpler solution... > [quoted text clipped - 15 lines] > > > > > > Please suggest. Hi I found Ron's add-in quite simple (once you have installed it). also his user guide is very good) Signature-- Regards Frank Kabel Frankfurt, Germany > Isn't there some simpler solution... > [quoted text clipped - 15 lines] >>> >>> Please suggest. > Isn't there some simpler solution... Remember also that a worksheet isn't a physical unit, all sheets goes into a single Excel xls file. You can't email a fifth of that binary data and expect it to behave when it arrives. Best wishes Harald Ron's solution once installed will give you such a simple method of transferring data you won't know how you did without it. It is honestly well worth taking a few minutes to get it on - and by all means post back for help if there is anything about how to do that that you are unsure of, and we'll happily walk you through step by step. SignatureRegards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- > Isn't there some simpler solution... > [quoted text clipped - 15 lines] > > > > > > Please suggest. Hi Here is an easy way Sub SendOneSheet() Sheets(2).Copy Application.Dialogs(xlDialogSendMail).Show End Sub Manually, you could right click on that worksheet tab, select move or copy. Move or copy it to a new workbook (If you move it, remember to close the original file without saving!). And then send that new workbook. If you have formulas that refer to other worksheets, you may want to convert the formulas to values before sending. > Hi > I had a excel file containing 5 worksheets. [quoted text clipped - 4 lines] > > Please suggest. SignatureDave Peterson ec35720@msn.com |
Reply to this Message |
 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.