The following Google Apps Script code is designed to lookup an email address from a given set of initials. It will do this by searching for a matching set of initials on another sheet then returning the email address associated with it.
The code loops through the Assignee column taking one set of initials at a time, to then create another loop to go through the Initials column of the Email Address tab. If it finds a match then the corresponding value from column 2 (the actual email address) is defined as a variable. Eventually this function will lead into sending automated email invites to people that have an associated email address.
Lookup Email Address.xlsx
No comments:
Post a Comment