Discussion Locked

Email forms to a usable database

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

i have over 5000 e-mail "download response forms" from FormMail and others. I would like somehow to be able to extract this into an Excel or Access database automatically.

It takes a very long time to cut and paste each filed and record.

The formatting of the e-mail responses varies - but contains the relevant information like, e-mail address, name (some as full name some as first/last name, address, telephone no, country, etc.)

Not all response forms are laid out the same.

3 replies

by foss

Have you tried exporting as csv, importing (file, get external data)? comma seperated text files / tab separated.

by stephen

Exporting over 5000 individual mails - hmmmm.

How-ever we are now using one of the software products that we sell - called Email-flow.

This allows extration and entering into databases etc etc

This discussion is closed to new replies.