Hello! I am new to VBA and I need to write a macro and I am not sure how do it. I need to have an e-mail generated when a certain value is reached in the cell of an Access database. Specifically, I need to have Access automatically create an e-mail when a certain date is reached in a cell in Access. For example, when say someone enters todays date in a cell in Access, how do I have access automatically create and send an e-mail to an outlook account 4 months after that date? and then again 6 months and 1 year? I have been doing research online and I found a page that describes the SendObject option, but it doesn't ell me how to write the actual code. Or maybe it does and I just don't understand that it does. So what would the code looks like and where can I get information about how to write the actual code for this purpose?

---

Answer from Richard Rost:

It's not terribly hard to use the SendObject command, but if you have absolutely NO background in programming or writing macros, it's going to be.

I will say up front that I do cover this concept in my Access 329 tutorial:

http://www.599cd.com/site/courselist/access/access329?key=BlFAlEx

This is an advanced tutorial, however, and it covers emailing purchase orders to vendors - both individually and in batches. You can probably use the exact same concept for what you're doing - send batches of emails on anniversary dates.

But again, if you have NO experience with macros or VBA programming, you might want to start with a more basic tutorial first.

It would certainly take me much longer than I can spend to explain how to do the whole thing HERE, but basically you're going to need to create a programming loop called a RECORDSET that will iterate through your records that need emails, and then issue the SendObject command for each one.

I know this probably doesn't help you much, but that's about the easiest I can explain it here.