Populating HTML file with data from table

  • Thread starter Thread starter dbguru316
  • Start date Start date
D

dbguru316

I have an HTML template that I would like to populate with data from an
Access table. What is the best way to achieve this? An example is as
follows:
<html>
<head>
<title>Shipment Notification</title>
</head>

<body>
<p>
Your order <<ORDERNUMBER>> has shipped. The tracking number is
<<TRACKINGNUMBER>>.
<p>
</body>

</html>

I want to look up "<<ORDERNUMBER>>" and "<<TRACKINGNUMBER>>" in the Access
table and populate these areas with this information, then use this in the
body of an e-mail. The process would be to go to the first record of the
table, populate the template, send e-mail, then goto 2nd record in table, and
repeat until all records have be processed.

This seems pretty simple, but cannot figure out the code in VB.
 
the template is used for an html body. The code now works marveoulsy!!

Thanks Alex
 
Back
Top