February 10, 2010 at 7:09 am
One of my clients needs to send hundreds of individualized emails to their customer base on a regular basis. Sending out these email involves looping through a recordset in VBA, which ties up the front-end Access app for the duration of the sending process. It sends directly to the email server using CDO.
I want to offload the sending process to either Sql Server or a VB.net dll.
An advice on the pros and cons of these two options would be much appreciated.
TIA.:-)
February 10, 2010 at 7:29 am
TBIG (2/10/2010)
One of my clients needs to send hundreds of individualized emails to their customer base on a regular basis. Sending out these email involves looping through a recordset in VBA, which ties up the front-end Access app for the duration of the sending process. It sends directly to the email server using CDO.I want to offload the sending process to either Sql Server or a VB.net dll.
An advice on the pros and cons of these two options would be much appreciated.
TIA.:-)
VB.NET dll if you mean Asp.net then you cannot use CDO because that team depreciated CDO in 2005 but you can use Asp.net to send mail automatically, coding required. You could also use SQL Server which I think may use CDO so it sometimes runs into load issues, there is no such problem in Asp.net. If you need implementation detail of Asp.net post again, known issues your hosting company could create more coding needs.
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply