# Automatically sending an email from Access

**URL:** https://boards.straightdope.com/t/automatically-sending-an-email-from-access/399629
**Category:** Factual Questions
**Created:** [April 11, 2007, 1:30pm UTC](https://boards.straightdope.com/t/automatically-sending-an-email-from-access/399629 "2007-04-11T13:30:30Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Dr.Lao](https://avatars.discourse-cdn.com/v4/letter/d/2bfe46/32.png) [@Dr.Lao](https://boards.straightdope.com/u/Dr.Lao)
#### Post date: [April 11, 2007, 1:30pm UTC](https://boards.straightdope.com/t/automatically-sending-an-email-from-access/399629/1 "2007-04-11T13:30:30Z")

</div>

We maintain an inventory of chemicals using a Microsoft database. The database contains information on the expiration dates of chemicals and we want to be able to set up something that will automatically send an email to the appropriate people when chemicals hit expiry. Is this something you could do easily in Access? I know this is probably a noob question for IT people, but we are just lab people trying to muddle through. Thanks.

---

<div class="post-metadata">

### Author: ![Sequent](https://avatars.discourse-cdn.com/v4/letter/s/dbc845/32.png) [@Sequent](https://boards.straightdope.com/u/Sequent)
#### Post date: [April 11, 2007, 2:53pm UTC](https://boards.straightdope.com/t/automatically-sending-an-email-from-access/399629/2 "2007-04-11T14:53:58Z")

</div>

Dr. Lao: you can build it; you have the technology. For example, I direct you to [this post](http://www.access-programmers.co.uk/forums/showthread.php?p=580193) on the MS Access forum, where you will probably get more specific information about your question (or follow-ups).

---

<div class="post-metadata">

### Author: ![Atrael](https://avatars.discourse-cdn.com/v4/letter/a/6a8cbe/32.png) [@Atrael](https://boards.straightdope.com/u/Atrael)
#### Post date: [April 11, 2007, 7:18pm UTC](https://boards.straightdope.com/t/automatically-sending-an-email-from-access/399629/3 "2007-04-11T19:18:01Z")

</div>

To add an additional bit, no it’s not easy. But yes it’s possible. It can depend on how your database is put together…what version of Access you’re running…and whom you have on staff that is semi-comfortable working with MS Access. Along with the website Sequent suggested, I recommend taking a look at [this site](http://www.mvps.org/access/) for some helpful tips and tricks. Good Luck!

---

<div class="post-metadata">

### Author: ![Dr.Lao](https://avatars.discourse-cdn.com/v4/letter/d/2bfe46/32.png) [@Dr.Lao](https://boards.straightdope.com/u/Dr.Lao)
#### Post date: [April 13, 2007, 12:41pm UTC](https://boards.straightdope.com/t/automatically-sending-an-email-from-access/399629/4 "2007-04-13T12:41:43Z")

</div>

Thanks, guys. I’ll check those out.
