The title pretty much says it. I have to send a form to 388 people. They will answer 8 questions and send the form back. Is there any way I can automatically export this information using Word and Excel? I’m not a whiz at either program these days. I’m using Word and Excel 2003, but I also have the new versions designed for Vista. This was tossed at me a couple hours ago and I need to get the email out tomorrow and compiled into a useful spreadsheet by Thursday. Any and all help will be much appreciated!!
What do you mean by “export”? Do you mean that you have to send a form letter so that each copy of the form has someone’s name and address on it? Do you have some sort of file to start with or are you starting from scratch?
I might be able to offer some help but don’t understand enough about what you’re trying to do.
I’m starting from scratch. I want to create something in Word that will have eight questions and a form “field” for each question. Each of the 388 people will answer the questions and send it back to me. I then need to somehow get that information to Excel.
I do, however, have some information on these people in an existing Excel file. I’m not sure how to incorporate the new stuff into the old form, but getting the info to align properly with the existing info would be ideal.
Does that help? Thank you for trying to help!
IF by some wild chance everybody you’d be sending to has Office 2007 and IF by chance your company bought them all the Professional edition which includes the InfoPath 2007 program, then …
You create an InfoPath form & email it each of them. It appears in their Outlook as a form to fill out, all pretty & everything. They each fill it out in their Outlook & click [Send] to mail it back to you. As the mails arrive back at your Outlook, it automatically creates what looks like a spreadsheet with each form box a column and each returning email a row. When you have enough responses, you click on the spreadsheet-like display, then copy, then start Excel & click paste. Done.
In other words, Office 2007 has tools to make this a 5 minute job. But without those tools, you’re not going to do it automatically unless you understand programming both Word & Excel. I see 388 x 8 = 3104 individual copy & paste operations in your immediate future.
If your 8 questions are pretty basic, Google Spreadsheets has a really cool form feature that sounds like it could work for you. You set up the spreadsheet and tell the form what fields to populate with which responses. Then as long as your existing spreadsheet has a common field, you can link the info with VLOOKUP.
Wow. I have Infopath, but I seriously doubt more than a handful of the 388 have it. I had to get the email out yesterday, so I decided to do the questionnaire in cheesy Excel format. Then at least I’ll only have 388 cut-and-pastes. Thank you all for your input. I wish I had more use for these new-fangled programs. This one sounds really great. However, this type of project won’t land in my lap too often.