HTML filled by SQL

[FPiet]

Hi,

Is there anyone who can help me by the following.
We would like to send our customers an email in HTML.
But at Dear ..... the dots must become the name of the custommer filled from a database (SQL)
Also I want the fill out a callnumer in the mail.

I hope some one understands my question and can help me.

 

[Foamcow]

You need to use a server side language such as PHP to send a query to the database and retrieve the data.
Then you use the same language to loop through your insert the relevant info into your HTML template and send the email.

Since you are asking this question I'll bet there are a ton of things you haven't considered that will land you in hot water one way or another (logistically and legally).

Have you thought about using a service like Mailchimp?

http://www.mailchimp.com

I would strongly advise that, at the very least, you read some of the guides available on that site.

--
Tek-Tips Forums is Member Supported. Click Here to donate

<honk>*:O)</honk>

Tyres: Mine's a pint of the black stuff.
Mike: You can't drink a pint of Bovril.