Email on click from table with report attached

[nishant.dhruve]

Hi,
i want to have vba coding such a way that, when i click validate button on the form (screenshot attached for the from), it should send email to the person who are in username table without opening outlook with the report as an attachement.


Can anyone please help me on that.

[ranman256]

docmd.SendObject acSendForm ,"frmMyForm",acFormatPDF,sTo,,,sSubj,sBody