Can I recieve emails in FM7

[sifter]

Here's the situation...

I have my FM7 database send out various automatic emails to vendors through my company email account. Currently, they send me confirmation emails and I have to manually copy and paste the emails into the associated record in FM7 so that I have the confirmation on record.

Surely, you know what my question is.

Can I automate that process some how so that the confirmation email from the vendors automatically go to FM7, and get stored in the right record???

[transpower]

You could save your confirmation e-mails to disk and then import them, but how would you know which text goes to which record? The header would have to contain the record information so that you could import the text to the correct record. Actually it would be easier to import to one record (in a special table) and then post from that record to the correct record in the correct table, after parsing the header information. Or, better: find a plug-in to do this.

[stuj1026]

We have done something very similar at our company.. We use SMTP-it and POP3-IT plugins to do the job..

We created a mail account that all agents will e-mail to called [email protected]

We send the emails with there account # in the subject line. The send back an auto response with the account # in the subject. We have filemaker checking for e-mails every 30 seconds from reports @ ourcompany.com

When the emial arrives , a script checks the subject of the message and the sender using pop3-it. We have a relationship between the account# and the E-mail address so when a new record comes in we can tell which account it belongs to .. We then grab the body of the text to the record.. This can all be done thru POP3-it which is for receiving and smtp-it for sending..

Im sure your situation is unique but with a little thinking outside the box you can make it work for you.

Stu

[xochi]

Are you running FM 7 server? If so, do you have a machine that is running client that does the 30-second checking? Or did you find a way to get the POP plugin to work from within server (triggered by a schedule?)

[mikehkg]

fm server only HOSTS files, you can't open a file with it, and it does not execute any scripted tasks from within the hosted files.

Plugins can only be called by scripts, and to execute a script in a fm file you need a client.

You can install one fm client on the server machine to do the mail retrieving and processing by connecting to your mail retrival file via host. My solution also has a built in filter, some identified junk is beeing deleted instantly (no more VIAGRA, lol!)and suspicious go to the junkbox which is being cleaned out manually

cheers

mike

FM 8 - the last best thing since - FM 7 :-)

****************************************************************

my 6 biggest recommendations for FM9:

- getMail

- SendFax

- Perform Script (calculated script name)

- All Sub-MenuItems File/Define AND the Script Editor become

Tabs in "Define Database"

- Script Groups (show all, show only group xxx)

- Sub-Menues in Taskbar Layout PopUp

****************************************************************

Edited January 5, 2006 by Guest