I am on project to generate auto-mails based on filtered email id column.
in Excel, I am filtering 1 email id in column M, copy filtered data from column B to J & paste it in outlook body. Copy that filtered email ID in To field of outlook. Send the email.
Again I filter for next...