New Hire Emails
By Richard Rost 6 months ago
Automatically Assign Email Addresses in Access
In this Microsoft Access tutorial, I'm going to show you how to automatically assign email addresses to new hires. We'll use some string manipulation functions and an update query.
Jaydon from San Jose, California (a Platinum Member) asks: We just hired about twenty new employees. I need to assign them all email addresses. We've been using first-initial dot last name at our company domain. Is there a way to do that automatically instead of typing them all in?
Members will learn how to deal with duplicate values. Instead of using an update query, we'll perform a loop with a recordset, process the string replacements, and deal with duplicate values, all in VBA code.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, how to automatically assign new email address in microsoft access, Automatically Create an Email, MS Access auto populating email field
Subscribe to New Hire Emails
Get notifications when this page is updated
Check out these other pages that may be of interest to you: