Vba send an email

Hi Emma

If you wish to email the current workbook to a colleague or anyone else then the following line of code will do exactly that:

ActiveWorkbook.SendMail Recipients:="theirname@theircompany.com", _
Subject:="Latest Accounts"

This creates a new e-mail with the above address and Subjent line and the workbook attached.

Hope this helps

Carlos