Currently we have an URL for each row of a pivot table. Where a click on the URL open outlook and allow users to request a report via helpdesk.
Now we would like to change it to submit the request to the database where we have a automated program which take the request from database and send the data via email to the end user.
This can be achieved if we can run a macro to submit the request to database via the field in Pivot table.
Is this possible? Has any one done this before? Please provide ideas or suggestions to implement this.
