Anyone interested in quoting for this solution?

Use this forum if you have installed hMailServer and want to ask a question related to a production release of hMailServer. Before posting, please read the troubleshooting guide. A large part of all reported issues are already described in detail here.
Post Reply
matthew230
New user
New user
Posts: 1
Joined: 2020-06-02 22:31

Anyone interested in quoting for this solution?

Post by matthew230 » 2020-06-02 22:36

Hi,

I have a project which we think may be solved by using Hmailserver and VBscript\jscript.

Interested to receive any quotes\interest in providing the below.

Please contact me with any queries etc,

Matthew

>>>>

Looking for a solution to categorise incoming emails that contain machine unique IDs, with readable ID's, so users can more easily match the email to the individual.

We have a large number of emails that come in as notifications from specified web forms. These contain an alphanumeric code within the message body.

We want to be able to extract a small amount of data from a SQL Server database, dependant upon the code, and append that information to the subject of the email, and then forward it on.

The SQL Server can just be a scalar function that we will write.

We view a potential solution to use HMailserver that allows for Vbscript/Jscript rules to be applied, and require the script to be written.

We intend to set up Hmailserver on an alternative server with a different domain to the end target.

For example the email would come into: emailbox1@pre.domain.com.

From this, we want the script to scan the message body for the unique ID. This is follows a regular format, so should be straightforward. For example, the unique ID = "Q123DR"

We then require to use SQL Server to call a scalar function, using the ID as the variable.

The result of the function needs to be added to the subject field of the email, and then forwarded to the final destination, which uses the prefix of the original mail, and just changes the domain, eg: emailbox1@post.domain.com

For extra points, having a configuration file that matches up pre and post domains would allow for future expansion, but for now the pre and post domain can be fixed.

Post Reply