Hello

I would like the email below to be populated with the information in specific columns and be sent to a defined email addresses (column N). I know this is possible to do in mail merge, but would ideally like to run this as a VBA macro.
The email should also include the ability to add a clickable hyperlink where specified. Please note, I have added some commentary (e.g PA: A) throughout the email which specifies which column the data is being fed from on the excel spreadsheet.

Parameter Column Included?
PA No A Y
PA Type B Y
PA Request Date C Y
Working days with Current Approver D Y
Working Days since PA raised E N
Vendor Name F Y
Originator Name G Y
Authoriser Name H N
Procurement Category I Y
Currency J Y
PO Total K Y
Current Approver Name L Y
Description M Y
Email N Y
First Name O Y
Surname P Y

EMAIL TEMPLATE

Header of email

PA XXXXXXXX (PA No; A) requires your attention

Body of email

Dear XXXXXXX (First name; O)

PA XXXXXXXX (PA No; A) For: XXXXXXXXXXXXXXXXXXXXXX Description; M) which was raised on the XXXXX (PA request date; C) and has been has been awaiting your approval for XX (working days with approver; D) and requires your immediate review.

PA SUMMARY:

Vendor Name: (F)
Procurement Category: (I)
PA Type: (B)
Currency Type: (J)
PO Total: (K)
Originator: (G)

Please note, if you have already approved this PA, please disregard this email.

Please see below for the link to:

Clickable URL e.g www.google.com

Thanks or your assistance.

Regards

Signature