Excel VBA compose email for multiple To's, CC's and BCC's
<p>I am trying to create a single email that sends to multiple people.
Right now I have email addresses in one column and checkboxes for "Send To", "CC" or "BCC" to the right.</p>

<pre><code>Emails address: B3 - B13 (this list will expand, i may end up using lastrow)

"True/False" To: D3- D13

"True/False" CC: F3- F13

"True/False" BCC: H3- H13

Send if TRUE, skip if FALSE.
</code></pre>

<p>I'm sure this is simple &amp; around already but I have looked and I am stuck.</p>

<p>Thanks for any replies.</p>