Hi,
I need an excel macro that will lift information from specific cells in a spreadsheet and populate an Outloock mail template.
I am trying to automate approval emails.
I have the Outlook template created and I have a list of groups with corresponding approvers in the same rows.
What I need is to be able to highlight a group which requires approval and click on a Macro, this macro needs to take the highlighted group and corresponding approvers mail id's and populate the mail template.
Group - Column B
Approver1 - Column c
Approver2 - Column E
MS Office 2007
Is this possible? Any ref points?
I have tried searching the web but have been unable to uncover anything.
Thanks in advance!
I need an excel macro that will lift information from specific cells in a spreadsheet and populate an Outloock mail template.
I am trying to automate approval emails.
I have the Outlook template created and I have a list of groups with corresponding approvers in the same rows.
What I need is to be able to highlight a group which requires approval and click on a Macro, this macro needs to take the highlighted group and corresponding approvers mail id's and populate the mail template.
Group - Column B
Approver1 - Column c
Approver2 - Column E
MS Office 2007
Is this possible? Any ref points?
I have tried searching the web but have been unable to uncover anything.
Thanks in advance!
