In addition to Martin's code you may also want to have a look here for more
information on e-mailing from excel

http://www.rondebruin.nl/sendmail.htm#Tips
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"ChuckF" wrote in message
oups.com...
Each day I take attendance for my group here at work. Is there a way
to create a macro that would emulate me hitting "File, Send To, Mail
Recipient, and enter the word "Attendance" (my distribution list) in
the TO: column.