Any EASY way to get data from Outlook over to FileMaker??

I'm looking for a solution in which my sales team can consitantly pull information from an email they receive and push that info over into our FileMaker database.  I would think the easiest way would be for them to somehow create a contact off that email and then be able to send that contact over to filemaker and select which field to add the data too.

The unique identifier on our records in someone's email address.  Anyone have some suggestions?

I tried this and it seems to be crap unless I just can't figure it out.  :)

https://www.productive.cc/pci_cart/FMPro?-DB=PCSC_Products.FP5&-Format=catalog.htm&-Lay=CGI&ID_No=40&-Find
LVL 1
CHILINVLNAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lesouefCommented:
The best would probably be to use a pop3 plug-in to receive email direclty in filemaker.
CNS and Dacons are doing this. But this is auite a bit of work to make a good app with it.
If you'd like to recuperate some data from outlook > fm, do you need to only recuperate contacts, or more? on a daily basis, more frequent, for each mail?
lesouefCommented:
Forgot to mention that the plug-in should be ok. productive normally has good stuff, I tested 2 of his plug-ins (not the one you mention) and they were ok. I once found a bug and he corrected it quickly, so don't hesitate to contact him if you have any problem to implement it.
billmercerCommented:
I agree that Productive usually make good stuff. In this case, I think that plugin would be overkill. It's more intended for more live integration stuff, like creating appointments and emails automatically based on database info.
I once wrote a FM script that would retrieve information from a VCF file. Not sure if that would be useful.
CHILINVLNAuthor Commented:
I'm just looking for a way that I can have my saleteams do the following:

(They receive an email from a prospect, which is now a "contact")

Create a new contact/contacts from either a single, or group of emails, and then push those contacts into FileMaker.  The information we're MOST concerned with the First Name, Last Name, and Email Address.

Any chance there is a script you can create to where a salesman could click a button in FileMaker called "Import Outlook Contact" and they can either specify the VCF file and have it autopopulate those fields in a new record or something else along those lines?  I don't know exactly how to explain it but you get my drift.

Of course, the field names in filemaker are unique so I would have to modify the script in some way, but I'm very capable of doing that much.  

Does that make better since?  I'm just not sure whether the approach is pushing the data from outlook INTO FileMaker or PULLING the data FROM outlook into FileMaker...
billmercerCommented:
>...click a button in FileMaker called "Import Outlook Contact" and they can either specify the VCF file
> and have it autopopulate those fields in a new record or something else along those lines?  

That's definitely possible, though the simplest way would involve a two-step process. Users would first need to save the VCF file from Outlook, then import it into FM. Not real difficult, but slightly annoying.
If you wanted to make the process more automatic, then you could probably create a VBA macro that would automatically export the current contact as a VCF file, then import it automatically.
Then you could have Filemaker use the Send Event step to execute a VBScript to start the process.
This would be the "pull" approach.

As for the "push" approach, that could also be done, though it would be trickier. FileMaker doesn't really have much in terms of ways to get information into the application. Basically, your only options are direct data entry (via client or web), ODBC, and the clipboard. If you're on the Mac platform, Applescript is a good option, but for Windows you're limited to those three.
 

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Components

From novice to tech pro — start learning today.