Outputting the information to Access would be more appropriate.
See the last in the following series of articles:
http://www.mousetrax.com/techpage.html#autoforms
Please Fill Out This Form
Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22
Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46
Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119
Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127
Part 5: Connect your AutoForm to a database to save input time and keep
better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
"Dylan" <Dylan.TakeThisOut@discussions.microsoft.com> wrote in message
news:CD4798BC-84A5-4C60-A057-26F1B091CE7F@microsoft.com...
>I have a word document with a userform that populates fields in the
>document.
> Is there a way to also populate an excel spreadsheet with the same data
> from
> the userform?
>
> The word document is a contract document and the userform inputs
> information
> such as price, start date, completion date, risks, etc. I already have a
> spreadsheet set up where the user can manually input the details of the
> new
> contract, but it would be extremely useful, if I could use the word
> userform
> to automatically input the details into a new row.
>
> Can anyone point me in the right direction on how I would go about setting
> this up?
>
> Kind regards
> Dylan
Microsoft Office