Dynamic html email to customer list - best approach

J

jason

What is the best way to build a dynamic html body message if one is looping
through a customer table (=/=500 customers) and corresponding inventory
table:

1. FSO html template with paramters
2. Build the thing in the .HTMLbody of CDO while looping
3. Another elegant method....

The customer email (TO: (e-mail address removed)) would look something like this:

Yacht: Amazing Grace
-----------------------

Original Price: 100,000
Reduced Price: 80,000
Date of Change: 12/12/2003

Yacht: Ocean Speed
-----------------------
Original Price: 80,000
Reduced Price: 70,000
Date of Change: 12/12/2003

rs.movenext
Thanks in advance for any advice you can give me...is there anyone who has
completed a similiar mailing model?
Jason
 
R

Ray at

If I understand you right, build the body in a variable and then loop
through and use that variable as the .htmlbody for each cdo.message object.

sBody = '''code to generate body here

''code to retreive e-mail addresses
Do....
''create message
..htmlbody = sBody
Loop

Ray at work
 

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

Members online

No members online now.

Forum statistics

Threads
474,126
Messages
2,570,750
Members
47,307
Latest member
Wimble

Latest Threads

Top