Dear Team,
I need code for sending email from excel through outlook.
My condition is,
I am having outstanding data's in Sheet1 ( Customer Name, Inv No, Date, Outstanding Amt, Location , Equip, Product, M/c. Sl. No, Service Engg, No. of Days Pending)
Service Engg name and email ID details in Sheet2
When i am press the Send Email button, first it should ask to select the Service Engg name.
Once I select any Service Engg name, that particular engineer name should auto filter and copy all data's with heading(Customer Name, Inv No, Date, Outstanding Amt, Location , Equip, Product, M/c. Sl. No, Service Engg, No. of Days Pending) which is more than 30 days and send by email.
Email Title: Service Payment outstanding details
Email Subject : Dear Engineer,
Pls find the updated service payment outstanding details for your reference. Kindly contact with customer and try to cleat the payment as soon as possible.
And paste the data's here
I am attached my excel here for your reference.
Kindly do the needful.