Thanks for your reply Ron,
I have 26 cells of data in a row that I need to mail, from A to Z, I have to
send it as an excel attachment.

Thanks in advance

"Ron de Bruin" wrote:

Hi Sam

How many cells with data have a row ?

Do you want to send it in the body or in a workbook


"sam" schreef in bericht
...
Hi All,

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

What is happening is: this workbook that is emailed to me stores the user
inputs of each user in a separate row, and hence I am receiving the whole
workbook with inputs of all the users.

What I want: I want to receive just the current users data. I dont want
to
receive the entire workbook, but the data that has been inputted by the
last
user only. (For e.g. only the last row updated in the workbook) and not
whole
workbook.

Is there some code I can put in that will email me just the last user
input
and not the previous inputs?

Please help
I hope I made it clear

Thanks in Advance

__________ Information from ESET Smart Security, version of virus
signature database 4285 (20090728) __________

The message was checked by ESET Smart Security.

http://www.eset.com





__________ Information from ESET Smart Security, version of virus signature database 4285 (20090728) __________

The message was checked by ESET Smart Security.

http://www.eset.com