5 Replies Latest reply on Nov 17, 2016 8:51 AM by cjurdaneta

    Error in Sending an email in Filemaker 15 with Microsoft Outlook

    cjurdaneta

      I has a problem, with a script sending an email.

      And the error is:

      The task cannot complete, because another program is busy.

      Choose  Change to....activate the busy program and solve the problem.

       

      At the same time in the windows administrator appear fixmapi.exe*32  repair tool, if i don't close that program i cannot do anything more.

       

      This script work perfect in Filemaker 12 and 13.

       

      Script:

      Go to Layout [ “MEJORAR” (Data_Master) ]

      Insert Calculated Result [ Data_Master::R6; "¶¶-------------------------------------------------------------------¶ " & GetAsText(Get(CurrentDate)) & "Se

      envio correo a la dirección de email :" & Data_Master::email & " a las :" ]

      Insert Current Time [ Data_Master::R6 ]

      Go to Layout [ “datos ampliados” (Data_Master) ]

      Insert Calculated Result [ Data_Master::contador_veces; Data_Master::contador_veces + 1 ]

      [ Select ]

      Perform Script [ “refrescar” ]

      If [ Data_Master::seleccion_anexo = "1" ]

      Set Variable [ $A; Value:If (Data_Master::archivo_anexo1 = "" ; "" ;"file:1AAAAA/" & Data_Master::archivo_anexo1 ) ]

      Set Variable [ $B; Value:If (Data_Master::archivo_anexo1 = "" ; "" ;"file:1AAAAA/" & Data_Master::archivo_anexo2 ) ]

      Else

      If [ Data_Master::seleccion_anexo = "2" ]

      Set Variable [ $A; Value:If (Data_Master::archivo_anexo1 = "" ; "" ;"file:1AAAAA/" & Data_Master::archivo_anexo2 ) ]

      Else

      If [ Data_Master::seleccion_anexo ="3" ]

      Set Variable [ $A; Value:If (Data_Master::archivo_anexo1 = "" ; "" ;"file:1AAAAA/" & Data_Master::archivo_anexo3 ) ]

      Else

      If [ Data_Master::seleccion_anexo = "4" ]

      Set Variable [ $A; Value:If (Data_Master::archivo_anexo1 = "" ; "" ;"file:1AAAAA/" & Data_Master::archivo_anexo4 ) ]

      Else

      If [ Data_Master::seleccion_anexo = "5" ]

      Set Variable [ $A; Value:If (Data_Master::archivo_anexo1 = "" ; "" ;"file:1AAAAA/" &Data_Master::archivo_anexo5 ) ]

      Else

      If [ Data_Master::seleccion_anexo = "6" ]

      Set Variable [ $A; Value:If (Data_Master::archivo_anexo1 = "" ; "" ;"file:1AAAAA/" &Data_Master::

      archivo_anexo6 ) ]

      Else

      If [ Data_Master::seleccion_anexo = "7" ]

      Set Variable [ $A; Value:If (Data_Master::archivo_anexo1 = "" ; "" ;"file:1AAAAA/" &Data_Master::

      archivo_anexo7 ) ]

      Else

      End If

      End If

      End If

      End If

      End If

      End If

      End If

      Insert Calculated Result [ Data_Master::ESTATUS; "ENVIADO" ]

      [ Select ]

      Copy [ Data_Master::archivo_anexo2 ]

      [ Select ]

      Send Mail [ Send via E-mail Client; To: Data_Master::email; CC: Data_Master::concopia; BCC: Data_Master::email_en_blindcopy; Subject:

      Data_Master::proyecto77; Message: Data_Master::data_contenido; Attachment: “$A” ]

      Allow User Abort [ Off ]

       

      Please if someone can help me solving this problem.

      Regards

      CJUrdanetaerror_send_email2.jpg

        • 1. Re: Error in Sending an email in Filemaker 15 with Microsoft Outlook
          mikebeargie

          Before we touch the email, please optimize your code and change this:

          If [ Data_Master::seleccion_anexo = "1" ]

          Set Variable [ $A; Value:If (Data_Master::archivo_anexo1 = "" ; "" ;"file:1AAAAA/" & Data_Master::archivo_anexo1 ) ]

          Set Variable [ $B; Value:If (Data_Master::archivo_anexo1 = "" ; "" ;"file:1AAAAA/" & Data_Master::archivo_anexo2 ) ]

          Else

          If [ Data_Master::seleccion_anexo = "2" ]

                    Set Variable [ $A; Value:If (Data_Master::archivo_anexo1 = "" ; "" ;"file:1AAAAA/" & Data_Master::archivo_anexo2 ) ]

               Else

                    If [ Data_Master::seleccion_anexo ="3" ]

                         Set Variable [ $A; Value:If (Data_Master::archivo_anexo1 = "" ; "" ;"file:1AAAAA/" & Data_Master::archivo_anexo3 ) ]

                    Else

                         If [ Data_Master::seleccion_anexo = "4" ]

                              Set Variable [ $A; Value:If (Data_Master::archivo_anexo1 = "" ; "" ;"file:1AAAAA/" & Data_Master::archivo_anexo4 ) ]

                         Else

                              If [ Data_Master::seleccion_anexo = "5" ]

                                   Set Variable [ $A; Value:If (Data_Master::archivo_anexo1 = "" ; "" ;"file:1AAAAA/" &Data_Master::archivo_anexo5 ) ]

                              Else

                                   If [ Data_Master::seleccion_anexo = "6" ]

                                        Set Variable [ $A; Value:If (Data_Master::archivo_anexo1 = "" ; "" ;"file:1AAAAA/" &Data_Master::

          archivo_anexo6 ) ]

                                   Else

                                        If [ Data_Master::seleccion_anexo = "7" ]

                                             Set Variable [ $A; Value:If (Data_Master::archivo_anexo1 = "" ; "" ;"file:1AAAAA/" &Data_Master::

          archivo_anexo7 ) ]

                                        Else

                                        End If

                                   End If

                              End If

                         End If

                    End If

               End If

          End If

          to something much simpler, like this:

          Set Variable [ $A ; "file:1AAAAA/" & Choose ( Data_Master::seleccion_anexo; Data_Master::archivo_anexo1; Data_Master::archivo_anexo2; Data_Master::archivo_anexo3; Data_Master::archivo_anexo4; Data_Master::archivo_anexo5; Data_Master::archivo_anexo6; Data_Master::archivo_anexo7) ]

          Set Variable [ $B; "file:1AAAAA/" & Choose ( Data_Master::seleccion_anexo + 1; Data_Master::archivo_anexo1; Data_Master::archivo_anexo2; Data_Master::archivo_anexo3; Data_Master::archivo_anexo4; Data_Master::archivo_anexo5; Data_Master::archivo_anexo6; Data_Master::archivo_anexo7)]

          Essentially:

          Set Variable [ $A ; prefix & value from number selected ]

          Set Variable [ $B ; prefix & value from number selected + 1 ]

          And get rid of all of the nested and cluttered IF/ELSE/END IF statements.

          • 2. Re: Error in Sending an email in Filemaker 15 with Microsoft Outlook
            mikebeargie

            For your outlook error, which version of the filemaker installer and outlook are you using.

             

            They should BOTH be either the 32 or 64 bit versions. Using a mixture of those two will result in outlook issues immediately.

            1 of 1 people found this helpful
            • 3. Re: Error in Sending an email in Filemaker 15 with Microsoft Outlook
              cjurdaneta

              Mr. Beargie,  I thought that combination of 32 or 64 bit versions, can cause errors, you should do install the version of Filemaker 15 in 32 bit?

              • 4. Re: Error in Sending an email in Filemaker 15 with Microsoft Outlook
                mikebeargie

                You should use whichever version matches office. I believe office comes in 32 and 64 bit as well, so you need to match filemaker to that.

                • 5. Re: Error in Sending an email in Filemaker 15 with Microsoft Outlook
                  cjurdaneta

                  I change my Filemaker 15 to version 32, and everything works correctly.

                  Thanks to Mike Beargie for the advice.

                   

                  Regards

                  Carlos J. Urdaneta