Access/Outlook?

[JollieOllie]

Hi All,

Apologies if this question has already been asked. Im a bit of a newb when it comes to Access. I was wondering if its possible to create a input form/email in Access/Outlook in which I can send to a number of people via email that populate a Access database/xls when they reply?

Extra Info:
-Users may have a different version of office that I have.
-I have office 97, 2000 and 2003.

Hope that all makes sense.

Ollie

 

[freakazeud]

re:

Hi,
Access 2007 has a great new feature which allows you to easily do this.
A wizard included in Access 2007 lets you either create HTML or InfoPath forms which you can send to your users. When they reply the data will be automatically synced with the database if specified.
You can read more about this here and here.
Doing all this in Access versions prior to the new 2007 version is a really difficult and longwinded process. You would need to manually create a new outlook form...then send it with your email...then wait for the reply and then try to import it into Access.
HTH
Good luck

 

[JollieOllie]

Office 2007 looks great and does exactly what i need, but im not sure if im going to be able to get it so the longwinded process may be the only way .

Do you know if 2007 will be able to handle replies from users that have a different version of Office? I.e i send the mail in 2007 to users that are using 97, 2000 etc.

Thanks

Ollie

 

[freakazeud]

re:

I think Outlook 2007 needs to be present for this to function.
HTH
Good luck