Form email button

[Khushalay]

Hi thr

I want to know if I can get an email form button on my access form.
I have an access form and sometimes I would need to email via outlook a particular form. I want a button for that.

Kindly help me out.

 

[Ranman256]

Docmd.sendto

Use the acForm option

 

[Khushalay]

Docmd.sendto

Use the acForm option

Can u plz elaborate. Whr is that function n how to use. Im not too well versed with Access

 

[Ranman256]

(oops, i said SendTo, but its actually SendObject)

place button on form
in the event property, ON CLICK event, click the EXPRESSION option
in the example below the form name is called 'frmMyForm"
in the code :

sub button1_Click()
    docmd.SendObject acSendForm ,"frmMyForm",acFormatPDF,txtTO,,,txtSubj,txtMsg
end sub

 

[Khushalay]

(oops, i said SendTo, but its actually SendObject)

place button on form
in the event property, ON CLICK event, click the EXPRESSION option
in the example below the form name is called 'frmMyForm"
in the code :

sub button1_Click()
    docmd.SendObject acSendForm ,"frmMyForm",acFormatPDF,txtTO,,,txtSubj,txtMsg
end sub

Thanks for that code. i tried that but it send all the records whereas I only want the current/ opened record to be emailed.

Any solution for that?

 

[GinaWhipp]

That is a problem with DoCmd.SendObject you cannot send just the current record. There is a way to do this with a Report but not with a Form.

 

[Khushalay]

any way around?

 

[GinaWhipp]

Only if you plan on using a Report, not sure why you would want to send a Form anyway as they are meant for data changes not for reporting.