Hi All,
i have one performance data sheet i need to auto mail send to individual data to partners, in Base file performance data and in mail Sheet mail id derails. in both sheet on derails is same "Entity Code" so 1st match the code in both sheet than pick data from performance data sheet and mail iD and Parner name from mail Sheet. and if possible one option can added like yes or No marking whether i want to send the mail to particular partner not. and also add sender signature automatically from Outlook Sig .
i have one performance data sheet i need to auto mail send to individual data to partners, in Base file performance data and in mail Sheet mail id derails. in both sheet on derails is same "Entity Code" so 1st match the code in both sheet than pick data from performance data sheet and mail iD and Parner name from mail Sheet. and if possible one option can added like yes or No marking whether i want to send the mail to particular partner not. and also add sender signature automatically from Outlook Sig .