Hi there! I am struggling to figure out this userform issue. I want to do three things:
1. Autopopulate matching cell to textbox (from Sheet3) is user form based on a combobox selection.
2. Filter a sheet (2) based on that same selection.
3. Email that sheet (2) based on email address matching to name in textbox.

For example, say I want to email a friend a list of activities based on what city they live in. If I choose Nashville from the dropdown, "John" should populate in the textbox (using the match function). When I click Submit, I want the macro to create a new email to John (using another match function) with the filtered list (as values using the autofilter function) in the attached workbook.

Attached is my failed attempt. Any guidance would be much appreciated. Thanks in advance.

EmailThingstodo.xlsm