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
 

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
Up For Reviewing Complex-ish Button Automation Code? Here Ya Go... 0
Access, OLE, and WEB View 5
Exporting Access Data into Email Body 1
populate word template from access table 2
Update 2 tables via Check Box in Form 1
VBA - retrieve data on last create named range from previous inserted named range 0
This HTML won't work!! 5

Back
Top