Is it possible to send just a worksheet, rather than the whole book, through a macro
Posted by Steve on April 29, 2001 1:54 AM
I have a small problem I was hoping somebody may be able to help me with. I am trying to write a macro that sends a worksheet to several e-mail addresses. My problem is that when i use
ActiveWorksheet.SendMail Recipients:="e-mail address here" it sends the whole workbook, rather than just the worksheet. Does anyone know if it is possible at all (i need to do this because the whole workbook is way too large to send, therefore i am just trying to send the 1 worksheet, within the workbook).
Thankyou in advance