Excel and Word - Second Post

[Guest]

I have no idea if this can be done - I have inherited some Word templates for inter-office communications (basically, memos). I would like to store in Excel directly from the Word document a number identifying the memo, the date, the subject, who the memo was sent to (To: ?) and who sent the memo (From: ?).

If this can be done, I would also need to be able to have Excel increment to the next row for each new memo.

Can this be done?

Thanks in advance,
Robbie

 

[Steve Yandl]

When are you wanting this information to be extracted? Are the templates
already filled out and saved as documents sitting in some folder? Are you
wanting to get information from everybody in your office or just your
machine? Are you wanting to log the memos you prepare on your PC using
templates (my guess) and record them in Excel as you save them as docs?

Steve

I have no idea if this can be done - I have inherited some Word templates

for inter-office communications (basically, memos). I would like to store
in Excel directly from the Word document a number identifying the memo, the
date, the subject, who the memo was sent to (To: ?) and who sent the memo
(From: ?).

If this can be done, I would also need to be able to have Excel increment

to the next row for each new memo.

 

[Guest]

Thanks for your response Steve. I have Word templates and an Excel file on a public drive. The user would copy a template into a folder, enter the information and save the file. At this point I would like to store information from several fields into the Excel file. The purpose: quality system requires a log; also the log makes it easier to find a particular memo at a later date - which I guess leads me to another field I would like to automatically store, a hyperlink back to the saved memo.

Thanks,
Robbi

----- Steve Yandl wrote: ----

When are you wanting this information to be extracted? Are the template
already filled out and saved as documents sitting in some folder? Are yo
wanting to get information from everybody in your office or just you
machine? Are you wanting to log the memos you prepare on your PC usin
templates (my guess) and record them in Excel as you save them as docs

Stev

I have no idea if this can be done - I have inherited some Word template

for inter-office communications (basically, memos). I would like to stor
in Excel directly from the Word document a number identifying the memo, th
date, the subject, who the memo was sent to (To: ?) and who sent the mem
(From: ?)