Email Macro works once then gets stuck

Hi

I have created a macro that filters a list of peoples names for a remittancve advice. It creates a new sheet and emails it to that specific person.

When I run the macro, the first loop works. However when it gets to the second loop it throws up an "Object vairiable or With block vairable not set" on

Please Login or Register  to view this content.

Can anyone help to why this happens and a fix?

I have extracted the loop below:

Please Login or Register  to view this content.

Thank You in advance