You can use the method "SendObject".
sintax:
DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][, bcc][, subject][, messagetext][, editmessage][, templatefile]
Please see the access help to further information.
Rafael Sardinha