E-mail compilation with data collection (easy)

[theblackrazor]

I've been working on this for a minute now,
I have a macro to send e-mails and I have a macro to store the sent information in a table on another sheet.
I need to find a way to combine the two and make the sendmail macro conditional based on cell input.
Based on (let's say) cell(E2) (there will be 5 choices available) the Recipient and CC will have to change accordingly (5 options)
Could be done via a nested if statement with a couple linked cells that would change based on this(E2) cells input, and link it to the recepient+cc, but I was looking for a VBA solution.
Plus i need two of them combined, so I would end up with one complex macro.
So i just need to clean this up and put the two together so both actions (send + cut) are performed in this exact order. I've considered a macro triggering both, but it wouldn't be as good as one macro that just does both (in the right sequence)
In essence, I want to (by the press of the button) send an e-mail based on cell input (with recipient/cc based on a cell value) and then paste the cell input into a database on the 2nd sheet.

[theblackrazor]

Attaching stuff here because I'm a goldfish
Also please advise if anyone knows how many Excel tables I can merge in a query without making it inoperable by slower PCs (if thats at all relevant)