Newsletter template and Access database

Question:

---

I have a newsletter template with content from an Access database.
When I'm sending my newsletters, all special characters in the layout are shown properly, but in the content, which comes out of the db, they get replaced by ÿ or ?.
I've selected 'Western European' as charset in the page that has the submit-button.
In the newsletter page, I've defined also charset="iso"-8859-1. I'm using ASPEmail, but I also tried CDO and CDONTS.
Unfortunately, nothing seems to work.

Answer:

---

When you enter your access database field as mail body, surround it with Server.HtmlEncode()

for example if you have:

myRS.Fields.Item("mail").Value

make it:

Server.HtmlEncode(myRS.Fields.Item("mail").Value)

---

DISCLAIMER 

This is extra complimentary content which purpose is to show additional usage that is not part of the product, i.e. it suggests tips for extending the functionality of the product by the users themselves. It is provided "as is", without warranty of any kind, express or implied , including but not limited to the warranties of merchantability, fitness for a particular purpose and nonfringement of third party rights.

DMXzone does not take responsibility to support the suggested content to be fully compatible and working as intended and does not provide support for extended functionality which is not included in the current release of the extension.

It is highly recommended that only more advanced developers use it.