I am pretty new to using MS Access and Sharepoint etc, so your help is greatly appreciated.
I have setup a basic system on Access that allows you to log a technical support ticket on Sharepoint Web App.
When a new ticket is added to the system I have it setup to send an email. However I would like the body of email to contain the Ticket Number, which is Field Name 'ID'.
To: My email address
Subject: Ticket Number: [ID] has been added to the system.
Body: Please review ticket Number: [ID]
I have searched the net and found lots of information about using
SetLocalVar etc but I am struggling to understand it.