Auto populate hyperlink

Good day to you all, thanks to anyone who takes time to try and help me..

My problem is related to members of staff applying for overtime shifts:

I have a column with dates of the month from the 1st down to the 30th etc..
Along the top of this column is a row with the available shifts listed, i.e 9am to 4pm, 12pm to 6pm etc..
where the column intersects the row i have a hyperlink which, when the user clicks on it, i want to send an email to one specific email address. The intersection has the word "apply", which is a hyperlink. When its clicked on it automatically opens the users outlook. i have the email address sorted, that auto populates with the relavant recipient but i want the subject field to be populated with the date that corresponds to the row and the shift times. When editing the hyperlink obviously i have put the email address in that i want the emails to go to but i dont seem to be able to link the subject field to a cell reference, based on where the user clicked the apply link.

any help very gratefully received

Tony