Hello
Please assist me. Thanks
I have an Excel file say on OneDrive, with columns as below:
Company Manager Administrator
ABC Bob Rick
XYZ Bill Sue
UVW Jill Jack
When I receive a mail, if the Subject or Body contains the Company ( ABC or XYZ or UVW as per above table)
1: Look for the Manager and Administrator in the Excel Sheet
2: Get their Email Addresses
3 Send a mail to the Manager with the original mail as attachment
4: Forward the original mail to the Administrator
Thank you.