VBA - Email subject line to pull date from cell on Sheet

Morning All!

I am need of some assistance.

I have 2 sheets "DAY SHIFT" & "NIGHT SHIFT".

"DAY SHIFT" has a variable date in Cell M6

What I want to do is add that date into an email subject line.

I already have the following code:

Please Login or Register  to view this content.

which was used initially.

Can anybody advise what needs changing as I seem to have tried every variant?

Thanks
Ross

Worked Perfectly.
Thanks!!

My pleasure! Thanks for the feedback.