I’m using Excel 2000 and would like to sent one sheet only. I found this code (for Excel 2002) when searching but I get an error message on the 3rd line. This is exactly what I need. Can you help this novice? Thanks.
sheets("sheet1").copy
activeworkbook.sendmail
recipients:="email_address@hotmail.com", Subject:="Testing"
sheets("sheet1").copy
activeworkbook.sendmail
recipients:="email_address@hotmail.com", Subject:="Testing"