Form email button

Khushalay

Registered User.
Local time
Today, 09:30
Joined
Apr 16, 2016
Messages
180
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.
 
(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 :
Code:
sub button1_Click()
    docmd.SendObject acSendForm ,"frmMyForm",acFormatPDF,txtTO,,,txtSubj,txtMsg
end sub
 
(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 :
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?
 
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.
 
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.
 

Users who are viewing this thread

Back
Top Bottom