Populating HTML file with data from table

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.
 
D

dbguru316

the template is used for an html body. The code now works marveoulsy!!

Thanks Alex
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to export table from outlook into ms access table? 0
Access, OLE, and WEB View 5
Exporting Access Data into Email Body 1
Up For Reviewing Complex-ish Button Automation Code? Here Ya Go... 0
This HTML won't work!! 5
The table HTML element 2
Exporting a Report to Html template 1
Outputting data to HTML - Please help! 7

Top