As a compliance department we have 11 stages that require to be completed before a document can be revised and published. It is time consuming entering this info manually from excel into outlook emailing.

Is there any way that I can use VBA/ Macro to allow an email for each stage with the populated data from excel spreadsheet. However, I do need the email in HTML format with an email with instructions how to deal with the stage being emailed.

Data I need populated in;

Subject: (1) Tracking Number, Document Number and Document Titles and Deadline

Body: Date Sent, Deadline, and the info of previous stages that have been completed.

All the info is on the same spreadsheet.

any help towards a solution would be awesome.