Emailing excel sheet: Help Ron De Bruin



I have designed a excel userform with text fields and a submit button, I want
the user inputs to be emailed to me once users click on "submit"

Once users fill in the details in the excel userform and click the submit
button, I should get the email from the user and the user inputs should be an
excel file with just the current user inputs and buttons "Accept" and

Once I open the attachment and click "Accept" I want it to populate the
access database ( I have already done this). BUT what i really need is the
user input in a excel sheet (without any copies being saved on the hard drive
or anywhere else AND should have the Accept and Decline buttons).

I dont want to have a sheet with accept and decline buttons lying on the
shared drive as the users themselves will accept or decline their inputs.

Thanks in Advance




Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question