🚗 Policy Email Automation
✉️ Email Automation Suite An automated, web-based desktop application built with Streamlit and Microsoft Outlook COM Automation ( pywin32 ) . This suite allows operations and support teams to process bulk recipient data from Excel, automatically match corresponding PDF policy documents from a local directory, and save formatted email drafts directly into Microsoft Outlook. https://github.com/ennashm-cmd/-Automated-Policy-Email-Draft-Generator 🌟 Key Features Intelligent File Matching: Automatically searches a designated local directory for PDF files containing matching Policy Numbers . Flexible Email Content: Supports customized per-row email content provided directly within the Excel file (Column G), with fallback template support. Thread-Safe Outlook Integration: Uses pythoncom initialization to safely communicate with local desktop Microsoft Outlook and save emails directly into your Drafts folder. Live Execution Tracking: Stage 2 execution includes real-time progress in...