Emailing a record from an Access form

[ajh19742000]

Hello,
I am creating a database where I can add data in a form which is working fine. What I would like to achieve is have a button on the form which creates an email with the report as a pdf with just the current record on view (not all data) and the fields within the table as part of the email in the subject field and the main text of the email. I have created the report within Access but having difficulty with the code to achieve this. I have seen various methods online but all seem to have compiling errors with the VB windows.


Any help appreciated
Thanks

[CJ_London]

I have seen various methods online but all seem to have compiling errors with the VB windows.

no point in providing yet another variation which will no doubt also create compile errors since we don't know your setup. Suggest provide one of the examples you have tried and tell us the compile error(s).

Or take a look at the bottom of this thread where the same question has been asked several times

[Gicu]

Look into Docmd.SendObject method: https://docs.microsoft.com/en-us/off...cmd.sendobject
You will need to limit the report's record source to the current record displayed on the form by adding a reference to the record's unique ID:

SELECT * FROM qryReportRecordSource WHERE RecordID = Forms!frmYourForm!RecordID

Cheers,