Thanks, however, I do not think I have explained myself well.

The way we track changes to documents is through register in excel which has a tracking number per row per document. each row will have all info about the tracking number relating to the document.

I need to automate emails to be populated with data from the particualr row that relates to the tracking number. So if i wantt o send an email due to tracking number 001 reached stage 05 - i want o be able to send an email by either selecting the row of the tracking number or selecting the tracking number, i need the email to look along the row (like lookup) and start populating the data for the particular stage in the template email. I would prefer to have a separate code for each different stage and email.