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.
Thank you
Venkatesh
