How Do You Count Text Occurrences in Excel AND Export to the Body of an Outlook Email?

Hello Excel-sperts,

I am responsible for summarizing a daily excel report every morning by sending the info out in the body of an Outlook email.

1. Is that possible to do by, say, importing the number in one cell. For example, cell A1=12. Could I somehow link an outlook template to that worksheet so that:
"Good morning all, today we had [A1] new donors to our charity."

2. In my report, there is one column that may have any word in it. I would like to identify all WORDS that occur in 15 or more cells in that column. So in my email, if the words 'apple', banana' and 'orange' occur 15, 17 and 12 times respectively, I would like to be able to export that to the body of my email in this manner (no need for oranges as it occurs less than 15):

"[15 Apples] donated to the charity
"[17 Bananas] donated to the charity"

3. Finally, how would I count the number of times a specific word occurs in a column as opposed to the above where I don't know what words I'm necessarily looking for? So for example: 'Yesses' and 'No's"
"[# of Yes] said they would attend the benefit dinner"
"[# of No] said they would NOT attend the benefit dinner."

Thank you so much for your help in advance. I hope this is clear and concise.
rhexcel

natefarm,
First, thank you so much for your response. Yes, I could pre-sort the list. But what do you mean by "go through the rows and increment the count..." Right now I am sorting the list and selecting all of the words that are the same and then looking at the bottom right of the screen at the counter. It's a lot of work for something that I should (in theory) be able to do in seconds. Thank you again!

Thank you for this response also natefarm. I think I've bitten off more than I can chew with this as it is all Greek to me. I will try to make some sense of this with my very vague recollection of being navigated through the VBA window and I'll report back. I wish I had some equally useful knowledge of something with which I could repay you! Thanks!

natefarm, I bow to your excellency. I am 100% positive this will work as I need, I just have no idea where to begin in Outlook, what to click, where to paste this, which parts of it to change to suit my excel sheet exactly, but I wanted to thank you as I'm still slowly trying to dissect it and learn how to do get your code to the right place to enable it. (I need a lot more hand-holding than I thought.) Shall I still mark this thread as solved then? Thank you so much!

Thank you again, Nate. I tried to do this but I need to start from the very basics first. My problem was solved, but through an much inferior workaround that still requires a few extra steps. I hope this thread can help someone else though. Thank you again for your help. I am definitely inspired to find an excel-to-outlook tutorial. Thank you!