Đang Thực Hiện

Simple Access Database

I need a very simple database created. Option that I am looking for is access. My requirement is given below and budget for the project is $30.

I get a list of few thousand e-ma-ils everyday which I need to check for duplicates, unsubscribe, bounces. Here is the project detail.

1. New e-ma-il List received daily with two columns e-ma-il address and source of e-ma-il

2. Add all the e-ma-ils to the main e-ma-il database and remove the duplicates.

3. Some e-ma-ils with specific domain names needs to be deleted from the Master List. Example if an e-ma-il address is , then this e-ma-il needs to be removed from the database as we don't want any e-ma-il with "[url removed, login to view]". The list of domain names is updated on a regular basis which we don't want in our database and thus there has to be form / table where i can update the same.

4. After all this is completed, say my database is left with 1000 e-ma-ils and I need to send e-ma-ils to 200 out of these 1000 e-ma-ils today and thus I should get an option to import these 200 e-ma-ils to an excel sheet. As soon as I import these for sending out, the column next to these e-ma-ils should get updated with today's date and then we are left with 800 unsent e-ma-ils.

Next day the same process happens and we have added 500 new e-ma-ils to the database after removing duplication etc and now we are left with 1300 e-ma-ils. Thus now I should be be able to send 600 e-ma-ils and these 600 should get updated with today's date so that tomorrow i only get those e-ma-ils which have not been sent out.

The e-ma-ils that I am sending out should also cross check themselves against two separate tables called bounce table and unsubscribe table and if there are any e-ma-ils which are in these two table, those would not get imported for sending out.

I need a very simple user friendly with a GUI access database. My e-ma-ils would be over 100,000 per day and thus if you think I should go for some other option then please do recommend. My budget it $30 for the project.

Kỹ năng: Microsoft Access, Visual Basic

Xem thêm: microsoft project import, daily access, source database, process access, domain bounce, cross domain, access database, excel database visual basic, simple database visual basic, simple address database excel, regular basic, database remove duplicates, excel access table, simple check date, microsoft project user friendly, added database, update form access, bounce project, excel column update, database sheet, excel import access, bounces, imported regular, simple access example, add access

Về Bên Thuê:
( 337 nhận xét ) Mumbai, India

Mã Dự Án: #1674184

Đã trao cho:

torajiv

More details in PM - Thanks Rajiv

$50 USD trong 5 ngày
(95 Đánh Giá)
6.2

4 freelancer đang chào giá trung bình $78 cho công việc này

becomeexpert

Can be done. Please see details in PM.

$30 USD trong 10 ngày
(1 Đánh Giá)
4.4
amritprakash206

I have done several automation like this for my current employer. There is not much head way in completing this task.

$200 USD trong 7 ngày
(0 Đánh Giá)
0.0
sea121

very cheap very fast

$30 USD trong 3 ngày
(0 Đánh Giá)
0.0