One of the things I created while at the YMCA was an Alumni Registration Program for the Camp Miller site at Sturgeon Lake. It allowed alumni to enter their names, email. years and position at camp into a database where someone could search them out. The person searching could then email them and the site would never disclose the recipient’s email. Everything was handled on the back-end via PHP and MySql. I had to set up a relational database on the host server working with the pages I created (new page templates) on the front-end to collect and display the data. It all had to work in the WordPress template they were using with YMCA approved format/colors. The YMCA can harvest emails from the database for announcements and donation solicitations.
The link to the site is here.