I have been asked to create an application to automatically send emails when
a date is reached. These dates are in a table in a database.

How would I approach this since I have never done something like this.

Any direction is appreciated it.

Thanks

Gene

Well if the app is going to be running all the time, you will need a timer
set up to check the date every now and then. Otherwise, if it is just run
once/day then check it when it is launched.

For each person that gets an email when the dates match, create an instance
of SmtpMail with the right server and then use SmtpMail.Send(from, to,
subject, body). All those are strings. The .NET Framework handles all the
SMTP server code from there.

"Gene Ariani" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have been asked to create an application to automatically send emails
when
> a date is reached. These dates are in a table in a database.
>
> How would I approach this since I have never done something like this.
>
> Any direction is appreciated it.
>
> Thanks
>
> Gene
>
>

Hello,

"Gene Ariani" <(E-Mail Removed)> schrieb:
> I have been asked to create an application to automatically send
> emails when a date is reached. These dates are in a table in a
> database.

You can check 'DateTime.Now' using a timer and send the mails using .NET
classes:

http://www.mvps.org/dotnet/dotnet/samples/net/
-> "SendMail"

HTH,
Herfried K. Wagner
--
MVP · VB Classic, VB.NET
http://www.mvps.org/dotnet

Stephen;

Thank you very much for taking the time to answer my post. I will follow
your advice.


Gene


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Herfried;

Thank you very much for taking the time to answer my post. I will follow
your advice.


Gene




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!