November 14, 2007 at 12:52 am
Hello!
This is my first post and may be a bit off-topic, but i hope you can still help me.
So the situation is, that I want to send mail with ASP code.
I have all the subject,message, email-addresses etc. stored in the database ( SQL Server 2000 Enterprise) and now I am wondering how can I send that data with forward? Can I use SQL_Mail some how here?
November 14, 2007 at 5:49 am
I don't know about ASP, but with Access I can use VB to enter my parameters and execute my mail procedure from a form. I use one called send_cdosysmail, but I see a lot of folks here using xp_sendmail. As long as you have all your ducks lined up in a table it should be no different from executing any other procedure from your app.
Greg
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
November 14, 2007 at 5:55 am
How do you trigger the mail / how do you assign, for example, the To field with Access? I bet the commands are quite similar.
November 14, 2007 at 11:05 am
ilhuhtin (11/14/2007)
How do you trigger the mail / how do you assign, for example, the To field with Access? I bet the commands are quite similar.
For most of the emails I have made an email staging table containing fields for all the stuff necessary to send an email, including a delivery_dt and sent_dt column. I have triggers on various tables that populate the email staging table, then most of them get sent via a job at night. For ones here and there, however, I have a form that looks like an email template, with text boxes for the To, Cc, From, Subject, and Body fields. Then, when I fill out the form those values are passed as the parameters needed for my email procedure when I hit the send button. The send button has an on click event, basically like follows.
Dim strSQL as String
strSQL = 'EXECUTE send_cdosysmail '" & me.txtTo & "', '" & me.txtFrom & "',...
DoCmd.RunSQL strSQL
you get the idea if you know Access. Very simple.
If you know how to pass parameters to SQL Server from .ASP ( I don't), then once you set up your email procedure it should be no problem.
Greg
P.S. What I should have included in the above is that I have a users table, so whenever I add a login I enter it in the users table that has the first name, last name, login_nm (master.sysxusers.name) and email. That way, if a table houses information that may require email notification, I add column entered_by default system_user, and my trigger can populate the email staging table with the users email address as the to field.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
November 15, 2007 at 1:34 am
Excelent, that seems quite simple. I will try this tonight.
Thanks alot!
November 19, 2007 at 6:07 am
If your ASP page is 2.0 then you may want to look at
Imports System.Net.Mail
Start with
Dim message As MailMessage = New MailMessage
MISfIT
November 19, 2007 at 2:14 pm
Aye, got it working. Thanks a lot for the help!
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy