Example Code for sending mail from Excel
http://www.rondebruin.nl/sendmail.htm

Using VBA in Excel to Send Workbooks and Ranges through E-Mail with Outlook (Part 1 of 2)
http://msdn.microsoft.com/en-us/library/ff458119(office.11).aspx

Using VBA in Excel to Send Workbooks and Ranges through E-Mail with Outlook (Part 2 of 2)
http://msdn.microsoft.com/en-us/library/ff519602(office.11).aspx

Working with Excel Workbooks and Worksheets in E-Mail (97-2010)
http://msdn.microsoft.com/en-us/library/bb268022.aspx

Creating and Sending PDF Files from Excel 2007 and Excel 2010
http://msdn.microsoft.com/en-us/library/ee834871(office.11).aspx

Different Ways to Take Advantage of the E-mail Features of Excel (97-2003)
http://msdn.microsoft.com/en-us/library/aa203718(office.11).aspx
 
Sending mail from Lotus Notes
http://www.rondebruin.nl/notes.htm
 
Automating Outlook with Excel (Dick Kusleika)
http://www.dicks-clicks.com/excel/olAutomating.htm

Code For Excel And Outlook
http://www.codeforexcelandoutlook.com/excel-vba/send-email-from-excel/

Sending Mail from MacXL (J.E. McGimpsey)
http://www.mcgimpsey.com/macoffice/excel/macexcelsendmail.html
 
Sending Personalized Email from Excel(John Walkenbach)
http://www.j-walk.com/ss/excel/tips/tip86.htm

  
Microsoft knowledge base articles

Knowledge base articles ( all Excel versions )
Click here

Knowledge base articles ( Excel 2007 )
Click here

Knowledge base articles ( Excel 2003 )
Click here
 
Knowledge base articles ( Excel 2002 )
Click here
 
Knowledge base articles ( Excel 2000 )
Click here
 
Knowledge base articles ( Excel 97 )
Click here