Just to help me understand: Let’s say I have OL2007. I can create survey
forms, send them to both Outlook users (all versions) and non-Outlook users.
Both groups will be able to return the results. Then, using Access, I can
read the survey results for analysis.
I currently use 2003 and if this would work it would allow me to make the
case to upgrade to 2007.
If there any limitations that may come up, what might they be?
If all this will work, you just sold another book!
Close, but not quite. No Outlook form or programming is involved at all. Instead, you use Access 2007's data collection feature to create and address an HTML message that asks all the questions. This message will work for both Outlook and non-Outlook recipients (as long as they support HTML). An Outlook add-in that is automatically installed with Office processes the returned items and automatically updates the Access database. For a walkthrough with screen shots, see http://blogs.msdn.com/access/archive/2006/06/30/652837.aspx and http://blogs.msdn.com/access/archive/2006/07/11/662687.aspx
Note that only the person generating the data collection process and receiving the responses needs Office 2007, not the recipients filling out the HTML form.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.