Email multiple people based on response

[plotting]

I have an issue where I will make a meeting in Outlook for 80+ people and some people respond but don't send a reply so when I look in the tracking tab for the meeting I get a bunch of responses that say none because of this and it causes issues with accurate head count for meetings and catering for food.

I want to be able to email everyone in column C that has None as the response excluding the meeting organizer since they will always be none. I also need column A to edited over the course of this. Since I use outlook's GAL it shows each user as First Last for their name like John Doe for example. Everyone in the company has [email protected] as the email so I'm hoping it's possible for someone to be able to turn First Last into that email and then email the list based off if they didn't respond. I attached a sample workbook, I hope this all makes sense

[mongoose36]

What you want to do is possible. It will however require VBA coding. Are you familiar with VBA?

[plotting]

I figured that much, I am familiar with it just have never really used it. I've done some simple programming classes though with making a hello world "program" and other things.

[mongoose36]

1. In your workbook hit Alt + F11 to open the VBA editor.
2. Find your workbook's name in the VBAProject window on the left
3. Right click --> Insert --> Module
4. You can rename the module if you like
5. Double click on the newly created module
6. Paste the following code into it

Please Login or Register  to view this content.

Edit the items in the code marked "Change" or "Change to suit"!

Now to add a button to your sheet to execute the code!
In Office 2010 or 2013 follow these steps to add the Developer Tab if you don't have it

1. Click on File
2. Click on Options
3. Click on Customize Ribbon
4. Check "Developer" in the list on the right
5. Click OK

Back in your sheet...

1. Click on the Developer Tab
2. Click on Insert
3. From the drop down select the top leftmost icon ... Button Form control
4. It will create a cross hairs for you to draw the button where you want it
5. After drawing the button a dialog will pop up for you to select the macro you want executed when the button is clicked
6. Select your new macro's module name

[plotting]

Dude you're awesome, it works great except that it doesn't add "." between First Last so it's showing First <[email protected]> and thus just trying to email [email protected]

[mongoose36]

Two ways to correct this...
Add the "." in column A when you type the name so it's ready for the code, or use two columns one with the first name and one with the last name and modify the code accordingly.

[plotting]

All the text in the sheet is from copying and pasting from the tracking tab. Sometimes they have 80+ users on the list and the person doing this would never figure it out lol. Is there a way to automate that?

[mongoose36]

Is there a space separating first name and last name?

[plotting]

Yes it will be a space for everyone in that column

[mongoose36]

Replace

Please Login or Register  to view this content.

With

Please Login or Register  to view this content.

Will only work for the email if there is one and only one space...

[plotting]

Genius! Thank you so much man!

[mongoose36]

You are most welcome!!

[Leith Ross]

I realize that this post is solved and am posting this code to demonstrate Outlook's ability to lookup the names and return the email addresses from the Contact folder.

Exchange server users often copy the GAL into their Outlook Contacts folder. This code provides a more flexible method of returning an individuals email address and other information as well.

This will send emails to those people in the list that meet the following criteria: Attendance =" Required" and Response = "None". The subject line and email message need to be modified for your email needs.

Please Login or Register  to view this content.