TABLE OF CONTENTS


Set Up

DLLs

Copy the below DLLs to the customers folder from M:\FHG Software\Systems\Emirwin\MKE on the FHG server:

  • [ ]  FHGSMTP.DLL
  • [ ]  LIBEAY32.DLL
  • [ ]  SSLEAY32.DLL


? If the date modified for any of these DLLs is newer than the customers EMiR, you'll need to arrange an EMiR update before proceeding.


Switches

Enable:

  • [ ]  FHG_SMTP_DLL
  • [ ]  JT_SURVEY_BULK_EMAIL


In Data | Data | EMiR Users when you edit a user a new button Bulk Email becomes visible. This allows you to enter a email address and password to be used when bulk emailing. This address will need SMTP authentication ticked on the O365 admin centre.


MiscCfg

Add records to MISCCFG.DBF (ID's less that 50000):

  • [ ]  SMTPRef1, VALUESTR, server address

  • [ ]  SMTPRef2, VALUEINT, port number

  • [ ]  SMTPRef5, VALUEINT, (Mode)

    • Mode Options

      0: Unassigned

      1: Client

      2: Server

      3: Both

  • [ ]  SMTPRef6, VALUEINT, (Method)

    • SSL Method Options

      0: sslvSSLv2

      1: sslvSSLv23

      2: sslvSSLv3

      3: sslvTLSv1

      4: sslvTLSv1_1

      5: sslvTLSv1_2

  • [ ]  SMTPRef7, VALUEINT, (TLS support option)

    • TLS Option Numbers

      0: NoTLSSupport

      1: UseImplicitTLS

      2: UseRequireTLS

      3: UseExplicitTLS

  • [ ]  SMTPRef8, VALUEBOOL, (Authentication needed)

  • [ ]  SMTPRef9, VALUEBOOL, (Use SSL)


Examples
    FHG

        SMTPRef1, VALUESTR, mail.fishheadgear.co.uk

        SMTPRef2, VALUEINT, 25

        SMTPRef5, VALUEINT, 0 (mode Unassigned)

        SMTPRef6, VALUEINT, 0 (meth SSLv2)

        SMTPRef7, VALUEINT, 0 (TLS No TLS)

        SMTPRef8, VALUEBOOL, False (Auth)

        SMTPRef9, VALUEBOOL, False (SSL)
    WebElec

        SMTPRef1, VALUESTR, mail.webb-elec.co.uk

        SMTPRef2, VALUEINT, 465

        SMTPRef5, VALUEINT, 1 (mode Client)

        SMTPRef6, VALUEINT, 1 (meth SSLv23)

        SMTPRef7, VALUEINT, 1 (TLS Implicit TLS)

        SMTPRef8, VALUEBOOL, True (Auth)

        SMTPRef9, VALUEBOOL, True (SSL)
    GMail

        SMTPRef1, VALUESTR, smtp.gmail.com

        SMTPRef2, VALUEINT, 587

        SMTPRef5, VALUEINT, 1 (mode Client)

        SMTPRef6, VALUEINT, 1 (meth SSLv23)

        SMTPRef7, VALUEINT, 3 (TLS Explicit TLS)

        SMTPRef8, VALUEBOOL, True (Auth)

        SMTPRef9, VALUEBOOL, True (SSL)
    Office 365 (This is what Parsons have and all works fine there).

        SMTPRef1, VALUESTR, smtp.office365.com

        SMTPRef2, VALUEINT, 587

        SMTPRef5, VALUEINT, 1 (mode Client)

        SMTPRef6, VALUEINT, 5 (method SSLv1_2)

        SMTPRef7, VALUEINT, 3 (TLS Explicit TLS)

        SMTPRef8, VALUEBOOL, True (Auth)

        SMTPRef9, VALUEBOOL, True (SSL)

NOTE: I had to alter EMCONFIG.DBF for DOCID of 98 and set the FROMADDR to the username/email address I was using, as office 365 would not let me send where the from was different.


? You can test the SMTP options at: https://smtpserver.com/smtptest


Bulk Email Switches

Switches to be added depending on what they will be bulk emailing:

  • [ ]  BULK_EMAIL_QUOTES_BY_CUST

  • Switch Description

    Bulk emailing of quotes for a customer. Use a grid to search for quotes that match then select them and send as attachments to one email instead of multiple emails with only one attachment.

  • [ ]  EM_BULK_DEBT_LETTERS

    • [ ]  EMSMTP.DLL copied across.

  • Switch Description

    Enables bulk emailing of debt letters. Will require additional work for systems with custom stationery. Requires EMSMTP.DLL

  • [ ]  EM_BULK_JOBINV

    • [ ]  EMSMTP.DLL copied across.

  • Switch Description

    Enables new bulk emailing of job invoices. *** Standard stationery users only. Additional costs to update custom systems *** Requires EMSMTP.DLL

  • [ ]  EM_BULK_REMADV

    • [ ]  EMSMTP.DLL copied across.

  • Switch Description

    Enables new bulk emailing of remittance advices. *** Standard stationery users only.  Additional costs to update custom systems *** Requires EMSMTP.DLL

  • [ ]  EM_BULK_STMNT

    • [ ]  EMSMTP.DLL copied across.

  • Switch Description

    Enables new bulk emailing of statements. *** Standard stationery users only.  Additional costs to update custom systems *** Requires EMSMTP.DLL

  • [ ]  JT_SURVEY_BULK_EMAIL

  • Switch Description

    Bulk emailing of quotes for a customer. Use a grid to search for quotes that match then select them and send as attachments to one email instead of multiple emails with only one attachment.


EMiR Setup Options

  • [ ]  Add the SMTP server address to Data | Setup | System Options | SMTP Server Setup.

  • [ ]  In Data | Setup | System Options | Set SMTP Information you can either leave Set Credentials By User ticked, in which case user's individual email addresses and passwords will need to be entered in EMiR Users (once you click edit, a Bulk Email button will appear) or tick it and enter a single address.

    • [ ]  Credentials by user.
    • [ ]  Service account.

      • Credentials

        Email:

        Password:

  • [ ]  Set the From and Reply addresses they want (usually accounts@) in Data | Set Up | System Option | Bulk Email Setup for each type of email. The client will also need to set the email body text here.


Testing

Bulk emailing will be available via Reports | Bulk Email

To test, replace the Accounts Email for a supplier to your own and email yourself.

If there are no emails batched for emailing. Open BATCHED.dbf and recall some deleted records.


Troubleshooting

The logs are in {app_dir}\files\logs by default. (MKE file path is missing the last backslash, it's in q:\mke\fileslogs for them)

The two files are easymail.{date}.log and sendemail.{date}.log


Note that account passwords only show if the following record is in MISCCFG.DBF:


VALUENAME = SMTPShwPwd
VALUEBOOL = TRUE