I need a macro to assign to a button that will send a sheet of a workbook as an attachment to certain contacts via Novell Groupwise and it needs to have the sheet name as the subject line. Any ideas?

Also need a macro that will select a certain range of cells to copy and paste as the body of an email with a certain subject line to send to certain contacts via Novell Groupwise.

Thanks!