Hi All,

I have a userform that accepts user inputs and emails it to me once users
click "Submit". before being emailed they are stored in a workbook on shared
drive.

What is happening is: this workbook that is emailed to me stores all the
data that users input through userform, and hence is emailing me the whole
workbook with all data.

what I want: I want to reveive just the current users data. I dont want to
receive the entire workbook, but the current data that has been inputed by
the last user only.

I hope I made it clear

Thanks in Advance