9 Replies Latest reply on Feb 13, 2015 8:59 AM by TSGal

    Send Mail not working in Webdirect

    sjamesbj

      Summary

      Send Mail not working in Webdirect

      Product

      FileMaker Server

      Version

      13.0.2.295

      Operating system version

      Windows Server 2008 R2 w/SP1

      Description of the issue

      Send Mail script step not generating email in Webdirect. Have tried in Internet Explorer 10 and Google Chrome v34.x. Running Windows 7 Professional and Outlook 2010. Script used to work prior to Heartbleed update. Tried installing latest update to server to fix the problem, still no email. Script step is NOT marked "Perform without dialog". Script IS marked "Run script with full access privileges".

      Remainder of script works as if email was sent. Pop-ups are not blocked on either browser. Google Chrome does have a new window open (see screenshot), however it is a browser window, not email.

      Outlook has been set as the default mail program and is the default handler for the mailto protocol.

      Steps to reproduce the problem

      Have tried it on two different PCs. Both are Windows 7 Professional. Restarted the PCs, same problem. Different user logged in, same problem. Updated FMS to 13v2, same problem.

      Here is the script in question:

      Set Error Capture [On]
      Send Mail[Send via E-mail Client; To:email@test.com; CC:email@test.com; etc. etc.
      If[Get( LastError )]
      ExitScript[Result:"EMAIL NOT SENT"]
      Else
      SetField[audit_SubmitStamp; TimeStamp(Get(CurrentDate);Get(CurrentTime))]
      EndIf
      CommitRecords/Requests[No dialog;Force Commit]

      Expected result

      Send Mail script step should open an Outlook email message window and user clicks on Send.

      Actual result

      Nothing from Internet Explorer 10. Google Chrome opens another browser window with the mailto information in the address bar.

      Exact text of any error message(s) that appear

      No error messages. Remainder of script runs as if there was no problem.

      Configuration information

      Server is Windows Server 2008 R2 w/SP1, FileMaker Server is v 13.0.2.295. Intel Xeon Processor, 2 cores, 7.81 GB RAM, 80 GB free on C, 102 GB free on E (Databases are house here).

      PC are running Windows 7 Professional with 2 to 8 GB of RAM. FileMaker Pro 13 is installed on one and FileMaker Pro Advanced 13 is installed on the other. Since this is a problem with WebDirect, the browsers installed are Internet Explorer 10 and Google Chrome v 34.x and both PCs have Outlook 2010 installed as there only mail client.

      Workaround

      None.

      Chrome_Result.png

        • 1. Re: Send Mail not working in Webdirect
          TSGal

               James Bjarnason:

               Thank you for your post.

               From your description, it appears that Outlook is not set up as the default e-mail program. That would be a good reason for Internet Explorer to not respond, and Chrome to display mailto: in the address bar.

               Please confirm that the default e-mail program is set for Outlook.  To do this, click the Start button and click Default Programs.  Click Set your default programs, and under Programs, click Outlook, and then click Set this program as default.  Click OK.

               Keep me updated with any progress.

               TSGal
               FileMaker, Inc.

          • 2. Re: Send Mail not working in Webdirect
            sjamesbj

                 Hi TSGal,

                 Yes, Outlook is set as the default email program on both PCs that have had the issue. I have also tested on a PC with Windows 7 Ultimate & Outlook 2013 with the same results.

            • 3. Re: Send Mail not working in Webdirect
              TSGal

                   James Bjarnason:

                   Thank you for the additional information.

                   Does this work on any of your machines?  If so, what are the differences?

                   After talking this over with another Support Technician, he noticed the multiple email addresses in the Chrome screen shot where each email address is separated by semi-colons.  Try separating the email addresses with commas.

                   If this also fails, then place a temporary button on the layout that executes the script step Send Mail, and address a message to only yourself with the Subject "Test".  Does this work?

                   Continue to keep me updated.

                   TSGal
                   FileMaker, Inc.

              • 4. Re: Send Mail not working in Webdirect
                TSGal

                     James Bjarnason:

                     Another Support Technician mentioned that the win.ini file may be incomplete and missing the [Mai} section.  You should have something similar to:

                     [Mail]
                     MAPI=1
                     CMCDLLNAME32=mapi32.dll
                     CMCDLLNAME=mapi.dll
                     CMC=1
                     MAPIX=1
                     MAPIXVER=1.0.0.1
                     OLEMessaging=1

                     -----

                     TSGal
                     FileMaker, Inc.

                • 5. Re: Send Mail not working in Webdirect
                  sjamesbj

                       Hi TSGal,

                       I did the test email just to myself and it worked. I then changed the semi-colons to commas in the email address and still had the problem. I created a new button that just uses the Send Mail instead of Performing a Script and worked my way through the email. The To field is fine, the Subject line is fine, it's when I get into the Body of the Email that problems start happening. Below is an example of what "should" be generated in the body of the email:

                  Mystery Shop #: EMS-00005
                  
                  
                  =========================================================================
                  
                  Site Information:
                  
                  =========================================================================
                  
                  
                  Site Name: Edgewater Casino - Downtown Vancouver     Site Entry Point: TEST
                  
                  Date of Visit: 5/15/2014     Time of Entry: 20:00:00     Time of Departure: 20:15:00
                  
                  Mystery Shopper Name: TEST     Mystery Shopper Age: 20
                  
                  Description of Shopper & Clothing (please include estimated height & colour of clothing):
                  
                  TEST
                  
                  
                  =========================================================================
                  
                  Main Entry:
                  
                  =========================================================================
                  
                  
                  Main Entry S/O Name: TEST
                  
                  Was Parking Easy?: Yes     Comments:
                  
                  Was there a lineup at the door? If so, indicate the time it took until you entered the casino floor?: Yes     Comments:
                  
                  Did the Security Office smile and verbally greet you?: Yes     Comments:
                  
                  Did the Security Officer ask you for primary ID?: Yes     Comments:
                  
                  Did the Security Office use your name as seen on your ID?: Yes     Comments:
                  
                  Did the Security Officer offer you a parting comment?: Yes     Comments:
                  
                  
                  Please describe your interaction in detail:
                  
                  TEST
                  
                  
                  =========================================================================
                  
                  Food & Beverage
                  
                  =========================================================================
                  
                  
                  Food & Beverage Employee Name: TEST
                  
                  Did the Server smile and verbally greet you?: Yes     Comments:
                  
                  Did the Server ask you for primary ID?: Yes     Comments:
                  
                  Did the Server ask you for a second piece of ID?: Yes     Comments:
                  
                  Did the Server use your name as seen on your ID?: Yes     Comments:
                  
                  Did the Server offer you a parting comment?: Yes     Comments:
                  
                  Drink:      Cost:
                  
                  
                  Please describe your interaction in detail:
                  
                  TEST
                  
                  
                  =========================================================================
                  
                  Overall Customer Service Interaction
                  
                  =========================================================================
                  
                  
                  Staff was available in a timely manner: 5 STAR
                  
                  Staff greeted you and offered to assist you: 5 STAR
                  
                  Staff was friendly and cheerful throughout: 5 STAR
                  
                  Staff answered your questions: 5 STAR
                  
                  Staff showed knowledge of the products/services: 5 STAR
                  
                  Staff offered pertinent advice: 5 STAR
                  
                  Staff was courteous and thoughful: 5 STAR
                  
                  Overall, how would you rate the customer service?: 5 STAR
                  
                  
                  What did you like best about the customer service?:
                  
                  TEST
                  
                  
                  How could the customer service improve?:
                  
                  TEST
                  
                  
                  Did the staff thank you when you left the building?:
                  
                  TEST
                  
                  
                  Is there an employee that you would like to commend? (Please indicate their name and/or description):
                  
                  TEST
                  
                  
                  Reason?:
                  
                  TEST

                        

                       and here is what I can get after going through line by line, removing items until it worked:

                        

                  Mystery Shop #: EMS-00005
                  
                  
                  =========================================================================
                  
                  Site Information:
                  
                  =========================================================================
                  
                  
                  Site Name: Edgewater Casino - Downtown Vancouver     Site Entry Point: TEST
                  
                  Date of Visit: 5/15/2014     Time of Entry: 20:00:00     Time of Departure: 20:15:00
                  
                  Mystery Shopper Name: TEST     Mystery Shopper Age: 20
                  
                  Description of Shopper & Clothing (please include estimated height & colour of clothing):
                  
                  TEST
                  
                  
                  =========================================================================
                  
                  Main Entry:
                  
                  =========================================================================
                  
                  
                  Main Entry S/O Name: TEST
                  
                  Was Parking Easy?: Yes     Comments:
                  
                  Was there a lineup at the door? If so, indicate the time it took until you entered the casino floor?: Yes     Comments:
                  
                  Did the Security Office smile and verba

                       As you can see I had to cut the email short by quite a bit. Is there a limit to how many characters the email can be when using WebDirect?

                        

                       Also I did check the Win.ini file and this is the Mail entry:

                        

                       [Mail]
                       MAPI=1
                       CMCDLLNAME32=mapi32.dll
                       CMC=1
                       MAPIX=1
                       MAPIXVER=1.0.0.1
                       OLEMessaging=1
                        
                       Thank you for your assistance.
                  • 6. Re: Send Mail not working in Webdirect
                    TSGal

                         James Bjarnason:

                         Thank for the information.

                         It definitely sounds like a character limit sent from WebDirect to the Email client.  Checking over your post, it looks around 900 characters, which is an odd amount, so it may be the entire To, Subject, Body, etc. that exceeds possibly 1024 (1KB) characters.

                         For verification, this issue works properly in FileMaker Pro?  Or, do you have the same issue?

                         At this point, I have sent your posts to our Development and Testing departments for review.  When I receive any feedback, I will let you know.

                         TSGal
                         FileMaker, Inc.

                    • 7. Re: Send Mail not working in Webdirect
                      sjamesbj

                           Hi TSGal,

                           There is no issue in FileMaker Pro or FileMaker Pro Advanced, it is only in WebDirect that the problem has occurred. If I could PDF the report and send it the email text would be very short, i.e. see attached PDF, but unfortunately that feature is not available... yet?

                           Thanks!!

                      • 8. Re: Send Mail not working in Webdirect
                        TSGal

                             James Bjarnason:

                             Thanks for checking.  I just wanted to confirm this was only happening with WebDirect.

                             TSGal
                             FileMaker, Inc.

                        • 9. Re: Send Mail not working in Webdirect
                          TSGal

                          James Bjarnason:

                          I am revisiting old posts, and there was an update to this issue in November last year that I missed.  In essence, Development said this was a browser limit and not a Web Direct issue (http://support.microsoft.com/kb/208427).  In essence, the maximum length of a URL string in Internet Explorer is 2,083 characters, and Web Direct uses the mailto: command to send emails.  This limitation has been sent to our Documentation department so it can be mentioned in future documentation.

                          TSGal
                          FileMaker, Inc.