Using VBA to create email based on information in Excel

[ENAPo]

Hi, I have columns of information that I would like to have a macro open up the email based on criteria and insert all the fields and then leave it open so that I can attach a pdf to the email.

<colgroup><col><col><col><col span="4"></colgroup><tbody></tbody>

DistrictShort	Service	Email 1	Email 2	Email 3	3	January
Beach		Beach@me.com
Ocean	snail	Ocean@me.com
Salt	snail	Salt@me.com
Dolphin		Dolphin@me.com
Monkey		Monkey@me.com
Sharks	snail	Sharks@me.com
Jellyfish		Jellyfish@me.com

<colgroup><col><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>

the number 3 = is counting how many rows contain the criteria "Snail"
January is the month I would like included in the subject
This is what I would like in the email:

To: Email 1
CC: Email 2; Email 3 - If there is any
Subject: January (H1) Invoice for "District Short"
Messsage: Attached is your Snail Invoice. If you have any questions please contact the lifeguard

Thank you,

I have tried researching several different VBA examples but I couldn't narrow it down to what I needed. I am still learning.

Thanks in advance!!

 

[ENAPo]

In case somebody thought this was a joke. The information given are examples. I can't paste the real information.