Email from Access with field name in subject 1

[Garridon]

I have an email link on a form so that the user can email the control office with any questions about a specific record. I know that in web sites you can add text for the Subject line into the email link. Can this be done for the email link, using a field from the form, like for instance, a reference to the specific record number?

Linda Adams
Visit my web site for writing and Microsoft Word tips:

http://www.hackman-adams.com

http://www.david-hedison.com

 

[bluekestrel]

Linda

Yes this is possible - Instead of an e mail link use a command button on your form. Put code behind the command button to e mail the form.

Private Sub EMailYourForm_Click()
On Error GoTo Err_YourForm_Click

Dim stDocName As String

stDocName = "Your Form Here"
DoCmd.SendObject acForm, stDocName, acFormatHTML, , , , "Enter Subject Here"

Exit_EMailYourForm_Click:
Exit Sub

Err_EMailYourForm_Click:
MsgBox Err.Description
Resume Exit_EMailYourForm_Click

End Sub

If you want a different subject every time and want to pull it from a field in the form then replace "Enter Subject Here" with Me![YourForm][YourField]

It would also be possible to extract the e mail address of the recipient and also a CC address if you wanted a copy to an administrator etc. Just look up the SendObject properties in help for a detailed list of options.

Hope this helps

Blue Kestrel