E.V.I.C.T. B.V. DBPublisher is a Database Publishing Component

E.V.I.C.T. B.V.

Edwin Vermeer Information Communication Technology.

home / open source software / DBPublisher

DB Publisher
For end users

This application is still in development. You will be able to maintain a list clients (or whatever info you have) and send a personilised email to all.

For developers

You will get an ActiveX dll that you can use from almost any programming language with support for ActiveX dll libraries. With this library you will be able to send databas driven email mailings from within your own application using only a couple of lines of code plus an email template.

At the right you can see how a .htt template is structured. This sample shows you most template options. Usually templates are less complex. For email templates the HTT-PARAMETERS section will have more parameters. See the suplied samples for more information.

Click here to download the library plus the complete source code (Visual Basic) of that library and some samples.

Planet
Source
Code
Superior
Coding
Contest
Winner


<!-- HTT-PARAMETERS>
    DSN          = Provider=Microsoft.Jet.OLEDB.4.0;Data Source=NorthWind.mdb;Persist Security Info=False
    Recordset    = Select * from Demo
    PageGrouping = CustomerID
    TargetDir    = ../samples/
</HTT-PARAMETERS -->

<html>
    <title>All <%CompanyName%> orders</title>
       <%INCLUDE header.htt%>
       <center>
            <table>
                <tr><td colspan=99 class=footer1>This page was generated on <%Date%> at <%Time%> by '<%App.ProductName%>'
                    version <%App.version%><br><br></td></tr>
                <tr><td colspan=99><%INCLUDE orders.htt;CustomerID=CustomerID%></td></tr>
                <tr><td><br> </td></tr>
                <%GROUP OrderID%>
                    <tr><td colspan=6 class=header2><a name="<%OrderID%>"></a>Order : <%OrderID%> date : <%OrderDate%></td>
                        <td colspan=4 class=header2>Class variables</td></tr>
                    <tr><td class=tdheader>Product</td><td class=tdheader>category</td><td class=tdheader>Quantity</td>
                        <td class=tdheader>Unit price</td><td class=tdheader>Discount</td><td class=tdheader>Price</td>
                        <td class=tdheader>Counter</td><td class=tdheader>Even</td><td class=tdheader>In group</td>
                        <td class=tdheader>Greenbar</td></tr>
                    <%GROUP DetailSection%>
                        <tr>
                             <td class=tdcel0><%ProductName%></td>
                             <td class=tdcel0><%CategoryName%></td>
                             <td class=tdcel0><%Quantity%></td>
                             <td class=tdcel0><%UnitPrice%></td>
                             <td class=tdcel0>- <%Discount%></td>
                             <td class=tdcel0><%Price%></td class=tdcel0>
                             <td class=tdcel<%EvenRecord%>>(<%RecordNumber%>)</td>



                             <td class=tdcel<%EvenRecord%>>(<%EvenRecord%>)</td>
                             <td class=tdcel<%Greenbar%>>(<%CounterInGroup%>)</td>
                             <td class=tdcel<%Greenbar%>>(<%Greenbar%>)</td>
                        </tr>
                    <%ENDGROUP%>
                    <tr><td colspan=6 class=footer2>Total items : <%OrderLinePrice%> Freight : <%OrderFreight%>
                        </td><td colspan=4 class=footer2> </td></tr>
                    <tr><td><br> </td></tr>
                <%ENDGROUP%>
                <tr><td colspan=99 class=footer1><a href=http://<%HomePage%>><%App.LegalCopyright%>
                    </a> (Homepage)</td></tr>
                <tr><td colspan=99 class=footer1><a href=mailto://<%eMail%>>Edwin Vermeer</a>
                    (eMail)</td></tr>
            </table>
        </center>
    </body>
</html>