Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

How can I transfer data from one msword doc to another

Jul 1, 2009 6:23PM PDT

We have a MSword2003 form that new eyeglass patients fill out in our office, it includes fill in the blank areas for name, address, doctor etc., and then numerous check boxes for health symptoms, such as headaches, dizziness, blurred vision, etc.

We take the information from the generic form and manually create a specific report for that patient, such as patient "smith" complains of "headaches, dizziness, and blurred vision" (based on the responses from the form).

The question is how can we automatically populate information in the new report, using available microsoft functions, with data from the generic form with a minimum of editing? (or is that too much to ask of word?)

Discussion is locked

- Collapse -
Re: transferring data
Jul 1, 2009 6:27PM PDT

Several solutions.

1. Copy/paste manually when creating the patient-specific report.
2. Write a macro to do the copying. But it will need some rather strict standards for the format of the source-documents to be feasible. If the source is free text and the target a form, it's impossible.
3. Use database-based software in stead of text-processing software.

It's up to you.

Kees

- Collapse -
Thanks for the suggestions
Jul 1, 2009 6:54PM PDT

Thanks for the ideas:

1. Copy/paste manually when creating the patient-specific report.

(Not what we want, we already do this, we are going to automate somehow)

2. Write a macro to do the copying. But it will need some rather strict standards for the format of the source-documents to be feasible. If the source is free text and the target a form, it's impossible.

(I have never done this, but I can if someone will point me in the right direction with some examples, the source-doc is a MSword form doc with fill-in blanks and checkboxes that could easily be referenced, I'm sure)

3. Use database-based software in stead of text-processing software.

(sounds promising, but more elaboration please, I have a computer background, but no real experience with msoffice products, I'm sure I can do whatever is necessary with some guidance)

- Collapse -
I still need help
Jul 2, 2009 6:17AM PDT

Any specific help with the above suggestions is greatly appreciated (macro creation/automation help, or database referencing and use in document creation)

- Collapse -
data transfer between documents
Jul 3, 2009 3:01PM PDT

From the lack of replies, I'm guessing that no one has knowledge of a easy answer/solution, so I'll try something else.

- Collapse -
a better forum
Jul 10, 2009 1:00AM PDT

Go to www.wordbanter.com if you want some REAL msoffice help. I found all the info I needed there.