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.
[TABLE="width: 527"]
<colgroup><col><col><col><col span="4"></colgroup><tbody></tbody>[/TABLE]

[TABLE="width: 429"]
<colgroup><col><col><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD]DistrictShort[/TD]
[TD]Service[/TD]
[TD]Email 1[/TD]
[TD]Email 2[/TD]
[TD]Email 3[/TD]
[TD="align: right"]3[/TD]
[TD]January[/TD]
[/TR]
[TR]
[TD]Beach[/TD]
[TD] [/TD]
[TD]Beach@me.com[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ocean[/TD]
[TD]snail[/TD]
[TD]Ocean@me.com[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Salt[/TD]
[TD]snail[/TD]
[TD]Salt@me.com[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Dolphin[/TD]
[TD] [/TD]
[TD]Dolphin@me.com[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Monkey[/TD]
[TD] [/TD]
[TD]Monkey@me.com[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Sharks[/TD]
[TD]snail[/TD]
[TD]Sharks@me.com[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Jellyfish[/TD]
[TD] [/TD]
[TD]Jellyfish@me.com[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

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.