I am running a jobs/motors and property website for a newspaper. I am looking to setup email alerts for these websites. Such as email me jobs like these, email me cars like this and email me properties like these.
The average character length of the email exceeds around 16000. Therefore making direct emailing from sql a non option (due to restrictions of the nvarchar field in the message body).
Therefore I have come up with the conclusion that I need to design a windows app that is permanently running with has a scheduler which runs daily that pulls info from the database and uses a component such as smtp.net to send out the emails.
Is this the right way of doing this.