Our Applicant Tracking System (ATS) is based on SQL (Microsoft SQL server). At times, we send out a high number of e-mails. Often, e-mail addresses are incorrect or outdated and we get lots of 'undeliverable' messages.
We need these records to be updated in our ATS and we need a program/macro to be written that allows us to update records on our own at any given time.
The basis for the undeliverable e-mails will be either an Excel, csv or txt file which only contains incorrect e-mail addresses. We will provide this file (which will be created by pulling the addresses from Outlook’s undeliverable messages).
Here are the steps and what needs to be achieved:
1. Take one e-mail address at a time from the provided file.
2. Look for the matching e-mail address in our ATS.
3. Replace the existing e-mail with a note in that same (e-mail address) field, e.g. “_e-mail incorrect: ‘[url removed, login to view]’ “ (“[url removed, login to view]” is an example for an incorrect e-mail address).
Note: We should be able to edit the “_e-mail incorrect:” part (e.g. to “_e-mail to be researched: ‘[url removed, login to view]’ “ or something similar).
4. Take the next e-mail address and repeat the above steps.
If you're interested, please let us know how quickly you think such project can be done and what the total cost would be.
We look forward to hearing from you!
43 freelancers are bidding on average $144 for this job
Hi Good Day I can develop this system in 3 days. Your requirements are very clear for me. I have a good track record here. Looking forward to hear from you. Thanks Rinsad
Hi . Let me do this project for you I'm a programmers and I have experience on this issue I look forward to working with you, thank you ! Please discuss with me, give me this chance.
Do you need a windows application or web page for this. I recommend using windows application. I can develop this in no time. Do let me know the Excel format as sample. Thanks
Hi there, Yes I am interested and I will you a an executable file which can be either in a GUI mode or silent mode to do this update. Let me know if you would like to me do this for you. Ajz
hey there, please share the ms sql server details and also which table the update needs to be done. Please share the sample excel / csv/ text file which has invalid email addresses. Thank you !