468,770 Members | 1,917 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,770 developers. It's quick & easy.

Dynamic html email to customer list - best approach

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: jo**@catco.com) 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
Jul 19 '05 #1
2 2071
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
"jason" <ja***@catamaranco.com> wrote in message
news:OU**************@TK2MSFTNGP09.phx.gbl...
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: jo**@catco.com) 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

Jul 19 '05 #2
Thanks......that confirms my POV...

Cheers
Jason

"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:up**************@TK2MSFTNGP12.phx.gbl...
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
"jason" <ja***@catamaranco.com> wrote in message
news:OU**************@TK2MSFTNGP09.phx.gbl...
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: jo**@catco.com) 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


Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by mr_burns | last post: by
reply views Thread by Matt Silberstein | last post: by
3 posts views Thread by Matt Silberstein | last post: by
26 posts views Thread by Jerim79 | last post: by
9 posts views Thread by pbd22 | last post: by
2 posts views Thread by Peted | last post: by
1 post views Thread by Marin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.