Hi all,

We are using Outlook to collect web form data from a third party website. emails come down at the rate of about 200 a day and we have to get them into filemaker to try and process them - mostly brochure requests.

Anyway, is there solution available (plugin / clever script, third party solution) that can look at an email inbox, read the fields in it and import them into filemaker as new records. Preferably it would also then move the email to a new folder so it doesn't look at it again. I don't mind if it has to be a once only daily manual process if it can't be automatic.

Does anyone have any good ideas? Is anyone else doing this now? I don't mind having to upgrade filemaker if this is the only way.

Thanks for your help.

Dave

The Pop3It plug-in can receive email directly into FileMaker; no email client required.

http://www.cnsplug-ins.com/products.htm?product=POP3it

You would want to use a dedicated email address for these forms. You won't want to mix them up with other email. As far as upgrading, the earlier versions of the plug-in have an automatic checking of the email which the later versions for 7 does not have yet (and it's been a long time; I don't know if it's ever going to get it back). But that's not critical, as you can just hit a button.

As far as dealing with the forms themselves, we've covered that quite a bit here on the forums, if you search for "parse" (250 hits). Actually it's been a while, so you have to go to about page 8 of the results. Like:

http://fmforums.com/forum/showtopic.php?tid/115177/post/115177/hl/parse/#115177

But every form is slightly different.

hi thanks for that info. Never thought to look for the word 'parse'. Gotta say though that looking through the forums, actual detail on what to do seems a bit sparse.

Anyway, not sure that popit thing will do the job - have tried it but it can't connect to my exchange server.

Are there any other plugins that might work? Or third party solutions that can automate this process a bit more?