Can I update a word doc and have the information save on a spreadsheet?

I have a letter which I send out regularly, changing only the date and one other detail. I record this information in a spreadsheet so that I know how many letters have been sent on a particular day. Is it possible to update the information on the word document, and have it save to the spreadsheet without actually going into the spreadsheet to update it? I think it's possible to do it the other way round, but I need to go into the word doc anyway to print it, so just looking for any shortcuts which may be possible!



Thank you!Can I update a word doc and have the information save on a spreadsheet?My suggestion is that, rather than try to make word update excel (which, frankly, would be a nightmare), have excel update word (easy).



I think what you need to do is use the mail merge feature of Word with the Excel spreadsheet as your data source (the place it pulls the data from to insert into your document).



Since it's a little tricky to set up I would suggest looking through google for advice on how to use an excel spreadsheet in a mail merge. Once set up, however, the operation is very simple. It would also be easier to update the spreadsheet by hand and send the info to Word than the other way around.



If you really want it to work the other way around (Word to excel), I would suggest looking up how to link a data field to excel.



I hope that this helps you.Can I update a word doc and have the information save on a spreadsheet?Yes, you can make a macro that will do it for you.



Here is a link to one I found online, but it saves the changes to a new word document.



http://www.thedoctools.com/index.php?sho鈥?/a>



This can be easily modified to add it to an existing Excel spreadsheet if you know VBA.