I would like to be able to put a UserForm in Outlook (2003) that the user sends to an excel file so that the excel file is updated. The story behind this is that there is a file that needs to be updated frequently in hot weather: the person who is in charge updating this file currently has to find the correct file (based on the date), put the latest observation in, and then do a copy & paste of some other information. The only actual new information is the number she inputs - the rest can be automated. (The reason I am looking at "e-mailing" to l,kkkka file (rather than a person) is that I am sure the user would have her Outlook up and running the whole time and would be more comfortable with an Outlook form than an excel form.)

My question is: can this be done? If it can, could I please have one or two pointers to set me in the right direction?

(If it can't be done, I could create an excel file that consists of a UserForm & a code to update the appropriate file.)