hello I hope some help me
I want to do automation in email send mail through SMTP
Step1: extract data from the database
Step2: put that into excel file
Step3: read the data from the excel send it in mail
Hear I can send the email read the data from excel but hear the problem is I want to send the data who are not getting the mail in my database every day new data come for them only we have to send the mail, not for the older one so I plan that filter the data hear I want to add the column to excel after extract the data from database and after sending the mail I will write in that column success.
So my problem is I extract the data from the database every day in that old data also there I don’t want to send the mail to them after I write the success in a new column what I add the data table using add column activity.
Every day we extract the data but don’t sen the data to older data for that what can I do?
Anyone help me!!! please