Expand the scope of a Macro-Enabled Excel Worksheet

Description of excel work: We currently produce PDF reports from a Macro-Enabled Excel worksheet. We would like to expand the scope of the Macro so that these PDF reports are automatically sent as an attachment to an email so we don't have to do it. We use Microsoft Outlook for sending emails.

Attached is the Macro-Enabled Excel worksheet currently we use to produce the reports. The report goes to the employers we work with on Cycle to Work (Column I in Report is the employers unique reference which is taken from Column G in Register) and shows those employees who will be reaching the end of their hire agreement that month. The reports go to the email address showing in Column BY in Register (currently showing our email addresses for reasons of confidentiality).

Also attached is the standard email we use to send the reports which has a standard PDF attachment.
Extra notes: