Sending Outlook mail using Excel VBA

I have a VBA macro working - mostly - that copies part of an Excel worksheet and pastes (with formatting) into a new Outlook email, between surrounding text blocks.   Trouble is, the macro is not r...