Add Checkboxes that will return emails addresses in the BCC field into Outlook

I am building an email in Excel for Outlook using the following code:

Please Login or Register  to view this content.

I want to use check boxes (using the form controls) to decide whether an email is used.

If the check box reference cell is true input the value of a cell (an email address) into the BCC field.

If Cell H4=True return Cell F4.

Going down a list of about 30 entries so this needs to loop until there are no more check boxes

How do I write this code?

Welcome to the forum!

Unfortunately your first post did not comply with Rule 3 of our ForumRULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here.

As a courtesy, I have added the code tags for you this time. In future, you will need to add them yourself, please.