Possible to setup SQL Mail w/o installing Outlook?

I just installed Windows 2003 Server and SQL Server 2000. I would like to
use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
profile in Outlook.
Is it possible to setup SQL Server Mail services without installing Outlook?
I remember in NT there was a mail icon in the Control Panel, this isn't
there anymore in 2003.
Thanks
ckanekoYou don't have to have Exchange, but it is my understanding to set up SQL
Mail you need have the Outlook client installed so you can create a mail
profile. Here is an article that might help:
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>|||Yes, you still need to install a MAPI client (eg Outlook 2003). If you don't wish to use a MAPI client and you only need to send mail take a look at xpsmtp. http://sqldev.net/xp/xpsmtp.htm|||Ive found that Outlook XP and 2003 wont work because they prompt the user
"Another application is trying to send email on behalf of you...do you want
to allow?" Maybe someone knows a way around this? So...I use Outlook 2000.
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>|||It's possible to get around this with the help of your Exchange
administrator (there's a link in the KB below)
INF: Common SQL Mail Problems
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q315886
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"JL Morrison" <jl_morrison@.hotmail.com> wrote in message
news:e9cVW%23dSEHA.3552@.TK2MSFTNGP09.phx.gbl...
> Ive found that Outlook XP and 2003 wont work because they prompt the user
> "Another application is trying to send email on behalf of you...do you
want
> to allow?" Maybe someone knows a way around this? So...I use Outlook
2000.
> "ckaneko" <ckaneko@.ffi-hq.com> wrote in message
> news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> > I just installed Windows 2003 Server and SQL Server 2000. I would like
to
> > use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a
mail
> > profile in Outlook.
> >
> > Is it possible to setup SQL Server Mail services without installing
> Outlook?
> > I remember in NT there was a mail icon in the Control Panel, this isn't
> > there anymore in 2003.
> >
> > Thanks
> > ckaneko
> >
> >
>|||Some options:
http://www.karaszi.com/sqlserver/info_no_mapi.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>

Possible to setup SQL Mail w/o installing Outlook?

I just installed Windows 2003 Server and SQL Server 2000. I would like to
use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
profile in Outlook.
Is it possible to setup SQL Server Mail services without installing Outlook?
I remember in NT there was a mail icon in the Control Panel, this isn't
there anymore in 2003.
Thanks
ckaneko
You don't have to have Exchange, but it is my understanding to set up SQL
Mail you need have the Outlook client installed so you can create a mail
profile. Here is an article that might help:
http://support.microsoft.com/default...b;en-us;263556
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>
|||Yes, you still need to install a MAPI client (eg Outlook 2003). If you don't wish to use a MAPI client and you only need to send mail take a look at xpsmtp. http://sqldev.net/xp/xpsmtp.htm
|||Ive found that Outlook XP and 2003 wont work because they prompt the user
"Another application is trying to send email on behalf of you...do you want
to allow?" Maybe someone knows a way around this? So...I use Outlook 2000.
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>
|||It's possible to get around this with the help of your Exchange
administrator (there's a link in the KB below)
INF: Common SQL Mail Problems
http://support.microsoft.com/default...;en-us;Q315886
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"JL Morrison" <jl_morrison@.hotmail.com> wrote in message
news:e9cVW%23dSEHA.3552@.TK2MSFTNGP09.phx.gbl...
> Ive found that Outlook XP and 2003 wont work because they prompt the user
> "Another application is trying to send email on behalf of you...do you
want
> to allow?" Maybe someone knows a way around this? So...I use Outlook
2000.[vbcol=seagreen]
> "ckaneko" <ckaneko@.ffi-hq.com> wrote in message
> news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
to[vbcol=seagreen]
mail
> Outlook?
>
|||Some options:
http://www.karaszi.com/sqlserver/info_no_mapi.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>

Possible to setup SQL Mail w/o installing Outlook?

I just installed Windows 2003 Server and SQL Server 2000. I would like to
use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
profile in Outlook.
Is it possible to setup SQL Server Mail services without installing Outlook?
I remember in NT there was a mail icon in the Control Panel, this isn't
there anymore in 2003.
Thanks
ckanekoYou don't have to have Exchange, but it is my understanding to set up SQL
Mail you need have the Outlook client installed so you can create a mail
profile. Here is an article that might help:
http://support.microsoft.com/defaul...kb;en-us;263556
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>|||Yes, you still need to install a MAPI client (eg Outlook 2003). If you don't wish to u
se a MAPI client and you only need to send mail take a look at xpsmtp. dev.net/xp/xpsmtp.htm" target="_blank">http://sql
dev.net/xp/xpsmtp.htm|||Ive found that Outlook XP and 2003 wont work because they prompt the user
"Another application is trying to send email on behalf of you...do you want
to allow?" Maybe someone knows a way around this? So...I use Outlook 2000.
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>|||It's possible to get around this with the help of your Exchange
administrator (there's a link in the KB below)
INF: Common SQL Mail Problems
http://support.microsoft.com/defaul...b;en-us;Q315886
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"JL Morrison" <jl_morrison@.hotmail.com> wrote in message
news:e9cVW%23dSEHA.3552@.TK2MSFTNGP09.phx.gbl...
> Ive found that Outlook XP and 2003 wont work because they prompt the user
> "Another application is trying to send email on behalf of you...do you
want
> to allow?" Maybe someone knows a way around this? So...I use Outlook
2000.
> "ckaneko" <ckaneko@.ffi-hq.com> wrote in message
> news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
to[vbcol=seagreen]
mail[vbcol=seagreen]
> Outlook?
>|||Some options:
http://www.karaszi.com/sqlserver/info_no_mapi.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl..
.
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing Outloo
k?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>

Possible to perform mathematical functions on two or more text boxes?

I am looking to take the sum of the values displayed in a couple text
boxes and display the result in another text box. Is it at all
possible to include the values displayed in other text boxes in
expressions in other text boxes?On Jul 11, 8:19 am, mtnbiker419 <rdrace...@.gmail.com> wrote:
> I am looking to take the sum of the values displayed in a couple text
> boxes and display the result in another text box. Is it at all
> possible to include the values displayed in other text boxes in
> expressions in other text boxes?
If I'm understanding you correctly and you want field values displayed
in textboxes (i.e., table control cells/text boxes, etc), you can
reference them within the dataset itself (if they are aggregates or
can be aggregated):
=Fields!FieldName.Value + Sum(Fields!FieldNameInOtherDataset.Value,
"DatasetNameUsedInTextboxB")
-or similarly -
=Fields!FieldName.Value + Avg(Fields!FieldNameInOtherDataset.Value,
"DatasetNameUsedInTextboxB")
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant