Cell value in email subject and cell selection in email body

Good morning people,

2 questions... the script down below always worked fine, and still is, but i want to add some extra.

This script basically select cells, and paste it in the body of a email, with preset values.

1 - Keeping the same mindset.. except that i want 2 cell value in the subject of the email...

i want subject to look that way;

Subject; SBK Staff movement - (B4 value) - (b13 value)

2- This script also copy a range of cell .. is it possible to select multiple cells value at different places? like A1:B15 & C4:B15, and putting them on top of each other in the email?

Here is the VBA;

Please Login or Register  to view this content.

Anyone can help me solve this?

I was able to fix Question #2.

Now, i only need help with Cell value in email subject

HTML Code: 

That works ... but i need text in between sheet range, and can't find how.... i want it like " Sbk Staff movement - (b4) - Department: (b10) - (a13)