hey people..i need some help in solving this problem..i have no idea how to start this because i've not done this before..
any help is appreciated.. :)
i'm doing this IT Helpdesk system for my project..
what i'm suppose to do now is : i have to auto generate an email everyday at 9am and 5pm to a supportstaff with the ticket details which status is not equal to close :)
DC517 Don't forget to click "Mark as Answer" on the post that helped you.
This credits that member, earns you a point and marks your thread as Resolved.
if SQL server database is involved in your case then its very easy without any program just write a query to send emails and schedule it using job schedular Read my article
hey mudassarkhan..thanx for replying..your post seems quite useful..i just want to check if its possible to do this without using stored procedures??because i'm not using stored procedures for my project.. :)
hey mudassarkhan..thanx for replying..your post seems quite useful..i just want to check if its possible to do this without using stored procedures??because i'm not using stored procedures for my project.. :)
BabyAngel
Member
80 Points
226 Posts
Sending of email!
Apr 23, 2009 01:54 AM|LINK
hey people..i need some help in solving this problem..i have no idea how to start this because i've not done this before..
any help is appreciated.. :)
i'm doing this IT Helpdesk system for my project..
what i'm suppose to do now is : i have to auto generate an email everyday at 9am and 5pm to a supportstaff with the ticket details which status is not equal to close :)
how do i start about doing this??
please help..thanx!(:
d4dennis@ins...
Star
9229 Points
1314 Posts
Re: Sending of email!
Apr 23, 2009 02:28 AM|LINK
Hi There,
Have a look at this article. would give you guideline from where to start.
http://msdn.microsoft.com/en-us/magazine/cc163821.aspx.
Let meknow if you furthur help!
Don't forget to click "Mark as Answer" on the post that helped you.
This credits that member, earns you a point and marks your thread as Resolved.
mo meng
Contributor
6700 Points
1351 Posts
Re: Sending of email!
Apr 23, 2009 02:45 AM|LINK
write an window program e.g. and schedule it to run at the desired time
BabyAngel
Member
80 Points
226 Posts
Re: Sending of email!
Apr 23, 2009 03:20 AM|LINK
window program??
what's that?how do i start doing that??
please help.. :(
malcolms
All-Star
18687 Points
3124 Posts
MVP
Re: Sending of email!
Apr 23, 2009 05:29 AM|LINK
For an article on sending mail check out this site:
http://www.systemnetmail.com
A windows form is an application like Word or Excel.
mudassarkhan
All-Star
78956 Points
13402 Posts
MVP
Re: Sending of email!
Apr 23, 2009 05:44 AM|LINK
if SQL server database is involved in your case then its very easy without any program just write a query to send emails and schedule it using job schedular Read my article
http://www.aspsnippets.com/post/2009/03/08/Automated-Email-Notifications-using-SQL-Server-Job-Schedular.aspx
Contact me
BabyAngel
Member
80 Points
226 Posts
Re: Sending of email!
Apr 23, 2009 06:02 AM|LINK
hey mudassarkhan..thanx for replying..your post seems quite useful..i just want to check if its possible to do this without using stored procedures??because i'm not using stored procedures for my project.. :)
mudassarkhan
All-Star
78956 Points
13402 Posts
MVP
Re: Sending of email!
Apr 23, 2009 06:08 AM|LINK
Yes definately you can schedule your query too
Contact me
BabyAngel
Member
80 Points
226 Posts
Re: Sending of email!
Apr 23, 2009 06:20 AM|LINK
i'm so sorry,,
but i need your help in this..
how do i schedule my query to this??
mudassarkhan
All-Star
78956 Points
13402 Posts
MVP
Re: Sending of email!
Apr 23, 2009 06:26 AM|LINK
In the step 4 in my article just paste your query instead of stored proc
Contact me