Automated Email Report Distribution Using Excel VBA

Designed and developed an automated solution in Excel using VBA to streamline the daily distribution of pivot table-based reports via Outlook email. The project dynamically filtered pivot data for multiple distribution partners (DSPs), formatted and colored the output based on business rules, and automatically emailed the reports to relevant stakeholders.

Key Features:

Extracted and filtered pivot table data by DSP.

Applied conditional formatting to highlight key data (e.g., delivery performance).

Created and attached individual Excel reports for each DSP.

Sent automated emails with dynamic content and attachments using Outlook integration.

Ensured cleanup of temporary files and sheets to maintain workbook integrity.

Tools Used:

Microsoft Excel

VBA (Visual Basic for Applications)

Microsoft Outlook