# Possible? MySql, Asp and MS Access

**URL:** <https://forum.kirupa.com/t/possible-mysql-asp-and-ms-access/33815>\
**Category:** programming\
**Created:** [October 23, 2003, 8:58pm UTC](https://forum.kirupa.com/t/possible-mysql-asp-and-ms-access/33815 "2003-10-23T20:58:50Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![boristheblade](https://avatars.discourse-cdn.com/v4/letter/b/848f3c/32.png) [@boristheblade](https://forum.kirupa.com/u/boristheblade)\
**Post date:** [October 23, 2003, 8:58pm UTC](https://forum.kirupa.com/t/possible-mysql-asp-and-ms-access/33815/1 "2003-10-23T20:58:50Z")

</div>

Yo,  
I’m not sure if this is possible, but here is what I would like to do. I have a MySql database linked with MS Access db for the purpose of using forms to input data. I would like to send an email any time I update or add an entry to the database.

This does not seem that difficult, but I can not figure out how to do it. The webservices I have available are ASP(not [asp.net](http://asp.net)), MS Access and MySql. Thanks for any help, although I expect this problem to remain unsolved.

🙂

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [October 23, 2003, 11:31pm UTC](https://forum.kirupa.com/t/possible-mysql-asp-and-ms-access/33815/2 "2003-10-23T23:31:49Z")

</div>

well it’s really a simple task, on the page where your inseting your data, send an email along using CDONTS.

here’s the code to send an email in ASP:

```php

<% @language="VBSCRIPT" %> 
<%

Dim myMail, myBody

myBody = "Name: "& request.form("name") & vbcrlf
myBody = myBody & "Email: "& request.form("email") & vbcrlf
myBody = myBody & "Message: "& vbcrlf & request.form("message")

Set myMail = CreateObject("CDONTS.NewMail")

myMail.BodyFormat=1
myMail.MailFormat=1
myMail.From=request.form("email")
myMail.To=request.form("email")
myMail.Subject=request.form("subject")
myMail.Body=myBody
myMail.Send

set myMail=nothing

%>

```

btw it has nothing to do with databases unless you want to store the email addresses in there.