Excel VBA Macro to Extract Outlook GAL Email Address Using Alias

[kirin999]

You can use the following VBA code to extract Outlook GAL email addresses using aliases for multiple rows:

Sub GetExchangeUserDetailsFromAlias()
    
    Dim str As String
    Dim olApp As Object 'Outlook.Application