Is it possible to snd SMS's in a group from an access appl..

Dear Aaron,

I don't understand, can u please explain!What is xp_sendmail exactly?

Thanks

"a a r o n . k e m p f @ g m a i l . c o" wrote:

> yes xp_sendmail - it works reliably.
>
> ClientSide email spamming is a security hole; any way you look at it.
>
>
>
>
> On Jul 4, 5:03 am, J.Alladien <JAllad....TakeThisOut@discussions.microsoft.com>
> wrote:
> > Dear all,
> >
> > Maybe a strange question, but with sms-ing so popular now adays, is it
> > possible to snd SMS's in a group from an access application just as you can
> > send e-mails to a group of people who are in your database?
> >
> > Thanks in advance!
>
>

it is a stored procedure.

Anyone doing anything with MS Access should be using SQL Server. Most
of the people around here don't believe that-- it's because most of
the real SQL people move on.. you know?

But SQL Server is like heaven-- things just work.. they work fast,
reliably-- and you get real tools.

And you still get to use all the same forms and reports-- but even
better, because you've got stored procedures.
Sprocs-- as I like to call them.


Sprocs _SLAUGHTER_ queries regarding code reuse.

It's like a vb procedure.. but it's on the database side.

-------------------------------------
CREATE PROCEDURE spGetEmployee
(
@EmployeeID INT
)
As

Select * From Employees Where EmployeeID = @EmployeeID.

DECLARE @EMAIL VARCHAR(50)
SET @EMAIL = (Select Email From Employees Where EmployeeID =
@EmployeeID)

XP_SENDMAIL @EMAIL, 'someone is snooping on your employee record'
-------------------------------------

in other words-- you can have a simple query-- whenever someone runs
it; it will email that person and notify them.
XP_SENDMAIL is a great tool, there are newer tools using SQL 2005--
but I just think that it is a much more reliable tool than using
Docmd.SendObject and asking people to hit "YES" when they get prompted
for email.

I wish you luck-- let me know what else I can do to point you in the
correct direction.

I would just start with an Access 2000-2003 version.. and run the
upsizing wizard. Choose 'Create SQL Server Application' is how it is
called I think.. or just choose the 'Access Data Project (ADP)'
format.

It's called the 21st century. Sending email --- through the db
server-- is a fact of life.










On Jul 4, 10:52 am, J.Alladien <JAllad... RemoveThis @discussions.microsoft.com>
wrote:
> Dear Aaron,
>
> I don't understand, can u please explain!What is xp_sendmail exactly?
>
> Thanks
>
> "a a r o n . k e m p f @ g m a i l . c o" wrote:
>
>
>
> > yes xp_sendmail - it works reliably.
>
> > ClientSide email spamming is a security hole; any way you look at it.
>
> > On Jul 4, 5:03 am, J.Alladien <JAllad... RemoveThis @discussions.microsoft.com>
> > wrote:
> > > Dear all,
>
> > > Maybe a strange question, but with sms-ing so popular now adays, is it
> > > possible to snd SMS's in a group from an access application just as you can
> > > send e-mails to a group of people who are in your database?
>
> > > Thanks in advance!- Hide quoted text -
>
> - Show quoted text -

hi J.,

J.Alladien wrote:
> Maybe a strange question, but with sms-ing so popular now adays, is it
> possible to snd SMS's in a group from an access application just as you can
> send e-mails to a group of people who are in your database?
Yes, you just need to use a SMS to e-mail gateway or interface with a
SMS Service directly.

Some web hosters provide such functionality. Also some telephone systems
provide such interfaces.

Or you can communicate with a cell phone directly to post SMS.

So lots of possibilites, you just have to evaluate it. Ask your friend.


mfG
--> stefan <--

Dear Stefan,

Who is "my friend"?

"Stefan Hoffmann" wrote:

> hi J.,
>
> J.Alladien wrote:
> > Maybe a strange question, but with sms-ing so popular now adays, is it
> > possible to snd SMS's in a group from an access application just as you can
> > send e-mails to a group of people who are in your database?
> Yes, you just need to use a SMS to e-mail gateway or interface with a
> SMS Service directly.
>
> Some web hosters provide such functionality. Also some telephone systems
> provide such interfaces.
>
> Or you can communicate with a cell phone directly to post SMS.
>
> So lots of possibilites, you just have to evaluate it. Ask your friend.
>
>
> mfG
> --> stefan <--
>

hi J.,

J.Alladien wrote:
> Who is "my friend"?
Google is your friend


mfG
--> stefan <--

J.Alladien <JAlladien.RemoveThis@discussions.microsoft.com> wrote:

>Maybe a strange question, but with sms-ing so popular now adays, is it
>possible to snd SMS's in a group from an access application just as you can
>send e-mails to a group of people who are in your database?

There are services available for a fee to which you can send the SMS
data and which will in turn send the SMSs out for you.

Alternatively you can determine the cell phone vendor and send emails
to the cell phone number via the providers URL. Such as
1234567890.RemoveThis@msg.cellphoneprovider.com. However this is only practical
if you are dealing with relatively small number of recipients.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/