Hi here's hoping, i am currently trying to set up a web site using Access XP and its pages, however I need to be able to notify people via lotus notes when a new record has been added. I know there is a createobject function but for some reason it doesn't seem to work (i have tried to create an excel file for a test and that didn't work either) I have searched on the internet and found information about using CDONTS, however this isn't very familiar to me and using it doesn't seem to work, I don't know if its set up correctly, any help would be massively appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
e mailing from access xp pages
- Thread starter daveonion
- Start date
I think what you're needing to do required asp code.
the way I know of doing this is not through access itself, but is actually a function of your webserver. The CreateObject method is a function of the Server object in asp. In my experience, it's the web server that would send an email to confirm a change in the database, not access iteself - unless this is a new feature that i'm unaware of (which could be) If this sound like what you need, post back, and I'll post a code sample.
Seek not outside yourself; heaven is within.
the way I know of doing this is not through access itself, but is actually a function of your webserver. The CreateObject method is a function of the Server object in asp. In my experience, it's the web server that would send an email to confirm a change in the database, not access iteself - unless this is a new feature that i'm unaware of (which could be) If this sound like what you need, post back, and I'll post a code sample.
Seek not outside yourself; heaven is within.
- Thread starter
- #3
scroce, i'm not too sure what it is i have to do, basically i am going to have a web site on a server using access pages, and i want it to email me with any changes. Trying not to be too greedy if you could email me the code you've got plus any other information, from the beginning, regarding how to set up the server to enable it to email
thanks again
thanks again
Well, my knowledge of access data pages is limited - but it seems to me that they are basically just a web page with a lot of javascript plugged into it. If you use an html/asp editor, you ought to be able to add some asp code that generates the e-mail - it would look something like this - This is a very simplified code example:
<%
dim objNewMail
dim msgFrom
dim msgTo
dim msgSubject
dim msgMessage
dim msgImportance
Set objNewMail = Server.CreateObject(CDONTS.NewMail"
msgFrom="daveonion@yourplace.com"
msgTo="whomever@theirplace.com"
msgSubject="New Update to the database"
msgMessage="A new update has just been made"
msgImportance=0
'call the send method
objNewMail.Send(msgFrom, msgTo, msgSubject, msgMessage, msgImportance)
%>
This mail would be sent when the page is read by the IIS server
As far as configuring the server - I've only set up a small test server on iis5, it only serves me and two other people - maybe someone else could weigh in on that one.
also check out the ASP forum here in tek-tips - I've found it extremely helpful. also you might try -
i'll try to post back with more helpful places as i think of them. Seek not outside yourself; heaven is within.
<%
dim objNewMail
dim msgFrom
dim msgTo
dim msgSubject
dim msgMessage
dim msgImportance
Set objNewMail = Server.CreateObject(CDONTS.NewMail"
msgFrom="daveonion@yourplace.com"
msgTo="whomever@theirplace.com"
msgSubject="New Update to the database"
msgMessage="A new update has just been made"
msgImportance=0
'call the send method
objNewMail.Send(msgFrom, msgTo, msgSubject, msgMessage, msgImportance)
%>
This mail would be sent when the page is read by the IIS server
As far as configuring the server - I've only set up a small test server on iis5, it only serves me and two other people - maybe someone else could weigh in on that one.
also check out the ASP forum here in tek-tips - I've found it extremely helpful. also you might try -
i'll try to post back with more helpful places as i think of them. Seek not outside yourself; heaven is within.
- Status
Similar threads
- Locked
- Question
- Locked
- Solved
- Locked
- Question
