This internal communications planning calendar helps you map every employee email, newsletter segment, and key observance for the year in one place. Plan each send in a single mastersheet, and your projects populate automatically across 12 monthly calendars. The package includes an editable Excel planning calendar and a printable PDF calendar.
How the calendar works
Calendar days with a note attached (look for the black triangle in the top right corner of the cell) mark U.S. and Canadian federal holidays. The Holiday and Observances tab lists other key dates and awareness months you can plan content around. Each monthly tab also includes a project checklist for deadlines, owners, and status, plus a general notes section and a color code key for teams and projects.
How to use the Comms Mastersheet
- Enter a project name. Start by naming your project (e.g., “Weekly Newsletter Segment”).
- Describe the project objective. Summarize the newsletter item and its goals, focusing on employee engagement.
- Draft a subject line. Create a placeholder subject line that highlights your project or content.
- Specify the distribution list. Indicate who will receive the newsletter (e.g., “All Staff” or “Managers”).
- Define the call to action. Clearly state the action you want employees to take.
- Record metrics. Fill in your goal open rate, then record actual open rate and click-through rate after sending.
- Document next steps. Add any follow-up tasks or steps required.
- Select a send date. Once everything is complete, choose the estimated email send date. Your project will then appear automatically on the monthly calendars.