Hi, I have an excel where is column g agent name is there, column f email is there, now I have filter for every agent copy all data, past in outlook new mail copy email address from column f in to field, populate cc field with specific mails and send the mail, please help me with a macro for this. Thank you.