All Ability Bowling Newsletter System
A comprehensive email newsletter management system built with React, Node.js, and SQLite. Features subscriber management, announcement creation, email sending, and RSVP tracking with a beautiful, modern interface.
✨ Features
📧 Email Management
- Professional Email Templates: Beautiful, responsive HTML emails with gradient headers
- SMTP Integration: Reliable email delivery using Nodemailer
- Bulk Email Sending: Send announcements to all subscribers simultaneously
- Email Status Tracking: Monitor sent/failed email delivery
👥 Subscriber Management
- Add/Remove Subscribers: Easy subscriber management with name and email
- Subscriber Analytics: View subscription dates and manage active subscribers
- Bulk Operations: Efficient handling of large subscriber lists
- Data Validation: Email validation and duplicate prevention
📝 Announcement System
- Rich Content Creation: Create detailed announcements with formatting
- Draft Management: Save announcements as drafts before sending
- RSVP Integration: Optional Yes/No response collection
- Send History: Track when announcements were sent
✅ RSVP Tracking
- Secure Response Links: UUID-based tokens with expiration (30 days)
- One-Click Responses: Yes/No buttons directly in emails
- Response Analytics: Visual dashboard showing attendance statistics
- Automatic Recording: Responses automatically saved to database
🎨 Modern Interface
- Apple-Level Design: Clean, professional interface with smooth animations
- Responsive Layout: Optimized for desktop, tablet, and mobile
- Real-Time Updates: Live status updates and loading states
- Intuitive Navigation: Tab-based interface with clear visual hierarchy
🛠️ Technology Stack
- Frontend: React 18, TypeScript, Tailwind CSS, Lucide Icons
- Backend: Node.js, Express.js, SQLite3
- Email: Nodemailer with SMTP support
- Build Tools: Vite, ESLint, PostCSS
- Database: SQLite with automatic schema creation