If you want to send email from your Microsoft Access database, I have two classes that teach you how to do it.
First, the easiest and simplest solution is to use a Microsoft Word mail merge in conjunction with Microsoft Outlook. Your Access database can be used for the data source to feed a Word mail merge, sending individualized emails to Outlook. This option offers the least amount of flexibility, and is only good for small email batches (a few hundred, perhaps), but it's relatively easy to set up. I cover this in my Microsoft Access Expert Level 20 class.
Now, if you need a lot more flexibility, want to send HUGE email batches, and don't want to be limited to using Word and Outlook for creating and sending your emails, then I have a full Microsoft Access Email Seminar that covers TONS of different options. You can use a different mail provider (like Gmail), attach reports as PDFs, setup mailing lists, and lots more. Click on the seminar link to see everything that's covered.