4 Replies Latest reply on Apr 22, 2014 6:23 AM by wimdecorte

    Best plugin or structure to download multiple exchange mail folders

    slayden@msn.com

      There are a LOT of options for email: PHP, 360 works plugin. Mailit5...

       

      I need to hang full email interaction or capability on my Filemaker CRM system.

      Part of what we need is to download multiple user's email boxes to a database (fmPro or mySQL?) so we can use match field data from the email address(es ie multi key) to see every email to and from out office to and from a business client.

       

      Looking for speed and ease of implementation.

       

      For instance, 360 works looks great, but, how does one create and edit html email for sending?

       

      Suggestions?

       

      Thanks

      Scott

        • 1. Re: Best plugin or structure to download multiple exchange mail folders
          mikebeargie

          Well, you say "download multiple exchange folders" in your subject line, so I'm assuming that the only plugin that will work for you would be exchange manipulator from productive computing.

           

          Although from what you describe, I'm starting to wonder if it's a practical solution to run via filemaker. Exchange manipulator is a pretty hefty plugin. What would certainly save you time is if you have control of the exchange server, and can run something like this: http://www.email2db.com/

           

          If you could have something like that parse all of your emails to a filemaker friendly format, then you could bypass the need for plugins, and possibly have a filemaker server scheduled script to import and parse the data on a repeating schedule.

           

          The other issue is outbound mail, I know exchange manipulator can read from the sent items folder, but I don't think the email2db.com solution can.

           

          Another alternative would be to see if there's some solution for exchange server that can automatically save a copy of every inbound and outbound email to a single exchange account, that way you only need exchange manipulator running for one machine/account.

           

          To answer your question about creating outbound emails from plugins like 360works. you usually string together your html in a variable, and send it out by setting another calculated variable, IE:

          Set Variable $body = "<img src="" /><br />HEADING<br /><br />some other text"

          Set Variable $send = 360SendMail( $to ; $subject ; $body )

          If [ $send = 1 ]

               //email successful

          else

              //errors

          End If

           

          And I'm not even going to touch the privacy issue with a ten foot pole, but I'd like to note I'd certainly never want to work for a place that was parsing out every single inbound and outbound email I receive.

          • 2. Re: Best plugin or structure to download multiple exchange mail folders
            slayden@msn.com

            A quick "down and dirty" way to send html email (assuming the client is using an email client that defaults to HTML) APPEARS to be to use a webviewer to create a calculated sending hyperlink and adding the variables. 
            However, I'm struggling with the syntax as I can seem to add ONE variable (subject OR body) but not both.
            Suggestions?

             

            <a href="mailto:one@two.com">

            MailTo with Multiple Recipients

            <a href="mailto:one@two.com,two@three.com">

            MailTo with Subject

            <a href="mailto:one@two.com?subject=Comments from MailTo Syntax Page">

            MailTo with a Copy

            <a href="mailto:one@two.com?cc=one@two.com">

            MailTo with a Blind Copy

            <a href="mailto:one@two.com?bcc=one@two.com">

            MailTo with message already started in Body

            <a href="mailto:one@two.com?body=I am having trouble finding information on ">

            MailTo with multiline message in Body

            <a href="mailto:one@two.com?body=Attached message.">
            There are various things you can do using mailto: which is html element.

            • 3. Re: Best plugin or structure to download multiple exchange mail folders
              mikebeargie

              Try formatting your syntax in proper encoding ( %20 is a space ), ampersands (&amp;) are required between each parameter.

               

              IE:


              test@test.com?cc=test2@test.com&bcc=test3@test.com&subject=The%20subject%20of%20the%20email&body=The%20body%20of%20the%20email

               

               

              As an alternative to the webviewer, you should also be able to use an open URL script step to perform this.

               

              (It keeps encoding my links, you can see an explanation of the proper formatting here: http://www.rapidtables.com/web/html/mailto.htm)

              • 4. Re: Best plugin or structure to download multiple exchange mail folders
                wimdecorte

                I can't reconcile these two statements / questions

                slayden@msn.com wrote:

                 

                 

                Part of what we need is to download  multiple user's email boxes to a database (fmPro or mySQL?) so we can use match field data from the email address(es ie multi key) to see every email to and from out office to and from a business client.

                 

                 

                and

                 

                slayden@msn.com wrote:

                how does one create and edit html email for sending?

                 

                Those are two VERY different things and should be solved separatly.

                 

                Gathering data from different mailboxes can be done by plugins if you want to keep the code in FM, but it can just as easily be done on the exchange side and push data into FMS (instead of FM pulling data from Exchange).  The coding for pushing data into FMS would have to be done on the Exchange side, so it is outside of FM but that has its own benefits (stability for one).