The rest of this article will be based on the customer table shown above. Create a base query for the email newsletter Here is the table I am going to use for the rest of this article. If you want your email addresses to be clickable and look like a link when displayed on a form in your applications GUI, you can still achieve that with formatting and a few lines of VBA in your form. Its maximum length of 255 characters should usually be enough for any email address. I recommend you use the plain (Short) Text data type to store your email addresses. – As long as you resist the temptation to store them in a hyperlink column. Storing email addresses in an Access database is very simple. Then querying them in VBA, concatenating custom, individual email texts and finally creating the emails and sending them off through your Outlook account. Beginning with storing email addresses in a table. I will show from start to finish how to send a serial email from your database. If that rings with you, this article series is for you. Still you might struggle to put it all together and create a working solution to send emails from your database. Even if you are not too experienced with Access and VBA, you will benefit from reading them. Those are dealing with some of the core challenges of that topic. Send serial email with Microsoft Access, VBA and Outlookīy Philipp Stiefel, originally published June 17th, 2016Īs you probably have seen already, I’ve got quite a few samples and articles on sending email with Access and VBA on this site.

Serial number email sender deluxe