I'm very new to programming and have been teaching myself over the past months. I manage a small IT shop by myself for my company and I've developed an application for the Accounting Department that helps that maintain authorized customer payment card information on file.
I've been able to design several queries that provide the functionality to find out which customers' payment cards are about to expire (within 7, 15, 30, and 45 days). Currently the only mechanism of notifying the customer is to print off the report and call each of them.
I'd like to be able to build a functionality into my application (say via a button) that allows the user to select either one or multiple records and send an email notice/reminder to the customer that their card is about to expire.
I'm willing to provide the entire source code of the application and the database structure. Any help would be appreciated, thanks.