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

you're not clear here - is the userform data stored separately ? its should
be raltively painless to save the data into another - say timestamped -
workbook in a particular folder, prior to any processing as soon as submit
was clicked. that would make life a lot easier





"sam" wrote in message
...
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

Thanks for the help patrick, the userform data is stored in the same
workbook. Is there a way to email just the current user input (for eg, the
last row updated in the workbook) and not old data?

For eg, the workbook stores all the user inputs, each user inputs are stored
in a new row such as:

Name Address Phno Zip
pat 1 s dr 12345
neal 2 n dr 33434
sam 3 w dr 34344

What I want is: when neal inputs his info through the user form, I want his
info to be mailed and not pat and neals

when sam inputs his info through the user form, I want sams info to be
mailed and not pat, neal and sams.

Rite now its mailing the whole workbook, is there a way to mail just the
users info?

Hope I made it clear

Thanks in Advance




"Patrick Molloy" wrote:

you're not clear here - is the userform data stored separately ? its should
be raltively painless to save the data into another - say timestamped -
workbook in a particular folder, prior to any processing as soon as submit
was clicked. that would make life a lot easier





"sam" wrote in message
...
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

You can take a look at some of Ron's code for email. Maybe you can get an
idea from that:

http://www.rondebruin.nl/sendmail.htm



"sam" wrote in message
...
Thanks for the help patrick, the userform data is stored in the same
workbook. Is there a way to email just the current user input (for eg, the
last row updated in the workbook) and not old data?

For eg, the workbook stores all the user inputs, each user inputs are
stored
in a new row such as:

Name Address Phno Zip
pat 1 s dr 12345
neal 2 n dr 33434
sam 3 w dr 34344

What I want is: when neal inputs his info through the user form, I want
his
info to be mailed and not pat and neals

when sam inputs his info through the user form, I want sams info to be
mailed and not pat, neal and sams.

Rite now its mailing the whole workbook, is there a way to mail just the
users info?

Hope I made it clear

Thanks in Advance




"Patrick Molloy" wrote:

you're not clear here - is the userform data stored separately ? its
should
be raltively painless to save the data into another - say timestamped -
workbook in a particular folder, prior to any processing as soon as
submit
was clicked. that would make life a lot easier





"sam" wrote in message
...
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