Sql Edition Selection: outlook

Showing posts with label outlook. Show all posts

Tuesday, March 27, 2012

emails reside in Inbox?

Hi,
I'm working on MS SqL 2K
and I have installed MS Outlook.
I've configured the SQL Mail and SQL Agent Mail.
when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
and are not sent to the right recipients, so I should re-send them from
Outlook.
I'm missing something for sure, what is it?
thanks in advance.
joujHi
Your emails should be sent, but at a guess your are using Outlook 2002 or
later in which case it has to be running on the server see
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
The easiest solution is to install Outlook 2000 or use xpsmtp
http://www.sqldev.net/xp/xpsmtp.htm
John
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:89B5CE19-71C3-41B4-B846-9CF844AAF58A@.microsoft.com...
> Hi,
> I'm working on MS SqL 2K
> and I have installed MS Outlook.
> I've configured the SQL Mail and SQL Agent Mail.
> when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
> and are not sent to the right recipients, so I should re-send them from
> Outlook.
> I'm missing something for sure, what is it?
> thanks in advance.
> jouj
>

emails reside in Inbox?

Hi,
I'm working on MS SqL 2K
and I have installed MS Outlook.
I've configured the SQL Mail and SQL Agent Mail.
when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
and are not sent to the right recipients, so I should re-send them from
Outlook.
I'm missing something for sure, what is it?
thanks in advance.
jouj
Hi
Your emails should be sent, but at a guess your are using Outlook 2002 or
later in which case it has to be running on the server see
http://support.microsoft.com/default...b;en-us;263556
The easiest solution is to install Outlook 2000 or use xpsmtp
http://www.sqldev.net/xp/xpsmtp.htm
John
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:89B5CE19-71C3-41B4-B846-9CF844AAF58A@.microsoft.com...
> Hi,
> I'm working on MS SqL 2K
> and I have installed MS Outlook.
> I've configured the SQL Mail and SQL Agent Mail.
> when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
> and are not sent to the right recipients, so I should re-send them from
> Outlook.
> I'm missing something for sure, what is it?
> thanks in advance.
> jouj
>

Monday, March 26, 2012

emails reside in Inbox?

Hi,
I'm working on MS SqL 2K
and I have installed MS Outlook.
I've configured the SQL Mail and SQL Agent Mail.
when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
and are not sent to the right recipients, so I should re-send them from
Outlook.
I'm missing something for sure, what is it?
thanks in advance.
joujHi
Your emails should be sent, but at a guess your are using Outlook 2002 or
later in which case it has to be running on the server see
http://support.microsoft.com/defaul...kb;en-us;263556
The easiest solution is to install Outlook 2000 or use xpsmtp
http://www.sqldev.net/xp/xpsmtp.htm
John
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:89B5CE19-71C3-41B4-B846-9CF844AAF58A@.microsoft.com...
> Hi,
> I'm working on MS SqL 2K
> and I have installed MS Outlook.
> I've configured the SQL Mail and SQL Agent Mail.
> when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
> and are not sent to the right recipients, so I should re-send them from
> Outlook.
> I'm missing something for sure, what is it?
> thanks in advance.
> jouj
>

E-mails are stuck in the outlook

E-mails are stuck in the Outlook

Hi everybody,
When i send E-mails through SQL Mail, they end up in the inbox of MS Outlook
account. Only when i press 'send' mails are sent. I have Microsoft Outlook
2002. I have configured my Hotmail account in it as i don't have MS Exchange.
I have SQL Server 2000 with Service Pack 3. And my machine is windows 2000
with service pack 4. What could be the reason and what are the remedies?
thanks in advance
nomi
You need to leave outlook open. Check Q5 in the following
article:
INF: Common SQL Mail Problems
http://support.microsoft.com/?id=315886
-Sue
On Thu, 27 Jan 2005 23:15:01 -0800, "nomi"
<nomi@.discussions.microsoft.com> wrote:

>Hi everybody,
>When i send E-mails through SQL Mail, they end up in the inbox of MS Outlook
>account. Only when i press 'send' mails are sent. I have Microsoft Outlook
>2002. I have configured my Hotmail account in it as i don't have MS Exchange.
>I have SQL Server 2000 with Service Pack 3. And my machine is windows 2000
>with service pack 4. What could be the reason and what are the remedies?
>
>thanks in advance
>nomi
>
>
|||Sue,
I have kept Outlook Open, but i still have to press 'send' to send the
e-mails otherwise they are stuck in my inbox.
nomi
"Sue Hoegemeier" wrote:

> You need to leave outlook open. Check Q5 in the following
> article:
> INF: Common SQL Mail Problems
> http://support.microsoft.com/?id=315886
> -Sue
> On Thu, 27 Jan 2005 23:15:01 -0800, "nomi"
> <nomi@.discussions.microsoft.com> wrote:
>
>
|||You can't log off the server either. Log in under the
service account that SQL Server runs under, open outlook and
do not close outlook and do not log out.
If you still have problems, you should switch to Outlook
2000 as there are many issues with using Outlook 2002 or
higher with a non-Exchange mail server. If you loose
connectivity to your Pop3 mail server, even briefly, you can
also have problems.
The solution with the least amount of headaches is to not
use SQL Mail but to use SMTP mail instead. You can find more
information and download an extended stored procedure for
smtp mail at:
http://www.sqldev.net/xp/xpsmtp.htm
-Sue
On Sun, 30 Jan 2005 21:25:04 -0800, "nomi"
<nomi@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Sue,
>I have kept Outlook Open, but i still have to press 'send' to send the
>e-mails otherwise they are stuck in my inbox.
>nomi
>"Sue Hoegemeier" wrote:

E-mails are stuck in the outlook

Emailing report details

Hi,
I have a simple report that displays a page of text. I want to add a
button to it and
when the button is clicked a new outlook email is created with the
report as body, ready for the user to enter an email address.
Yes I know reports have subscriptions, they want a more adhoc
solution.
And users don't want the extra clicks of saving the report to file and
attaching it themselves.
Can it be done, is there an example?
thanks in advance.On Aug 1, 11:07 pm, paulhux...@.hotmail.com wrote:
> Hi,
> I have a simple report that displays a page of text. I want to add a
> button to it and
> when the button is clicked a new outlook email is created with the
> report as body, ready for the user to enter an email address.
> Yes I know reports have subscriptions, they want a more adhoc
> solution.
> And users don't want the extra clicks of saving the report to file and
> attaching it themselves.
> Can it be done, is there an example?
> thanks in advance.
There are not really any options available for this type of
functionality (aside from what you mentioned). If exporting the report
to PDF and attaching it to an email is an option, I would suggest
going the custom/ASP.NET application route. There is an open source
library available that can assist you in doing this: iTextSharp
(http://sourceforge.net/projects/itextsharp/http://itextsharp.sourceforge.net/tutorial/
). Otherwise, you will need to design a custom application that
includes a report viewer control that incorporates an SSRS report.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Aug 3, 11:31 am, EMartinez <emartinez...@.gmail.com> wrote:
> On Aug 1, 11:07 pm, paulhux...@.hotmail.com wrote:
> > Hi,
> > I have a simple report that displays a page of text. I want to add a
> > button to it and
> > when the button is clicked a new outlook email is created with the
> > report as body, ready for the user to enter an email address.
> > Yes I know reports have subscriptions, they want a more adhoc
> > solution.
> > And users don't want the extra clicks of saving the report to file and
> > attaching it themselves.
> > Can it be done, is there an example?
> > thanks in advance.
> There are not really any options available for this type of
> functionality (aside from what you mentioned). If exporting the report
> to PDF and attaching it to an email is an option, I would suggest
> going the custom/ASP.NET application route. There is an open source
> library available that can assist you in doing this: iTextSharp
> (http://sourceforge.net/projects/itextsharp/http://itextsharp.sourceforge.net/tutorial/
> ). Otherwise, you will need to design a custom application that
> includes a report viewer control that incorporates an SSRS report.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
****************************
thanks Enrique|||On Aug 2, 9:05 pm, paulhux...@.hotmail.com wrote:
> On Aug 3, 11:31 am, EMartinez <emartinez...@.gmail.com> wrote:
>
> > On Aug 1, 11:07 pm, paulhux...@.hotmail.com wrote:
> > > Hi,
> > > I have a simple report that displays a page of text. I want to add a
> > > button to it and
> > > when the button is clicked a new outlook email is created with the
> > > report as body, ready for the user to enter an email address.
> > > Yes I know reports have subscriptions, they want a more adhoc
> > > solution.
> > > And users don't want the extra clicks of saving the report to file and
> > > attaching it themselves.
> > > Can it be done, is there an example?
> > > thanks in advance.
> > There are not really any options available for this type of
> > functionality (aside from what you mentioned). If exporting the report
> > to PDF and attaching it to an email is an option, I would suggest
> > going the custom/ASP.NET application route. There is an open source
> > library available that can assist you in doing this: iTextSharp
> > (http://sourceforge.net/projects/itextsharp/http://itextsharp.sourcefo...
> > ). Otherwise, you will need to design a custom application that
> > includes a report viewer control that incorporates an SSRS report.
> > Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
> ****************************
> thanks Enrique
You're welcome. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Emailing from the SQL 2000 server

I have a few maintenance routines created and SQL 2000 has options to email
the reports. Do I need to have Outlook installed on the SQL server to do
these emails.
Also, since outlook uses user profiles I assume that I must log onto the SQL
server as the account used to run SQL server to configure Outlook. If that
is the case, how can I have other administrators configure notifications
without everyone using the same account to configure the SQL server? I
loose accountability when everyone uses the same account.Hello jordan
Yes, thats true, you must install Outlook in the SQL Servers Windows
profile.
But
I use SQLDev.NET:s xp_smtp_sendmail. Its working very good.
http://www.sqldev.net
Then you can create a SQL Alert to use for DBMaint.
http://www.dbmaint.com/SmtpAlerter.asp
Have just tried the Alert, but i dont have it in production
Best Regards
/Jens
Jordan wrote:
> I have a few maintenance routines created and SQL 2000 has options to emai
l
> the reports. Do I need to have Outlook installed on the SQL server to do
> these emails.
> Also, since outlook uses user profiles I assume that I must log onto the S
QL
> server as the account used to run SQL server to configure Outlook. If tha
t
> is the case, how can I have other administrators configure notifications
> without everyone using the same account to configure the SQL server? I
> loose accountability when everyone uses the same account.|||Jordan wrote:
> I have a few maintenance routines created and SQL 2000 has options to emai
l
> the reports. Do I need to have Outlook installed on the SQL server to do
> these emails.
> Also, since outlook uses user profiles I assume that I must log onto the S
QL
> server as the account used to run SQL server to configure Outlook. If tha
t
> is the case, how can I have other administrators configure notifications
> without everyone using the same account to configure the SQL server? I
> loose accountability when everyone uses the same account.
>
Outlook must be installed and a profile configured ONLY under the login
that the SQL services run under, not under each administrator's login.
You'll then configure the SQL Mail component to use that profile. Your
admins will continue to configure notifications as they do now.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Take a look into this URL on configuring Email.
http://classicasp.aspfaq.com/email/...sql-server.html
Thanks
Hari
SQL Server MVP
"Jordan" <none@.here.com> wrote in message
news:eD1DB6rwGHA.888@.TK2MSFTNGP02.phx.gbl...
>I have a few maintenance routines created and SQL 2000 has options to email
>the reports. Do I need to have Outlook installed on the SQL server to do
>these emails.
> Also, since outlook uses user profiles I assume that I must log onto the
> SQL server as the account used to run SQL server to configure Outlook. If
> that is the case, how can I have other administrators configure
> notifications without everyone using the same account to configure the SQL
> server? I loose accountability when everyone uses the same account.
>

Emailing from the SQL 2000 server

I have a few maintenance routines created and SQL 2000 has options to email
the reports. Do I need to have Outlook installed on the SQL server to do
these emails.
Also, since outlook uses user profiles I assume that I must log onto the SQL
server as the account used to run SQL server to configure Outlook. If that
is the case, how can I have other administrators configure notifications
without everyone using the same account to configure the SQL server? I
loose accountability when everyone uses the same account.Hello jordan
Yes, thats true, you must install Outlook in the SQL Servers Windows
profile.
But
I use SQLDev.NET:s xp_smtp_sendmail. Its working very good.
http://www.sqldev.net
Then you can create a SQL Alert to use for DBMaint.
http://www.dbmaint.com/SmtpAlerter.asp
Have just tried the Alert, but i dont have it in production
Best Regards
/Jens
Jordan wrote:
> I have a few maintenance routines created and SQL 2000 has options to email
> the reports. Do I need to have Outlook installed on the SQL server to do
> these emails.
> Also, since outlook uses user profiles I assume that I must log onto the SQL
> server as the account used to run SQL server to configure Outlook. If that
> is the case, how can I have other administrators configure notifications
> without everyone using the same account to configure the SQL server? I
> loose accountability when everyone uses the same account.|||Jordan wrote:
> I have a few maintenance routines created and SQL 2000 has options to email
> the reports. Do I need to have Outlook installed on the SQL server to do
> these emails.
> Also, since outlook uses user profiles I assume that I must log onto the SQL
> server as the account used to run SQL server to configure Outlook. If that
> is the case, how can I have other administrators configure notifications
> without everyone using the same account to configure the SQL server? I
> loose accountability when everyone uses the same account.
>
Outlook must be installed and a profile configured ONLY under the login
that the SQL services run under, not under each administrator's login.
You'll then configure the SQL Mail component to use that profile. Your
admins will continue to configure notifications as they do now.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Take a look into this URL on configuring Email.
http://classicasp.aspfaq.com/email/how-do-i-send-e-mail-from-sql-server.html
Thanks
Hari
SQL Server MVP
"Jordan" <none@.here.com> wrote in message
news:eD1DB6rwGHA.888@.TK2MSFTNGP02.phx.gbl...
>I have a few maintenance routines created and SQL 2000 has options to email
>the reports. Do I need to have Outlook installed on the SQL server to do
>these emails.
> Also, since outlook uses user profiles I assume that I must log onto the
> SQL server as the account used to run SQL server to configure Outlook. If
> that is the case, how can I have other administrators configure
> notifications without everyone using the same account to configure the SQL
> server? I loose accountability when everyone uses the same account.
>

Wednesday, March 21, 2012

Email Report in Outlook 2007 not the same as Outlook 2003

I have a Reporting Services 2005 report that is emailed to users. I created/formatted the report based on how it looked in Outlook 2003 which all of our users had at that time. The report is wide, but just fit in the email window when it was full size. Now I have a user who has been converted to Outlook 2007 and he emailed me a copy of the report he received in Outlook 2007 and it looks like it reduced the column sizes; it does not fill the entire email window and wraps the wording on most lines because the column sizes have been reduced.

The report is:

Delivered by: Report Server E-mail

Include Report is checked

Render Format is Web archive

Any ideas on how I can fix this?

Thanks in advance.

I still haven't found a fix for this, however, the user has found that opening the email message in a browser window displays it as expected. I wouldn't consider this a fix, unless all Outlook 2007 users are supposed to open all email messages in a browser window. If not, then it still would be nice to send an email report that is formatted correctly when the message is opened as a regular email message as it used to do in earlier Outlook versions.

|||

I am having the same issue.

Has anyone found a solution to this?

I have an embedded image in my header that is not showing either.

Any help would be greatly appreciated.

Thanks, Adrian

|||I am still waiting for a solution. My report does not have an embedded image so I can't help you there. If I ever find a fix, I will post it here.|||We are having the same issue. Just getting my name on this so when anyone updates it i'll get emailed. :-)|||Ditto for me!|||Also having this issue, and have been trying to hack around it for a while. This really should be fixed as a lot of reports in outlook 2007 become almost unreadable when the columns get squished to be so narrow.|||Yet another with the same problem.|||

What are the target platforms?

Xp with Outlook 2003 & IE6 is okay?

How about Xp with Outlook 2003 & IE7?

I don't think there is an easy fix for this problem as I reacall reading somewhere that Outlook 2007 uses Word2007, and not IE to render html emails.

|||

If you mean which platform correctly displays the reports, then that would be all users who are on XP or newer, with Outlook 2003 and at least IE6. So are you saying that SSRS 2005 reports cannot be displayed inside the email message without opening a browser OR that these reports need to be completely reformatted to display correctly in Outlook 2007? I guess I'm asking if readable reports can even be included in the text of an Outlook 2007 email message? As more users upgrade, this is becoming more of a problem.

|||

Outlook 2003 used IE to render html. Outlook 2007 chose to use Word to render html which does not honor the column widths we specify. Search the web for "outlook 2007 html" and you'll find this problem is definately not specific to Reporting Services.

The good news is there is a fix (http://support.microsoft.com/kb/935399) which is part of the latest SQL Server 2005 SP2 Cumulative Updates available from http://support.microsoft.com/kb/936305.

Thanks.

Monday, March 19, 2012

Email Notification Problem

Hi All,
I have a couple of w2k adv. svrs which are also running sql 2000. My DBA has
configured sp_send_mail using outlook 2000 which is also installed on these
servers.
This sp_send_mail is configured to send notifications on daily basis. Out of
25 notifications each day, 2 or 3 fails.
They claim the sp_send_mail stored procedure executes properly so the
problem is with the exchange svr even though there is no trace of these
failed messages in exchange nor even on the client computers where outlooks
mapi32 is initiated.
Is there any way I can figure out in outlook, on the client computers if
these failed messages are even initiated by outlook or not, even though they
claim their stored procedure executes properly always?
Nobody in the company has mail delivery problem with the exchange box or
their outlook clients. I have tested sending emails from outlook on these
servers without any failures yet they claim its exchange 2000.
Any ideas on how to resolve this permanently'The mail support that ships with SQL Server is not fun to work with as it uses MAPI and MAPI was
never designed to be used from services. Have you considered using xp_smtp_sendmail from
www.sqldev.net?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"caddo65590" <caddo65590@.hotmail.com> wrote in message news:O0QAtnEtDHA.980@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> I have a couple of w2k adv. svrs which are also running sql 2000. My DBA has
> configured sp_send_mail using outlook 2000 which is also installed on these
> servers.
> This sp_send_mail is configured to send notifications on daily basis. Out of
> 25 notifications each day, 2 or 3 fails.
> They claim the sp_send_mail stored procedure executes properly so the
> problem is with the exchange svr even though there is no trace of these
> failed messages in exchange nor even on the client computers where outlooks
> mapi32 is initiated.
> Is there any way I can figure out in outlook, on the client computers if
> these failed messages are even initiated by outlook or not, even though they
> claim their stored procedure executes properly always?
> Nobody in the company has mail delivery problem with the exchange box or
> their outlook clients. I have tested sending emails from outlook on these
> servers without any failures yet they claim its exchange 2000.
> Any ideas on how to resolve this permanently'
>

e-mail in SSRS reports with attachment

Hi All,

In my SSRS report there is a column with email field, when the user clicks on it -- it should open the outlook and in the attachment field there should be a screenshot of that report

i think anything i could do is only in the jump to url in the navigation tab......Please suggest me the solution or any other alternatives.

Thanks in advance for help

Warm Regards,

Chanduu.

I am using an alternate approach, but that is also not working

The approach I was using is writing a code in c# to export that report in PDF programmatically using c#, without opening SSRS so that I could attach it outlook/write a mail program, for this I got some help from this site http://www.programurl.com/pdf-reporting-services.htm, but this file is saving a PDG file without any data.

If you have any solution, please send me so that I could move further

Warm Regards,

Chanduu

e-mail in SSRS reports with attachment

Hi All,

In my SSRS report there is a column with email field, when the user clicks on it -- it should open the outlook and in the attachment field there should be a screenshot of that report

i think anything i could do is only in the jump to url in the navigation tab......Please suggest me the solution or any other alternatives.

Thanks in advance for help

Warm Regards,

Chanduu.

I am using an alternate approach, but that is also not working

If you have any solution, please send me so that I could move further

Warm Regards,

Chanduu

Sunday, March 11, 2012

Email Column

Can we provide an outlook based email column so that as the email is
clicked. directly outlook opens with to mail column. so tha we can directly
send the email as they click corresponding column.
Navin.DHi,
Why dont u have a link of "mailto:chathurangaw@.zone24x7.com " for that
column
on the column u need the link... right click and select properties,->
Advanced
then give an expression for the jump to URL of the navigation tab...
it's real simple...
Chathuranga
NAVIN.D wrote:
> Can we provide an outlook based email column so that as the email is
> clicked. directly outlook opens with to mail column. so tha we can directly
> send the email as they click corresponding column.
> Navin.D|||There are some 10,000 records filled in directly from dbase for that email
column, can you please provide the expression.
"chathurangakw@.gmail.com" wrote:
> Hi,
> Why dont u have a link of "mailto:chathurangaw@.zone24x7.com " for that
> column
> on the column u need the link... right click and select properties,->
> Advanced
> then give an expression for the jump to URL of the navigation tab...
> it's real simple...
> Chathuranga
>
> NAVIN.D wrote:
> > Can we provide an outlook based email column so that as the email is
> > clicked. directly outlook opens with to mail column. so tha we can directly
> > send the email as they click corresponding column.
> >
> > Navin.D
>|||Assuming the db field is email... The Action URL might be
="mailto:" & Fields!email.Value
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"NAVIN.D" wrote:
> There are some 10,000 records filled in directly from dbase for that email
> column, can you please provide the expression.
> "chathurangakw@.gmail.com" wrote:
> > Hi,
> >
> > Why dont u have a link of "mailto:chathurangaw@.zone24x7.com " for that
> > column
> > on the column u need the link... right click and select properties,->
> > Advanced
> > then give an expression for the jump to URL of the navigation tab...
> >
> > it's real simple...
> >
> > Chathuranga
> >
> >
> > NAVIN.D wrote:
> > > Can we provide an outlook based email column so that as the email is
> > > clicked. directly outlook opens with to mail column. so tha we can directly
> > > send the email as they click corresponding column.
> > >
> > > Navin.D
> >
> >|||the properties for the currently selected item are not valid,please correct
all errors before contuning. Is the error i am getting when i use it
"Wayne Snyder" wrote:
> Assuming the db field is email... The Action URL might be
> ="mailto:" & Fields!email.Value
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "NAVIN.D" wrote:
> > There are some 10,000 records filled in directly from dbase for that email
> > column, can you please provide the expression.
> >
> > "chathurangakw@.gmail.com" wrote:
> >
> > > Hi,
> > >
> > > Why dont u have a link of "mailto:chathurangaw@.zone24x7.com " for that
> > > column
> > > on the column u need the link... right click and select properties,->
> > > Advanced
> > > then give an expression for the jump to URL of the navigation tab...
> > >
> > > it's real simple...
> > >
> > > Chathuranga
> > >
> > >
> > > NAVIN.D wrote:
> > > > Can we provide an outlook based email column so that as the email is
> > > > clicked. directly outlook opens with to mail column. so tha we can directly
> > > > send the email as they click corresponding column.
> > > >
> > > > Navin.D
> > >
> > >|||the properties for the currently selected item are not valid,please correct
all errors before contuning. Is the error i am getting when i use it
Wayne Snyder" wrote:
> Assuming the db field is email... The Action URL might be
> ="mailto:" & Fields!email.Value
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "NAVIN.D" wrote:
> > There are some 10,000 records filled in directly from dbase for that email
> > column, can you please provide the expression.
> >
> > "chathurangakw@.gmail.com" wrote:
> >
> > > Hi,
> > >
> > > Why dont u have a link of "mailto:chathurangaw@.zone24x7.com " for that
> > > column
> > > on the column u need the link... right click and select properties,->
> > > Advanced
> > > then give an expression for the jump to URL of the navigation tab...
> > >
> > > it's real simple...
> > >
> > > Chathuranga
> > >
> > >
> > > NAVIN.D wrote:
> > > > Can we provide an outlook based email column so that as the email is
> > > > clicked. directly outlook opens with to mail column. so tha we can directly
> > > > send the email as they click corresponding column.
> > > >
> > > > Navin.D
> > >
> > >|||Wayne Snyder 's reply should be enough to get it working.... u might
be in a wrong place... I'm talking about the Navigation Tab of a
Properties Dialog-> advanced... for a TextBox|||or a TextBox inside a Table|||tried the same way but get the error as i mentioned
thank you
Navin.D
"chathurangakw@.gmail.com" wrote:
> or a TextBox inside a Table
>

Email Clients

Anyone using an email client other than MS Outlook so that Sql Server can
send mail?| Anyone using an email client other than MS Outlook so that Sql Server can
| send mail?
--
According to:
INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
NOTE: Due to the limitation of only providing extended MAPI support, SQL
Server 2000 requires a Microsoft Outlook 2000 client (or later version).
--
Eric Cárdenas
SQL Server support|||I prefer going SMTP without installing a mail client. Check out xp_smtp_sendmail from
www.sqldev.net.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"marle" <marleInfo@.mescobar.com> wrote in message news:ONffNA0wDHA.1060@.TK2MSFTNGP12.phx.gbl...
> Anyone using an email client other than MS Outlook so that Sql Server can
> send mail?
>

Email Attachment Corruption

I have a subscription to a report that delivers an Excel attachment. When delivered to my outlook mailbox, no problems. Same report attachment delivered to my hotmail account is corrupted. Results are the same with the CSV option.
Is this related to the problem with lotus mail servers?What is the corruption? The lotus issue is that the emails have a 0 byte
attachment.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stuart Finley" <StuartFinley@.discussions.microsoft.com> wrote in message
news:71507D7C-7594-4467-B42A-715E4359B306@.microsoft.com...
>I have a subscription to a report that delivers an Excel attachment. When
>delivered to my outlook mailbox, no problems. Same report attachment
>delivered to my hotmail account is corrupted. Results are the same with the
>CSV option.
> Is this related to the problem with lotus mail servers?|||The attachments are garbled -- their size doesn't appear to change.
So far this behavior occurs only when I send the report to a Hotmail account. A lycos internet account is working.
"Lukasz Pawlowski [MSFT]" wrote:
> What is the corruption? The lotus issue is that the emails have a 0 byte
> attachment.
> -Lukasz
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Stuart Finley" <StuartFinley@.discussions.microsoft.com> wrote in message
> news:71507D7C-7594-4467-B42A-715E4359B306@.microsoft.com...
> >I have a subscription to a report that delivers an Excel attachment. When
> >delivered to my outlook mailbox, no problems. Same report attachment
> >delivered to my hotmail account is corrupted. Results are the same with the
> >CSV option.
> >
> > Is this related to the problem with lotus mail servers?
>
>|||This is probably related to the same issue. KB Article 872774 will discuss
this issue, although the KB doesn't seem to be available yet. You will need
to contact PSS to get the fix for this issue.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stuart Finley" <StuartFinley@.discussions.microsoft.com> wrote in message
news:B3B6E32C-6878-44D2-8AE9-9C451C727E75@.microsoft.com...
> The attachments are garbled -- their size doesn't appear to change.
> So far this behavior occurs only when I send the report to a Hotmail
account. A lycos internet account is working.
> "Lukasz Pawlowski [MSFT]" wrote:
> > What is the corruption? The lotus issue is that the emails have a 0
byte
> > attachment.
> >
> > -Lukasz
> >
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Stuart Finley" <StuartFinley@.discussions.microsoft.com> wrote in
message
> > news:71507D7C-7594-4467-B42A-715E4359B306@.microsoft.com...
> > >I have a subscription to a report that delivers an Excel attachment.
When
> > >delivered to my outlook mailbox, no problems. Same report attachment
> > >delivered to my hotmail account is corrupted. Results are the same with
the
> > >CSV option.
> > >
> > > Is this related to the problem with lotus mail servers?
> >
> >
> >

Tuesday, March 27, 2012

emails reside in Inbox?

emails reside in Inbox?

Monday, March 26, 2012

emails reside in Inbox?

E-mails are stuck in the outlook

E-mails are stuck in the outlook

E-mails are stuck in the Outlook

E-mails are stuck in the outlook

Emailing report details

Emailing from the SQL 2000 server

Emailing from the SQL 2000 server

Wednesday, March 21, 2012

Email Report in Outlook 2007 not the same as Outlook 2003

Monday, March 19, 2012

Email Notification Problem

e-mail in SSRS reports with attachment

e-mail in SSRS reports with attachment

Sunday, March 11, 2012

Email Column

Email Clients

Email Attachment Corruption

Sql Edition Selection

Blog Archive

About Me