Retaining button functionality in PDF

[rik1603]

Hi All,

I have an Excel sheet which is essentially a quote form which pulls through data from the second tab.

Everything works well however I am trying to add a button to the sheet which emails the quotation sheet back to us with the subject text saying something like go ahead.

Inside Excel I have managed to make this work fine however where I am failing to find a solution is when the sheet is PDF'd to send to the customer the functionaly of the button stops working.

Anyone have any ideas on how to overcome this or an alternative solution to have a 'Proceed with quote' button on the PDF?

Thanks for your help!

 

[rik1603]

Anyone got any ideas? This one is really proving difficult

 

[West Man]

I don't think you will find any Excel functionallity in a PDF. It is just an image

 

[rik1603]

My only success so far has been to use a HTML mail to and put it behind an image button, this works fine in PDF however I cannot seem to get any type of identifier into the HTML code.

If I can pull any type of quote number into the subject of the HTML mail to code it would be perfect! Anyone able to do this?

 

[rik1603]

I have tried using the & function to get try and spilt up the html code and insert the quote number but Excel doesn't seem it like it