Email Macro working then not executing again?

Hi Forum,

Wondering if any excel gurus would be able to answer a question as its left me scratching my head...

I have produced a script which looks at Sheet1, grabs name and email and emails multiple users, it then copies the sheet data and paste it nicely into an email and sends perfect, however - once its executed the macro, it decides it doesn't fancy doing it anymore and I'm a little bit confused why... So I thought I'd reach out.