Can use SendObject method to create simple email, like:
DoCmd.SendObject , , , "email address here", , , "subject here", Me.Notes
There are more complex code structures that allow more control over the email content.
Email is common topic.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.