Need to create a loop for already working process. Should be easy!

[needshelpwithexcel]

Hi. I need help looping this process for each row until there is a blank value in the A column. I have found many loop codes online but have not been able to make it work for this simple macro. Any help please!?

Thanks!

Please Login or Register  to view this content.

[AB33]

untested.

Please Login or Register  to view this content.

[needshelpwithexcel]

Worked like a charm! Mind sharing what I was doing wrong? Thank you

[needshelpwithexcel]

Hi. Anyone's know how to change the .Display to .Send without the macro losing the HTML formatting? The emails that are being sent need to have a signature with each and therefore need the .html format to stay when the loop is changed Tom.send