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 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
Bookmarks