Dbmail Doesn't Rely On IIS SMTP, How To Set Bounced Email Redirect Email Etc.? Thanks

May 4, 2007

Under IIS SMTP I can set bounced email redirect etc. how to do that with dbmail, the idea is I can get the list of bounced emails somewhere so I can create a report.



Any idea?



thanks

View 2 Replies


ADVERTISEMENT

Using IS For Email Notification With Gmail Smtp

Nov 12, 2007



Hi,

I want to setup a SMTP using gmail. How to configure it, it says,


In your email client software, under Outgoing mail, set the SMTP server to smtp.gmail.com.
Set the your username is yourgooglemailname@gmail.com and make sure "Use username and password" is checked.
Also check off "TLS" under "Use secure connection."
I tried to do this in code:


Dim htmlMessage As MailMessage

Dim mySmtpClient As SmtpClient

htmlMessage = New MailMessage(From, SendTo, Subject, Body)

htmlMessage.IsBodyHtml = IsBodyHTML

mySmtpClient = New SmtpClient(Server)

Dim myCred As New System.Net.NetworkCredential("myemail@gmail.com", "mypassword") 'CredentialCache

mySmtpClient.UseDefaultCredentials = False 'Credentials = System.Net.CredentialCache.DefaultNetworkCredentials

mySmtpClient.Credentials = myCred

mySmtpClient.Send(htmlMessage)



however, i cannot do the turning off of TLS in code. I'm often prompted with this error once i run:

The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Must issue a STARTTLS command first

Anyone who knows how to do this?


cherriesh

View 1 Replies View Related

Generate A Email Using Smtp Server (was Help With Query....)

Jan 21, 2005

Help with query: I currently cannot be alerted by SQL Mail so I would like to take the script that was generated by SQL server and using the store procedure sp_sqlsmtpmail to generate a email using smtp server to alert me. The store procedure does work. I would like to know if this is possible.

Thanks

Lystra


-- Script generated on 1/21/2005 10:04 AM
-- By: MAMSIsa
-- Server: (local)

IF (EXISTS (SELECT name FROM msdb.dbo.sysalerts WHERE name = N'Demo: Full tempdb'))
---- Delete the alert with the same name.
EXECUTE msdb.dbo.sp_delete_alert @name = N'Demo: Full tempdb'
BEGIN
EXECUTE msdb.dbo.sp_add_alert @name = N'Demo: Full tempdb', @message_id = 9002, @severity = 0, @enabled = 1, @delay_between_responses = 10, @include_event_description_in = 5, @database_name = N'tempdb', @category_name = N'[Uncategorized]'

Then

Exec sp_sqlsmtpmail
@vcTo = 'lwilliams@Huc.com',
@vcBody ='Check out problem Immediataly.',
@vcSubject ='DOCSITE01FDK - Full Tempdb Log'

END

View 2 Replies View Related

Why Do I Get The Following SMTP Email Error In A SSIS Package

Mar 2, 2007

I am running a SSIS package under a trusted account and I am running into a problem when I am executing a email task. The error is an operation timeout which was reported in the log. I am using windows authentication on the connection manager. Other email task configured the exact same way run correctly in the same run. Also when I execute task from BIDS the email is sent. Is there a bug in SSIS which would cause this behavior or some kind of exchange server configuration issue? Any help would be appreciated. Thanks, Greg

View 5 Replies View Related

How To Send Email Using Asp.net 2.0 And How To Find The Smtp Mail Server Name?

Dec 19, 2006

How to send email using asp.net 2.0 and how to find the smtp mail server name?

View 1 Replies View Related

Integration Services :: Configure SMTP Server To Connect To GMAIL In Local System To Use Send Email Task

Sep 15, 2015

I am doing some ssis package development in my local machine. I have a requirement to send email the output.

I am developing in my local machine. Is it possible to configure SMTP configuration in my local system to receive the email in Gmail?

if yes, what all are the steps to be followed.

View 3 Replies View Related

Reporting Services :: Data Driven Email Subscription With Different Email Per Report Page

Jul 6, 2015

I have a report that gets sends out through a subscription and sometimes the report has multiple pages and all those pages appear within one email.Is it possible to set the subscription in such a way that an email is sent per page when the subscription executes.

View 2 Replies View Related

Help Split List Of Email Add Comma For Evry Email

May 12, 2008

need help
split list of email add comma for evry email
i have tabe "tblLogin" and in this table i have field emall
like this

emall
-----------------------------------------
aaa@hhhh.mm
nnn@hhhh.mm
mmm@hhhh.mm

need to do ilke this



Code Snippet
@list_email = (SELECT emall FROM tblLogin)

--------------------------i get this
-----------------------@list_email=aaa@hhhh.mm ; nnn@hhhh.mm ; mmm@hhhh.mm

@recipients = @list_email










Code Snippet

IF EXISTS( SELECT * FROM [db_all].[dbo].[taliB] )



BEGIN

DECLARE @xml NVARCHAR(MAX)DECLARE @body NVARCHAR(MAX)

SET @xml =CAST(( SELECT

FirstName AS 'td','',

LastName AS 'td','' ,

Date_born AS 'td','' ,

Age AS 'td','' ,

BirthdayToday AS 'td','' ,

BirthdayThisWeek AS 'td'

FROM [Bakra_all].[dbo].[taliB] ORDER BY LastName FOR XML PATH('tr'), ELEMENTS ) AS NVARCHAR(MAX))

SET @body ='<html><H1 align=center>aaaaaaaaaaaaaaaaaaaaaa</H1><body ><table border = 1 align=center dir=rtl>

<tr>

<td>name</td>

<td>fname</td>

<td>date</td>

<td>age</td>

<td>aaaaaaaaa</td>

<td>bbbbbbbbbbbbbbb</td>

</tr>'

SET @body = @body + @xml +'</table></body></html>'

EXEC msdb.dbo.sp_send_dbmail

@recipients =N'rrr@iec.co.il',

@copy_recipients='rrrrr@iec.co.il',

@body = @body,

@body_format ='HTML',

@subject ='ggggggggggggggggggggg',

@profile_name ='ilan'

END

ELSE

print 'no email today'

View 1 Replies View Related

SSRS 2005 - Linked Report Email Doesn't Have Https

May 19, 2008

I've got a report server that I recently inherited. I'll be the first to admit that I'm not an expert on SSRS, but I've figured out a lot in the past few weeks.

One issue I'm having (apparently it's always been there, but nobody ever bothered to fix it in the past) has to do with the report subscriptions and linked reports. We have an SSL cert inside IIS. I have SSRS configured to "require SSL connections" in the Report Server Virtual Directory tab.

So the user gets an email with a link to a report. But the link has an "http://" as opposed to "https://." When you click on the link, it throws your standard "page must be viewed on a secure channel." When I manually append an S to the url, it works great.

There has to be a way to automagically add the S to the url, but I can't seem to figure out how. Anyone ever run into this before? Google has not been good to me this morning either.

View 1 Replies View Related

Integration Services :: Send Email When Execute Task Stops But Doesn't Error?

Oct 13, 2015

I'm trying to put together an SSIS package that will look in one directory for 2 distinctly named .csv files.  The files will then be loaded into 2 tables. 

The first task I execute is a SQL Task that checks to see if the tables I'm loading the data into are empty.  If the tables have data, the package stops executing.  If they are empty, the package continues to execute.

What is the best way to send an email out from SSIS if the package stops on the first step? 

View 10 Replies View Related

Load A Text File With Email Addresses And Compare Against A Database Table That Has Email Addresses And User_id

Jul 12, 2007

Hello ALL



what I want to achieve is to load a text file that has email addreses from disk and using the email addresses in the text file look it up against the email addresses in the database table then once matched delete all the users in the table whose email address were in the text file.



I also want to update some users using a different text file.



Please help me with the best way to do this



Thanks in advance

View 6 Replies View Related

Default SMTP Virtual Server Node In IIS Not Visible Even After Installing SMTP For IIS

Apr 10, 2007

Hi,
I have RS 2000 running on windows 2003 server. I want user to subscribe to reports and receive reports via email. Initially SMTP was not installed for IIS 6.0, so I installed it and the right way (I had done it on different machine before and was succefull in that) but on this particular machines ...I don't see "Default SMTP Virtual Server" node when I open IIS manager.
This is the third day I am working on this issue ..please help me out guys,
prashant

View 1 Replies View Related

Email From SQL

Sep 5, 2000

How do i get the email to be send automatically from SQL

My SQL Server is configured so if sends an email after running a job. The email is been succesfully sent by SQL, but is not atually sent until you login and start up Microsoft Outlook and client on Send and Receive.

Surely there is a way to get SQL to automatically send the message.

I have got outlook to send message immeditally.

My mail server is SendMail - SCO Open Server 5.06

Thanks

David

View 1 Replies View Related

SQL - Email

Mar 9, 2001

Is there a way SQL server to email/send a query results to a user ?

Thanks in advance.

Ivan

View 2 Replies View Related

Email From A Job

Aug 9, 2001

Trying to get a job step to send an email with an explaination in certain failure conditions. The problem is I want the recipient to be the job's operator.
don't know of a way to accesss the job's operator email address cleanly from inside a step

Any ideas?

View 2 Replies View Related

DTS- Email How TO

Sep 20, 2001

IF I HAVE ONE OR MANY PACKAGES HOW DO SEND AN EMAIL TO MY BOSS IF IT BLOWS UP?? ex. INPUT IS MY TRUNCATE STEP, CONNECTION 1 IS MY ODBC, CONECTION 2 IS WHERE THE RESULT WILL BE PLACED INTO. AT ANY ONE OF THOSE STEPS, It BLOWS HOW TO SEND AN EMAIL. THE EMAIL IS ALREADY SETUP BECAUSE I TESTED IT IN THE QUERY ANALYZER WITH THIS STATEMENT ( EXEC xp_sendmail @recipients = 'robertk;laurac',
@message = 'The master database is full.',
@copy_recipients = 'anned;michaels',
@subject = 'Master Database Status') AND IT WORKS.

View 2 Replies View Related

SQL Email

Jun 29, 2004

I want to write a stored procedure that will email Sales Associates and notify them if a customer has had a return number issed for return of defective product. I wanted to do this daily. I am using SQL Server 2000. Is there a way to get SQL to send an email without using Microsoft Exchange? I have a network that is using Workgroup mode and not domains. I can provide SQL a mailbox on our Linux mail server to send the mail.

View 1 Replies View Related

Email

Aug 23, 2004

Hi all me again I gotta question, the Sr executive asst has a number of reports that gets emailed to different department, only problem is those departments are on a totally different server. I am guessing that we need to start SQL AGENT Emailing MAPI to do this for us, of course I could be wrong. This is one of the stored procedures that creates one of the reports

CREATE PROCEDURE createSecurityListtobeEmailed
AS
SELECT SecurityListX."Last Name", SecurityListX."First Name", SecurityListX.MI, SecurityListX.Sex, SecurityListX.DOB, SecurityListX.IR#, SecurityListX."Issue Date", SecurityListX."Date served", SecurityListX.Duration, SecurityListX."Exp Date", SecurityListX."Reason for Exclusion", SecurityListX."Added Comment", SecurityListX.type INTO SecurityList
FROM SecurityListX
GROUP BY SecurityListX."Last Name", SecurityListX."First Name", SecurityListX.MI, SecurityListX.Sex, SecurityListX.DOB, SecurityListX.IR#, SecurityListX."Issue Date", SecurityListX."Date served", SecurityListX.Duration, SecurityListX."Exp Date", SecurityListX."Reason for Exclusion", SecurityListX."Added Comment", SecurityListX.type
HAVING (((SecurityListX."Last Name") Is Not Null))
GO

View 9 Replies View Related

Email Through SQL

Nov 17, 2004

I am trying to setup my sql to send automatic emails to different companies but I am not doing so well. The user puts an email address in the database and then presses a button (command button) that will execute a stored procedure xp_sendmail to a recepient. I need to know how to include read receipts and delivery receipts into the stored procedure, because right now its set up in his outlook as a rule to do this and I want to set it up in sql. The user deals with companies and these companies have several contacts with several email addresses which sql will store in a seperate table.

View 1 Replies View Related

Email

Feb 5, 2004

How can I implement the functionality of sending mail with the help of SP or DTS?
Subhasish

View 2 Replies View Related

Email From Ftp

May 31, 2007

I have tried a few different stored procedures but i'm looking for away to send email from a server that does not have email enabled. (I want to pass in the smtp server and email and password.

Does anyone know of any script?

View 4 Replies View Related

Sql &#043; Email

Oct 24, 2007

Hello everyone

I am working on a little project for work which get the relvant data every 2mins and puts the data into a Data Grid in ASP.net 2.0

Now my SQL scipt runs every 2min and i need to know if at a certain time i could tell the SQL script to run the report and email me the results???

any help would be great

thanks alistair

View 4 Replies View Related

Email

Mar 10, 2008

Quick question ..does DatabaseMail work in sql server express 2008.And if not ... is there a simple work around / solution to get thesame effect .. ie to send email out from sql expressRegardsRob

View 1 Replies View Related

Email

Dec 18, 2007

EXEC master.dbo.xp_sendmail
@recipients=N'myemailaddress@somewhere.com',
@message=N'job failed.' ;

Do you know why the following error is produced?
xp_sendmail: Procedure expects parameter @user, which was not supplied.

Thanks

View 4 Replies View Related

ERD Of An Email App

Mar 14, 2008

Hi, I've been asked to create a small application to send and receive emails with basic functionality like reply and forward
messages. All of them will be stored in a sql database.
I am mainly a programmer so I would like to know if you have any sample ERD I can use as a reference
or if you can help me define the entities, I am not sure how I need to handle the "replied messages" and "Forwarded messages"


Any help will be appreciated.

Armando.

View 5 Replies View Related

Email

May 17, 2007

I would like to automate a report to be emailed to an email address.
When viewing the report, clicked on new subscription.
In the subscription window what options should there be for Delievered By: ?
I currently have: Report Server File Share in the drop down. Should there be other entries in the list too?
Thanks

View 3 Replies View Related

Local Smtp Configure With Remote Smtp

Dec 24, 2005

Hello dear
i am using windows 2003 server where i have installed smtp server
now i want to configure with remote stmp so i can send an email to any domain.

So pls tell me how it will be done.
Thanks

View 4 Replies View Related

Send Email Through SQL

Sep 11, 2006

Hi all, can i send an email through SQL? i don't want to use third party software. Also, i can't configure the customer's db server. It is possible to send an email without much configuration. If configuration needed, is it possible to configure through SQL script? thx 

View 8 Replies View Related

Select_identity() Sent Through Email...

Apr 6, 2007

Ok i'm new to asp but familiar with other server side scripting languages. I'm writing a simple query to insert data into a table, then i want to be able to email someone saying data has been inserted. The problem I am having is i want to be able to add a link to go straight to the page that shows the information of the inserted data. so i figure a .asp?id=????  I have researched select_identity() for this method, but am unable to figure out exactly how I am supposed to code this. Any help or alternative methods would be appreciated. Thanks.

View 8 Replies View Related

Email Error

May 5, 2007

the site i am working on is www.papertrailinvites.com
on the left when you enter your email address and hit submit i get this error:

Server Error in '/' Application.


Must declare the scalar variable "@Email".
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Must declare the scalar variable "@Email".Source Error:



Line 29:
Line 30: conn.Open();
Line 31: cmd.ExecuteNonQuery();
Line 32:
Line 33: }
My code is below: protected void Button1_Click(object sender, EventArgs e)
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["cardsConnectionString1"].ConnectionString)) {

string email = Newsletter_Email.Text;

SqlCommand cmd = new SqlCommand("INSERT INTO Email (EmailAddress) Values (@Email)", conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Name", email);

conn.Open();
cmd.ExecuteNonQuery();

}
}
 

View 3 Replies View Related

Distinct Name And Email.

Aug 22, 2007

hey guys
.
you see how fenix.sn has a couple of entries BUT the same email and DIFFErENT BET IDS.
okay this is what i wanna do.
i wanna send an email to fenix.sn (just ONE email) saying you have won the following bets: xxx, xxx, xxx, xxx
then i wanna delete the entreis from the table.
 

View 5 Replies View Related

INNER Join On Email

Nov 22, 2007

I have two tables both have email address in them
I want to have a datagrid that shows which email addresses are in Table A (NZ) but not in B (Members)
Here is the Code but it doesn't work
SelectCommand="SELECT Members.Company,Members.UserEmail, NZ.F1UserEmail, NZ.StaffID FROM Members INNER JOIN NZ ON NZ.F1UserEmail <> Members.UserEmail WHERE (([Company] = @Company) OR ([Company] = @Company2)) ">
Any ideas would be appreciated

View 4 Replies View Related

Auto Email

Sep 9, 2004

Hi All,
I want to write a console application to send email. There is a Date field in the SQL Server and I need to send email 2 weeks before that date.I have no idea how to write a console application and make it work.Does anybody have code for this? If so please post it.
Thanks a lot,
Kumar.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved