Dynamic html email to customer list - best approach

[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: john@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

[Ray at]

Re: Dynamic html email to customer list - best approach

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" <jason@catamara nco.com> wrote in message
news:OUjT3RojDH A.2444@TK2MSFTN GP09.phx.gbl...[color=blue]
> What is the best way to build a dynamic html body message if one is[/color]
looping[color=blue]
> 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: john@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
>
>[/color]

[jason]

Re: Dynamic html email to customer list - best approach

Thanks......tha t confirms my POV...

Cheers
Jason

"Ray at <%=sLocation% >" <myfirstname at lane34 dot com> wrote in message
news:upLxqaojDH A.2200@TK2MSFTN GP12.phx.gbl...[color=blue]
> 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[/color]
object.[color=blue]
>
> sBody = '''code to generate body here
>
> ''code to retreive e-mail addresses
> Do....
> ''create message
> .htmlbody = sBody
> Loop
>
> Ray at work
>
>
> "jason" <jason@catamara nco.com> wrote in message
> news:OUjT3RojDH A.2444@TK2MSFTN GP09.phx.gbl...[color=green]
> > What is the best way to build a dynamic html body message if one is[/color]
> looping[color=green]
> > 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: john@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[/color][/color]
has[color=blue][color=green]
> > completed a similiar mailing model?
> > Jason
> >
> >[/color]
>
>[/color]