comp.lang.python

JLGWhiz

7/28/2009 12:55:00 AM

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/se...



"sam" <sam@discussions.microsoft.com> wrote in message
news:A3C6C454-9C59-4A6C-979A-A6EB06E42036@microsoft.com...
> 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" <sam@discussions.microsoft.com> wrote in message
>> news:1E9D23A8-BD91-466D-A678-3EA71B1B02AC@microsoft.com...
>> > 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
>>
>>