Hi all
I have got a report that I view that I would like to be able to Email, currently I have a macro button when clicked goes into a PDF file to Email etc but ideally need it in the body of an Email, I understand I probably need to make an Email template to do this but I have no idea where to even start with this can someone give me some guidance.
Example Database Details
Database Name: ExampleDatabase.accdb
TableName: TBLExampleDetails
ExampleField1 (AutoNumber)
ExampleField2
ExampleField3
QueryName: QRYExampleDetails
ExampleField1
ExampleField2
ExampleField3
ReportName: RPTExampleDetails
ExampleField1 - Send To Email Body
ExampleField2 - Send To Email Body
ExampleField3 - Send To Email Body
Thanks In Advance
I have got a report that I view that I would like to be able to Email, currently I have a macro button when clicked goes into a PDF file to Email etc but ideally need it in the body of an Email, I understand I probably need to make an Email template to do this but I have no idea where to even start with this can someone give me some guidance.
Example Database Details
Database Name: ExampleDatabase.accdb
TableName: TBLExampleDetails
ExampleField1 (AutoNumber)
ExampleField2
ExampleField3
QueryName: QRYExampleDetails
ExampleField1
ExampleField2
ExampleField3
ReportName: RPTExampleDetails
ExampleField1 - Send To Email Body
ExampleField2 - Send To Email Body
ExampleField3 - Send To Email Body
Thanks In Advance