count votes in outlook email

How to Count Votes in Outlook Email

By Andrew Lee
AD

Ever needed to count votes from Outlook emails? It's not as straightforward as clicking a button, but it's doable. Here's a step-by-step guide to help you tally those votes effectively. Let's dive in.

Outlook, a popular email client, doesn't have a built-in vote counting feature. However, with a little creativity and the use of some built-in tools, you can still compile and count votes from your colleagues, clients, or team members.

Using Spreadsheets to Count Votes

One of the easiest ways to count votes from Outlook emails is by utilizing a spreadsheet tool like Excel or Google Sheets. Here's how:

AD
an outlook feature that will save you
an outlook feature that will save you
a computer screen with some type of email in the bottom right hand corner, and an image of someone's profile on top left
a computer screen with some type of email in the bottom right hand corner, and an image of someone's profile on top left
7 things you didn’t know you could do in Outlook!
7 things you didn’t know you could do in Outlook!

First, create a new spreadsheet. In the first column, list the options that voters can choose from, and in the second column, insert a header for the email addresses of the voters.

Manually Inputting Votes

When you receive a vote, manually input the voter's email address and their chosen option into the appropriate cells. This method allows you to keep a record of all votes and ensures that each voter's choice is accurately counted.

How to Quickly Export Voting Statistics from an Outlook Email to an Excel Worksheet
How to Quickly Export Voting Statistics from an Outlook Email to an Excel Worksheet
How to change the display of the Mail Count in Outlook
How to change the display of the Mail Count in Outlook
the settings dialog box for selecting font and number
the settings dialog box for selecting font and number

However, this method can be time-consuming, especially if you receive a large number of votes. To make the process more efficient, consider the following alternatives.

Automating the Vote Counting Process

If you're comfortable with using VBA (Visual Basic for Applications) in Excel or Google Apps Script for Google Sheets, you can automate the voting process. By creating a macro or a script, you can automatically input the voter's email address and their chosen option into the spreadsheet whenever you receive a vote.

AD

Here's a simple breakdown of how you can do this in both platforms:

an email message with the text change mail color and size for certain people, the boss rules
an email message with the text change mail color and size for certain people, the boss rules
an email form with the message's address and contact details highlighted in red text
an email form with the message's address and contact details highlighted in red text
1M views · 3.4K reactions | #fyp | Office365pro | Facebook
1M views · 3.4K reactions | #fyp | Office365pro | Facebook
How to Force Outlook to Spellcheck Emails Before They're Sent
How to Force Outlook to Spellcheck Emails Before They're Sent
20 Outlook Web Tips and Tricks | Microsoft Outlook 365 tips for Email, Calendar, Teams & more
20 Outlook Web Tips and Tricks | Microsoft Outlook 365 tips for Email, Calendar, Teams & more
How I Get Things Done in Outlook
How I Get Things Done in Outlook

Excel (VBA)

Open the VBA editor and create a new module. Write a macro that checks for new emails in your Outlook inbox, parses the sender's email address and their vote from the email body, and inputs them into the spreadsheet.

Google Sheets (Google Apps Script)

Create a new Google Apps Script project. Write a script that performs the same actions as the VBA macro. You can run the script manually or set it up to trigger automatically using Google Sheets' built-in triggers.

AD

Using Conditional Formatting to Track Votes

Another way to use spreadsheets to count votes is by employing conditional formatting. This method allows you to quickly see the most popular choices by color-coding cells based on their content.

First, input the choices in the first column and the email addresses in the second column, just like in the previous method. Then, use conditional formatting to color-code the cells containing the choices, with different colors representing different options. This will allow you to quickly see the most popular choices at a glance.

Tracking Votes in Real-Time

To make this method even more effective, you can use Google Sheets' built-in collaboration features to allow multiple people to input votes at the same time. This way, you can track the votes and see the color-coded results in real-time, making it perfect for live decision-making sessions or elections.

AD

Limiting Votes to One Per Person

To prevent people from voting more than once, you can use data validation to limit each email address to a single choice. This ensures that each person's vote is counted only once, whatever the choice.

Remember, when it comes to counting votes from Outlook emails, spreading the word about the available choices and how to vote is half the battle. Include clear instructions in your initial vote-casting email, and remind voters to include their chosen option and their email address in the email subject line or body to make your job easier.

In the end, while Outlook itself may not have built-in vote-counting functionality, with a little creativity and the use of spreadsheet tools like Excel or Google Sheets, you can efficiently tally votes from your Outlook inbox. Happy voting!

AD