Craig

One thing you can do is create reference to the relevant workbooks at the appropriate points in the code.

Those references can then be used in the rest of the code whenever you need to refer to the workbooks.

By the way, it's very rarely that you need to activate/select when working between worksheets/workbooks.

PS Not sure about having to 'finish' in a workbook to be able to send it via Outlook, eg if you are sending it as an attachment all you need is the file path and name.s