Data Validation - Client selects items then clicks SEND

[nlamey]

Hi there,

I have excel 07' w/office XP.

I created a simple one page form with drop down menus (using data validation) that my clients would select. I currently email this form to my clients whom in turn select the items, re-save, then email back to me.

Is there a way to embed this form in a webpage and in addition, add a "SEND" button. When the client clicks "SEND" then the selected data would be emailed directly to me.

I have researched this topic online, but can't find any solutions.

Thank you kindly,
Nicholas

 

[Tom Urtis]

Neither macros nor data validation work 100% reliably in an html platform, but your clients might benefit from either

(a) if they use Outlook and want to click a button that attaches the workbook and sends it to you, there are plenty of examples to show you that,

or

(b) they can click the Send To > Recipient option and send the workbook that way, saving a couple clicks of opening ther email client and attaching the workbook.

There are probably other options too, these are just a couple ideas.