Northwind
 Company Overview
 Contact

Products
 PDXPro
 OLServices
 DBFPack
 ToolTip Foundry
 NWPopup
 XpertSS

Unisource Converting manufactures envelopes, drinking straws and coffee stirrers. Based in Jacksonville, Florida its busy plant produces up to 22 million units per day in a wide range of designs and sizes. Servicing a large number of customers daily in this fast moving environment makes customer relations management an important aspect of its business.

Customer orders are maintained in a Microsoft SQL Server database and for many years, order entry has been through applications developed in Lotus Approach by Jerry Sikes, Unisource's principal programmer. The business has outgrown Approach and Jerry has been busy migrating these applications to a front-end he is developing with Microsoft .Net.

A key part of the migration exercise was to develop an automated order confirmation system by e-mail. It was soon discovered that the size of these e-mails, including the HTML formatting characters, far exceeds the maximum allowed for a SQL Server, stored procedure variable and precluded the use of SQL Server, CDONTS and a SMTP server to generate the confirmations

It was at this point that Jerry Sikes approached Northwind to see if OLServices, in conjunction with Microsoft Outlook, could provide a front-end system. OLServices can create HTML formatted e-mails without any size limitations and quickly proved to be the ideal solution.

Unisource Converting is delighted with the outcome and has kindly provided a testimonial to this effect. A short extract is given below but please click here to read the complete document in PDF format

I wanted to personally let you know how pleased our company is with your OLServices product. It has become a vital tool in our customer relations management system. In one application we us OLServices to provide customer order confirmations...... The customers required we confirm the order, items, pricing and availability. In the past we did this by fax after data entry. This required making a copy of the order, adding comments and faxing to the customer. Quite time consuming for our data entry clerks. Now with OLServices and Microsoft Outlook, the data entry application creates an HTML formatted e-mail confirmation, at the moment of data entry...... The increased employee productivity is great but more importantly the customer response is fantastic. We have received nothing but positive feedback from the hundreds of companies we serve.

Copyright © 2000 - 2004 Northwind IT Systems. Terms of Use. Privacy Policy. All Rights Reserved.