Macro does the Display and Sent 1st email but then Error

Hello all,

Please, Im trying to send a bulk email and I would need help for an error that does not let me send more than 1 email. (I attached the file)

My Macro has 3 parts.

MACRO 1 - First I copy a all data base from one sheet to other:

Please Login or Register  to view this content.

MACRO 2 - Macro for send email

Please Login or Register  to view this content.

PS: between the lines "Range("H2").Value & "<br>" & _" and "Range("H3").Value & "<br>" & _" should be a line that is format of the text but it denies the access to include it on the text.


MACRO 3 - To try to avoid problems of outlook block, I divide the list in packs of 50 and cut/paste

Please Login or Register  to view this content.

I did a test with only 15 emails and send in packs of 5. The emails appear but error when sent on this line on Macro 2:

Please Login or Register  to view this content.

Also please on this line of the Macro 2,

Please Login or Register  to view this content.

I would like to add to this the name of the company according the lines. Something similar with:

Please Login or Register  to view this content.

But also appear error. This mus be a silly error anyway.

Thank you very much for your help.

Cheers

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. 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, and it also maintains VBA formatting.

Click on Edit to open your post, 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

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)