Setting up Conditional Formatting in Outlook based on Attendees' Email Addresses for Meetings with at least one person from a specific company

Microsoft Outlook provides a variety of features, one of which is conditional formatting for calendar items. This feature can help you organize and quickly identify meetings and appointments based on specific criteria such as attendee email addresses. This article will explain the step-by-step process and key concepts of setting up conditional formatting for Outlook meetings based on the attendees' email addresses, specifically for least one person from a specific company.

Prerequisites

To get started, make sure your system meets the following requirements:

• Microsoft Outlook desktop client installed (Windows or Mac)
• Access to calendar and ability to create/modify appointments or meetings

Key Concepts

Here are some key terms and concepts related to the topic:

• Conditional Formatting: A feature that allows you to customize the appearance (color, font, etc.) of Outlook items based on certain criteria or conditions, such as categories, flags, and specific criteria involving text or dates.
• Calendar Items: Appointment, meeting, event, or occurrence within a user's calendar in Outlook.
• Attendees: The people who have been invited to a meeting or an event within Outlook.

Step-by-Step Guide

Let's start with the step-by-step guide:

1. Open Outlook and access your Calendar

Launch your Outlook desktop client, and click on the Calendar button in the navigation menu on the bottom-left of the screen.

2. Create a new appointment or select an existing one

If you want to create a new appointment, go to the Home tab and click New Appointment. If you'd prefer to use an existing appointment, double-click on it to open it. For this example, we'll create a new one.

// For creating a new appointment, use the following VBA code snippet:
Dim myOlApp As Outlook.Application
Set myOlApp = New Outlook.Application

Dim myAppt As AppointmentItem
Set myAppt = myOlApp.CreateItem(olAppointmentItem)

With myAppt
 .Subject = "Sample Meeting"
 .Location = "Conference Room 1"
 .Start = Date
 .Duration = 60 ' 1 hour
End With

myAppt.Send

3. Access the Conditional Formatting dialog

To access the conditional formatting dialog:

1. Go to the View tab.
2. In the Current View group, click View Settings.
3. Under the Advanced View Settings dialog, click Conditional Formatting.

4. Create a new rule for attendees' email addresses

To create a new rule for attendees' email addresses:

1. Click Add in the Conditional Formatting dialog.
2. In the Name field, enter a descriptive name for your new rule.
3. Under the Format cells that contain dropdown, click on the Specific words or phrases option.

   

4. In the Words or Phrases text box, enter the email address or domain (for example, [companyname]@example.com). A company name within angle brackets is required.

5. You can now define the formatting options.
   

   

6. Click OK to close the Conditional Formatting dialog and apply the new rule.

5. Test the rule

To test the rule:

1. Create a new appointment or meeting.
2. Add at least one attendee with a matching email address or domain from the specific company.
3. Verify that the new appointment or meeting now has the newly defined formatting.
   

   

In this article, we covered setting up a conditional formatting rule in Microsoft Outlook based on the attendees' email addresses, specifically for least one person from a specific company. We explained the key concepts of conditional formatting and the step-by-step process to achieve the desired configuration. Here's a quick recap of the process:

1. Access the Calendar within Outlook.
2. Create a new appointment or select an existing one.
3. Open the Conditional Formatting dialog.
4. Create a new rule for attendees' email addresses.
5. Test the rule.

References

• Apply Conditional Formatting Rules to Items in a View
  Official Microsoft documentation about Outlook conditional formatting.