A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Merging data from multiple forms w/multiple fields into one databa



 
 
Thread Tools Display Modes
  #1  
Old March 20th, 2010, 07:24 PM posted to microsoft.public.word.mailmerge.fields
Chris C.
external usenet poster
 
Posts: 3
Default 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  
Old March 20th, 2010, 10:10 PM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default 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  
Old March 21st, 2010, 11:44 PM posted to microsoft.public.word.mailmerge.fields
Chris C.[_2_]
external usenet poster
 
Posts: 3
Default 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  
Old March 22nd, 2010, 01:24 AM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default 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  
Old March 22nd, 2010, 06:53 AM posted to microsoft.public.word.mailmerge.fields
Graham Mayor
external usenet poster
 
Posts: 18,297
Default 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.




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:19 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.