| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging data from multiple forms w/multiple fields into one databa
Hello nice people - At my job we do a lot of phone interviews, and we
generally take notes in Word documents as we go. The interviews are structured, so there are specific questions we ask in a specific order. There might be 30 interviews for a given project, each in its own Word document, each document with the same questions in the same order. After the interviews are all done, we need to analyze them, and I'd like to be able to quickly merge all of the interview documents into one Word document that's organized by question. So, all the answers to question 1, then all the answers to question 2, etc., in the same order as they appear in the interview questionnaire. Right now I have to cut and paste the answers from multiple interviews into one document by hand and it's very tedious and time-consuming. Is there a way to automate this using forms and mail merge? I've looked at other questions and answers in this forum and in FAQs on the Microsoft site, and can't find an answer. Any help is greatly appreciated! Thanks, Chris C. |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Merging data from multiple forms w/multiple fields into one databa
See the following page of fellow MVP Graham Mayor's website:
http://www.gmayor.com/extract_data_f...milar_docs.htm -- 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, originally posted via msnews.microsoft.com "Chris C." Chris wrote in message ... Hello nice people - At my job we do a lot of phone interviews, and we generally take notes in Word documents as we go. The interviews are structured, so there are specific questions we ask in a specific order. There might be 30 interviews for a given project, each in its own Word document, each document with the same questions in the same order. After the interviews are all done, we need to analyze them, and I'd like to be able to quickly merge all of the interview documents into one Word document that's organized by question. So, all the answers to question 1, then all the answers to question 2, etc., in the same order as they appear in the interview questionnaire. Right now I have to cut and paste the answers from multiple interviews into one document by hand and it's very tedious and time-consuming. Is there a way to automate this using forms and mail merge? I've looked at other questions and answers in this forum and in FAQs on the Microsoft site, and can't find an answer. Any help is greatly appreciated! Thanks, Chris C. |
|
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Merging data from multiple forms w/multiple fields into one da
Thanks Doug. I think this may help, though if I read the page correctly, the
end product of the macro would be individual rows in a database for each response to one question. So I'd need to have a different macro for each question in the interview questionnaire, and different files with the aggregated responses, each one in its own row. So I'd need to do more processing to get all of the responses to a given question into one cell, and then all of those cells into one document. Am I understanding that correctly? My larger problem is that I have yet to work with macros, so I'll need to figure out how to even use the macro on Graham's site, but that's another issue.... Thanks, Chris C. "Doug Robbins - Word MVP" wrote: See the following page of fellow MVP Graham Mayor's website: http://www.gmayor.com/extract_data_f...milar_docs.htm -- 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, originally posted via msnews.microsoft.com "Chris C." Chris wrote in message ... Hello nice people - At my job we do a lot of phone interviews, and we generally take notes in Word documents as we go. The interviews are structured, so there are specific questions we ask in a specific order. There might be 30 interviews for a given project, each in its own Word document, each document with the same questions in the same order. After the interviews are all done, we need to analyze them, and I'd like to be able to quickly merge all of the interview documents into one Word document that's organized by question. So, all the answers to question 1, then all the answers to question 2, etc., in the same order as they appear in the interview questionnaire. Right now I have to cut and paste the answers from multiple interviews into one document by hand and it's very tedious and time-consuming. Is there a way to automate this using forms and mail merge? I've looked at other questions and answers in this forum and in FAQs on the Microsoft site, and can't find an answer. Any help is greatly appreciated! Thanks, Chris C. |
|
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Merging data from multiple forms w/multiple fields into one da
Yes, the macro would need to be modified to achieve your desired result, but
it does give you a starting point. A bit more information on exactly how your documents are structured would be necessary to tell you exactly what the modifications should be. I would be thinking along the lines of having a document set up to receive all of the responses, with separate tables in that document to hold all of the answers to each question then as each question in each response document was processed, a row would be added to the corresponding table and the response would be inserted into that row. -- 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, originally posted via msnews.microsoft.com "Chris C." wrote in message ... Thanks Doug. I think this may help, though if I read the page correctly, the end product of the macro would be individual rows in a database for each response to one question. So I'd need to have a different macro for each question in the interview questionnaire, and different files with the aggregated responses, each one in its own row. So I'd need to do more processing to get all of the responses to a given question into one cell, and then all of those cells into one document. Am I understanding that correctly? My larger problem is that I have yet to work with macros, so I'll need to figure out how to even use the macro on Graham's site, but that's another issue.... Thanks, Chris C. "Doug Robbins - Word MVP" wrote: See the following page of fellow MVP Graham Mayor's website: http://www.gmayor.com/extract_data_f...milar_docs.htm -- 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, originally posted via msnews.microsoft.com "Chris C." Chris wrote in message ... Hello nice people - At my job we do a lot of phone interviews, and we generally take notes in Word documents as we go. The interviews are structured, so there are specific questions we ask in a specific order. There might be 30 interviews for a given project, each in its own Word document, each document with the same questions in the same order. After the interviews are all done, we need to analyze them, and I'd like to be able to quickly merge all of the interview documents into one Word document that's organized by question. So, all the answers to question 1, then all the answers to question 2, etc., in the same order as they appear in the interview questionnaire. Right now I have to cut and paste the answers from multiple interviews into one document by hand and it's very tedious and time-consuming. Is there a way to automate this using forms and mail merge? I've looked at other questions and answers in this forum and in FAQs on the Microsoft site, and can't find an answer. Any help is greatly appreciated! Thanks, Chris C. |
|
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Merging data from multiple forms w/multiple fields into one da
http://www.gmayor.com/installing_macro.htm will help with installing
macros - and as Doug has suggested if you are using the macro to extract data from a free form document, the macro shown on the page he suggested will need modification. However, if you setup your document as a protected form with text form fields for the responses, the recovery of data is somewhat simpler and I have another page to cover that http://www.gmayor.com/ExtractDataFromForms.htm . -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "Chris C." wrote in message ... Thanks Doug. I think this may help, though if I read the page correctly, the end product of the macro would be individual rows in a database for each response to one question. So I'd need to have a different macro for each question in the interview questionnaire, and different files with the aggregated responses, each one in its own row. So I'd need to do more processing to get all of the responses to a given question into one cell, and then all of those cells into one document. Am I understanding that correctly? My larger problem is that I have yet to work with macros, so I'll need to figure out how to even use the macro on Graham's site, but that's another issue.... Thanks, Chris C. "Doug Robbins - Word MVP" wrote: See the following page of fellow MVP Graham Mayor's website: http://www.gmayor.com/extract_data_f...milar_docs.htm -- 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, originally posted via msnews.microsoft.com "Chris C." Chris wrote in message ... Hello nice people - At my job we do a lot of phone interviews, and we generally take notes in Word documents as we go. The interviews are structured, so there are specific questions we ask in a specific order. There might be 30 interviews for a given project, each in its own Word document, each document with the same questions in the same order. After the interviews are all done, we need to analyze them, and I'd like to be able to quickly merge all of the interview documents into one Word document that's organized by question. So, all the answers to question 1, then all the answers to question 2, etc., in the same order as they appear in the interview questionnaire. Right now I have to cut and paste the answers from multiple interviews into one document by hand and it's very tedious and time-consuming. Is there a way to automate this using forms and mail merge? I've looked at other questions and answers in this forum and in FAQs on the Microsoft site, and can't find an answer. Any help is greatly appreciated! Thanks, Chris C. |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fillable forms, multiple locations for entry of data, fields etc | Microsoft Word Help | |||
| merging multiple text fields | Mailmerge | |||
| extract data from multiple Word forms into Excel | Microsoft Word Help | |||
| how can i fill out multiple forms by entering data once? | Microsoft Word Help | |||
| forms in word: simultaneously fill in multiple fields? | Microsoft Word Help | |||
Hybrid Mode
