Hi,
I've develop an ASP "Order" page, where you can enter typical info like firstname, lastname, phone, email, product items, etc... now, these info are inserted onto and SQL Server 2000 database/table. I then have a trigger which also inserts all these info as a huge STRING onto a temp table, i then use xp_sendmail to send this string as an "email-receipt" back to the client (base on the email add that he/she entered) confirming all the info that he/she has entered are correct.
The email that the client receives is a text base email, so sometimes the formatting goes awry, depending on what email service that the client is using.
I want to be able to format this huge String into maybe an HTML, and maybe even add effects like graphics, diff fonts etc...so that when the client receives it, their email service will automatically view it in the proper format.
Is there a way to do this? I know that this can be done bec, i always receive those "Auto-generated" emails which are formatted in HTML.
thanks for any suggestion!
I've develop an ASP "Order" page, where you can enter typical info like firstname, lastname, phone, email, product items, etc... now, these info are inserted onto and SQL Server 2000 database/table. I then have a trigger which also inserts all these info as a huge STRING onto a temp table, i then use xp_sendmail to send this string as an "email-receipt" back to the client (base on the email add that he/she entered) confirming all the info that he/she has entered are correct.
The email that the client receives is a text base email, so sometimes the formatting goes awry, depending on what email service that the client is using.
I want to be able to format this huge String into maybe an HTML, and maybe even add effects like graphics, diff fonts etc...so that when the client receives it, their email service will automatically view it in the proper format.
Is there a way to do this? I know that this can be done bec, i always receive those "Auto-generated" emails which are formatted in HTML.
thanks for any suggestion!