Garry Robinson and Scott McManus show how they accepted
orders placed for their company’s software through an online
ordering system. With some Access code that links to Outlook,
they process those orders automatically.
ONE of the most important components of running
a Web site is the ability to accept orders from
customers. Anyone who has successfully
completed a secure Web site ordering system has my
full admiration. It isn’t easy to achieve. If you then had
a large number of customers who used that ordering
system successfully, you and your team are geniuses.
For the rest of the Web sites in the world, the safest and
easiest way to add an ordering system is to use one from
a reputable third party.
This article shows how to read an order that arrives
as an e-mail, store that information in your database,
prepare an e-mail to inform your new customers that
you’ve received their order, and then move that e-mail
to another folder upon completion. The example that
we’ve presented is designed to accept orders from
DigiBuy.com, a third-party secure ordering Web site
with many thousands of software developers as its
clients. While this article is specific to DigiBuy.com,
the code that we use here could be applied to any Web
form or software system that produces text (e-mail) in
a consistent format.
Preparing an e-mail
When we first thought about writing this article, we
wondered how readers could get a sample e-mail order to
try with our demonstration software. We solved this by
building a sample order in text that you can e-mail to
yourself. To generate such an e-mail, we wrote some code
to create an instance of Outlook and then create a new
Dim appOL As Outlook.Application
Dim testEmail As Outlook.MailItem
Set appOL = Outlook.Application
Set testEmail = appOL.CreateItem(olMailItem)
testE-mail.Subject = "Add your own e-mail address"
We generate a test order through a function that
reads a text file. As in many previous articles, we use the...
Read more in the pdf article here