Email from

[gor]

Hi There,
I have created a button that looks up a query then emails the from data as a pdf report to the person listed in the code below. Is it possible where the email is, to instead use the email address in one of the fields in the form itself. I can do this via VBA in word but do not know the code well enough in Access to perform the same job.

Private Sub Command82_Click()
DoCmd.SendObject acSendReport, "EmailQ", "PDF", jo@jabc.com.au, , , "From the Hive", "Please advise on the following", False
End Sub

thanks,
Gordon

[pbaldy]

Sure

DoCmd.SendObject acSendReport, "EmailQ", "PDF", Me.EmailAddress , , , "From the Hive", "Please advise on the following", False

Where "EmailAddress" is the name of the control (like a textbox) with the email address in it.