Email and form results from a website to go into a database

[Dexie]

Can anyone please let me know if it's possible for data that is sent by way of an email or form to go straight into an Access 2003 database please? Is it easy to setup? Can anyone let me know how you do it please? Nothing too fancy, just email address, name and tel number.

Any help appreciated.

Dex.

[volatilegx]

We've done it, but it required a bit of manual work... we developed a macro that copied an email, pasted the results into an Excel file, then imported the data into the database.

The manual part is opening the email client and executing the macro for each email.

[Dexie]

Many thanks Volatile, where do I start please?

Also, I'm on a Linux server - would that be a problem anywhere, do I really need asp?

Any help appreciated.

Dexie.

[volatilegx]

All of the macros we had resided on the local (Windows XP) machine. They were written using Excell and Access.

[Dexie]

Many thanks, care to give any examples?

[volatilegx]

Well, normally I would, but these days I telecommute and don't have those macros on my computer. I'm not even sure who handles that part of the business any more. There are plenty of commercial macro recorders on the market that could help you with the project.

[Dexie]

Has anyone else got any input on this at all?

Dexie