Attach files created by macro to an email

Hi Team:

I would love some help on this, Below is my code:

Step 1:

Please Login or Register  to view this content.

*Step 2*

Please Login or Register  to view this content.

*Step 3*

Please Login or Register  to view this content.

and this loops until all the branches have been completed. I want to automate this as when it creates the PDF & XLSB that it attaches the file to an email and send it to a group of people based on a range name set out in my emailsettings tab for each branch