Skip to main content
Known Participant
December 3, 2007
Question

Dynamic email based on DB?

  • December 3, 2007
  • 2 replies
  • 338 views
I have CDO set up that I can mass email from a Access DB and it works fine. My client would like to be able to send HTML based email. (I have created a HTML email) How can I allow the client to send HTML email without having to code in the body of the email. I would like to allow the client to basically create the info. for the body and then have it insert into the HTML and then send the HTML out.

I am using Dreamweaver CS3, ASP, Access and VBScript.

How can I dynamically based on the DB allow the client to simply type the body of the email and save it to the DB then have the body added to the HTML code after it calls the info. from the DB and send it out in HTML only so it displays in the email as basic HTML.

I hope that I have explained this good enough.

thanks
B
This topic has been closed for replies.

2 replies

Inspiring
December 5, 2007


"theMachien" <webforumsuser@macromedia.com> wrote in message
news:fj1hnf$l3i$1@forums.macromedia.com...
> I have CDO set up that I can mass email from a Access DB and it works
> fine. My
> client would like to be able to send HTML based email. (I have created a
> HTML
> email) How can I allow the client to send HTML email without having to
> code in
> the body of the email. I would like ot allow the client to basically
> create
> the info. for the body and then have in inserted into the HTML and then
> send
> the HTML out.
>
> I am using Dreamweaver CS3, ASP, Access and VBScript.
>
> How can I dynamically based on the DB allow the client to simply type the
> body
> of the email and save it to the DB then have the body added to the HTML
> code
> after it calls the info. from the DB and send it out in HTML only so it
> displays in the email as basic HTML.
>
> I hope that I have explained this good enough.

I'm not sure what you're asking, it seems you have a good idea about the
process.

In essence you would do exactly as you say, save the body in your database
and construct the complete HTML document using that snippet from your
database.

strBody = "<html><head></head><body>" & BODY_FROM_DATABASE &
"</body></html>"

Known Participant
December 5, 2007
Anyone?