Excel 97 Send To
 

Hi all

Not really a programming question but wasn't sure where to post.

A colleague has published an excel worksheet to our intranet. Her aim is to have users complete the worksheet which is in effect a fault log. She then wants them to use the send to command on File menu to mail it to her. Her question to me was was is there a way for users to send their completed fault log without actually saving the file somewhere. Currently when they complete the log and use send to, she receives a blank copy of the worksheet.

I am really looking for some advice on the best way to implement her aim with as little work/hassle as possible for the users.

Would be grateful for any help.

Many thanks
Michelle