Is there any way that outlook can search its address book and put it as one of the recipients of the email based on name?


Like for example, with reference to the attached sheet3, the vba creates a new mail for cost centre QWP that cc to joan lim and greggory. Then with reference to sheet 1, the email is to jane.



Thanks in advance!

test3.xlsx