|If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.|
||Thread Tools||Display Modes|
auto-extract fields from word - auto-paste into excel at next row
Word document has info like name: ______ , phone number _______, company
_______ etc. (it isn't a phonebook, just has similar fields).
I want users (employees) to enter the information in word, and then have
word send out the info they type in to excel, and save as a database type
So for the example above, when users click save after typing in the info,
the info they type in goes to a certain excel file (not a new one) and puts
the info in the next available row. Column 1 would be Name, Column 2 would
be phone number etc...
I essentially want the users to use only word, but still maintain a database
for data input.
I thnk MS access can do this type of thing, but I'm sure word/excel can too.
Final example to get my point accross.
Input 1: Larry
Input 2: 123-456-7890
Input 3: California
Users enter inputs, then hit save. Upon save (in the background), an excel
file is updated (at the next availabe row) with :
Column 1, row x = Larry
Column 2, row x = 123-456-7890
Column 3, row x = California
The next time that same word document is opened and different info is
inputted, excel should add a row 'y', with the new info.
FYI: The word document is a professional page with professional looking
formating (this is our problem with access).
Any help would be appreciated!
|Thread||Thread Starter||Forum||Replies||Last Post|
|Fill-in field prompts||Deb McLellan||New Users||7||March 13th 06 09:43 PM|
|WP merge file to Word||sstires||Tables||4||February 14th 06 07:26 PM|
|question on checkboxes/protected forms and fill-in fields||Tracey||Microsoft Word Help||4||February 10th 06 11:04 PM|
|Inserting Excel tables into Word||Louise||Microsoft Word Help||13||November 1st 05 07:56 PM|
|Envelope Address||GR||New Users||5||April 24th 05 09:48 PM|