Bookmark Ron's site for anything to do with Excel and emailing:
http://www.rondebruin.nl/sendmail.htm
:)
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

"Koolmist" wrote in message
...
Hey all,
I am extremely new to Excel and have been "tinkering" with it for
around
2 weeks now, and have come to the conclussion that i need to start
learning
macros. I have recently been given a task of making a worksheet that
gathers
data from multiple sheets and places that info into a single sheet once an
hour. Although the process I used was more than likely the least efficient
it
still works fine. The data is recorded for each hour and via formulas
populates a "Reports" sheet. I need to learn how to make a macro that will
copy a selection on the "Reports" sheet, paste it into a new e-mail and
sent
it from clicking on a single button. I figured out how to make a button
from
reading the posts in this forum, but am at a loss as to how to make a
macro
that will change sheets, select a range of cells,copy it, then open
Outlook,
make a new email, paste it, send it, and then return to the original
sheet,
but to cells below the ones previously filled in. Any and all assistance
would be greatly appreciated, as I am eager to see this sheet finally
finished.