MS Access, send email from web host

[Colin Kingston]

Hi

For a college project I intend to produce a web based access database
which will allow a group leader to send the same email to group
members registered for that group.

I want the group leader to be able to: Open a web page, choose a
group, write an email and send the email to the group.

The database will be hosted by a web hosting company which uses server
2003 and can host an Access database with ASP.net pages - possibly
oneandone.co.uk .
How do I go about making the email element of this database work?

I presume linking to Outlook or J mail etc will not work as I presume
these will not be on the server.

Any help appreciated.

Colin

[MacDermott]

As I understand it, Access itself has no intrinsic e-mail capabilities; it
merely knows how to talk to e-mail applications. However, IIS does support
SMTP; you can learn more about using it here:
http://www.windowsitlibrary.com/Content/141/09/1.html

Think of your Access database as simply a place you're storing data.
You'll be doing your development in ASP.NET.
Avoid thinking in terms of programming Access for this application.

HTH
- Turtle

"Colin Kingston" <ck****@yahoo.c o.uk> wrote in message
news:7e******** *************** ***@posting.goo gle.com...

Hi

For a college project I intend to produce a web based access database
which will allow a group leader to send the same email to group
members registered for that group.

I want the group leader to be able to: Open a web page, choose a
group, write an email and send the email to the group.

The database will be hosted by a web hosting company which uses server
2003 and can host an Access database with ASP.net pages - possibly
oneandone.co.uk .
How do I go about making the email element of this database work?

I presume linking to Outlook or J mail etc will not work as I presume
these will not be on the server.

Any help appreciated.

Colin

[Alan Webb]

Colin,
Your web hosting company will need to give your code administrator rights on
a mail server so it can manage accounts. And . . . I don't see how Access
helps or hurts in this case since sending mail to a list is something a
listserv does rather well. Sendmail (what a bunch of the Internet uses for
an e-mail server) as well as Exchange both allow mail clients to cc messages
to a list (thus, spam, dang it), so Access isn't needed. If I had my pick
of software to do this with I'd probably choose Apache, sendmail and
PostgreSQL on some sort of POSIX compliant OS like Linux or FreeBSD, not
Access. Also, EBay sells retired servers like my Dell PowerEdge 2300 for
around $250.00 US or so. Mum & Pop could pony up for the server or you
could eat Ramen for a semester to pay for it and host it yourself.

"Colin Kingston" <ck****@yahoo.c o.uk> wrote in message
news:7e******** *************** ***@posting.goo gle.com...

Hi

For a college project I intend to produce a web based access database
which will allow a group leader to send the same email to group
members registered for that group.

I want the group leader to be able to: Open a web page, choose a
group, write an email and send the email to the group.

The database will be hosted by a web hosting company which uses server
2003 and can host an Access database with ASP.net pages - possibly
oneandone.co.uk .
How do I go about making the email element of this database work?

I presume linking to Outlook or J mail etc will not work as I presume
these will not be on the server.

Any help appreciated.

Colin

[John Winterbottom]

"Colin Kingston" <ck****@yahoo.c o.uk> wrote in message
news:7e******** *************** ***@posting.goo gle.com...

Hi

For a college project I intend to produce a web based access database
which will allow a group leader to send the same email to group
members registered for that group.

I want the group leader to be able to: Open a web page, choose a
group, write an email and send the email to the group.

The database will be hosted by a web hosting company which uses server
2003 and can host an Access database with ASP.net pages - possibly
oneandone.co.uk .
How do I go about making the email element of this database work?

If you're writing this in ASP.NET then you can use the .NET mail classes -
as long as you have access to an open-relay smtp server. AFAIK the .NET mail
classes don't yet support authentication which is why you need open relay.

Alternatively, ask your hosting company if they support any email ActiveX
controls - many do. Then code for that one. I've used and can recommend
ASPEmail which has a free version that does support authentication and
allows you to send attachments. Of course you still need an smtp server
somewhere, but you can use any smtp server - doesn't have to be on the
machine that's doing the hosting.

I presume linking to Outlook or J mail etc will not work as I presume
these will not be on the server.

Correct.

FWIW the next version of SQL Server, (2005), will, I believe include
built-in smtp capability.

[B. Comrie]

there is some ASP.NET/SMTP based email code on this website

http://www.codewidgets.com

"Colin Kingston" <ck****@yahoo.c o.uk> wrote in message
news:7e******** *************** ***@posting.goo gle.com...

Hi

For a college project I intend to produce a web based access database
which will allow a group leader to send the same email to group
members registered for that group.

I want the group leader to be able to: Open a web page, choose a
group, write an email and send the email to the group.

The database will be hosted by a web hosting company which uses server
2003 and can host an Access database with ASP.net pages - possibly
oneandone.co.uk .
How do I go about making the email element of this database work?

I presume linking to Outlook or J mail etc will not work as I presume
these will not be on the server.

Any help appreciated.

Colin