Form to populate Excel worksheet and Word document

[AkaShade]

I have an Excel 2007 worksheet that I enter customer data into and from that a portion of the data is entered into a contract in Word 2007. Currently I have linked data from the Excel worksheet to the Word document but it only works on my computer unless I update the many links on each of the machines that it needs to be available on. Alternatively, I can set the root of the two files to C:\ but I’d like the documents to be usable by anyone; some of which I know to be computer illiterate, and I’d like it to be emailable if at all possible. I also have SharePoint and understand that I can place this all in a document library. I recently began researching VBA and XML but I haven’t had much time behind the keyboard on these. I’d like to not only have a clean and professional looking form that can be filled out buy "anyone" but also have the option of having the two documents automatically emailed once generated. Am I biting off more than a novice can chew? Is there a simpler way to accomplish this with XML via Excel/Word 2007? If not, can this even be accomplished with VB Express 2005? Any help or guidance would be greatly appreciated!