User Forms and Sending E-mails

[zak]

Hi

I was hoping whether anyone can help me with the following:

1) I've created a user form in Excel 2007 to allow visitors to book an
appointment. All they are required to do is enter data into 4 text boxes
(1.name 2.laptop name 3.Date 4.Time.

- The name should go into cell ref A4 in worksheet 2
- The laptop name should go into cell ref B4 in worksheet 2
- The Date should go into cell ref C4 in worksheet 2
- The Time should go into cell ref D4 in worksheet 2

Please let me know how I can do this? In addition to entering the text, I
would like the Date and Time to be validated so that they are entered in
acceptable formats i.e. Date can only be entered like this - dd/mm/yy, and
time can only be entered like this - HH:MM. Is there anyway I can set this
kind of validation up on the actual field where the date and time are entered?

2) Once the details above have gone into a spreadsheet, how can i e-mail the
details (only that new row) to people. Is there any kind of way to email
rows in spreadsheet to people as opposed to emailing them the whole worksheet?

Any help or suggestions will be GREATLY APPRECIATED.

Many Thanks