Guess emails using database

Lengkap Disiarkan 7 tahun lepas Dibayar semasa penghantaran
Lengkap Dibayar semasa penghantaran

This job can be done with EXCEL / ACCESS. Eventually you can propose some others options.

We have a database of names + email (tab DB1). It's only example on the file attached. I have 20000 emails in the real file.

We have another database only with names (tab DB2). Also several thousands of names to update.

We want an algorythm to rebuild the email in 2nd database, using data from 1st.

Algo should work like this:

1. Read the lines from DB2 tab without emails and look for the matching based on Company name

2. Exclude domains from a specific list of emails provider (yahoo, hotmail, orange, gmail ... ). This domains are listed in TAB3 but possible to add more.

3. Check the format of the email based on the EMAIL TYPE tab (12 formats) and exclude the emails not matching with one of the format including information from 1ST NAME and the NAME. If the email doesn't match with a format, don't use it.

4. Count the number of format by domain and keep only the one with the more recurrences.

5. Generate emails using the 1ST NAME and the NAME from DB2 tab based on format.

Then restart the process with lines still without email with this 1st step

1. Read the lines from DB2 tab without emails and look for the matching based on telephone

Then restart the process with lines still without email with this 1st step

1. Read the lines from DB2 tab without emails and look for the matching based on Address

PS: password for the zip file is freelancer

Algoritma Pemasaran E-mel Excel Microsoft Access Visual Basic untuk Aplikasi

ID Projek: #13346791

Tentang projek

28 cadangan Projek jarak jauh Aktif 7 tahun lepas

Dianugerahkan kepada:

DanielVizcaya91

Hello there, my name is Daniel and I would love to help you out with your project. I have a lot of experience developing algorithms for data processing so I know I can be a very valuable asset for your project. I have Lagi

$199 USD dalam 5 hari
(99 Ulasan)
6.9

28 pekerja bebas membida secara purata $176 untuk pekerjaan ini

schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Lagi

$250 USD dalam 3 hari
(371 Ulasan)
8.1
VladimirLilenko

Hello, dear sir! I have registered on the forum not long ago and I have yet completed projects to www.freelancer.com. I am ready to carry out your project in the minimum price and in the shortest possible time and wit Lagi

$125 USD dalam 3 hari
(202 Ulasan)
6.8
rhomeu

A proposal has not yet been provided

$250 USD dalam 3 hari
(66 Ulasan)
7.0
torajiv

Hello I am an exclusive MS Access developer completely dedicated to this platform - I do not work on any other platform. I am also among the top three MS Access developers on this site. You can verify by go Lagi

$200 USD dalam 7 hari
(171 Ulasan)
6.9
sunmoon25

Hi Can we discuss in chat. ...........................

$200 USD dalam 2 hari
(100 Ulasan)
6.7
alaeddindhahri

Hi, I'm a professional Ms Access and VBA developer with strong background in developing and implementing information systems with databases from scratch. I have read your project description and I'll be glad to assist Lagi

$500 USD dalam 5 hari
(72 Ulasan)
5.9
satishtl

- Can get to rebuild the DB2 with mail ids from DB1 based on the algorithm mentioned. - Also can get the emails generated per the template from the outlook mail. - Have expertise in Excel and outlook automation. - Lagi

$140 USD dalam 3 hari
(51 Ulasan)
6.0
khanjzthanjzt

I did such projects already. it will an easy task for me.

$222 USD dalam 5 hari
(11 Ulasan)
4.5
SergeyKyiv

Greetings! My name is Sergey Murzin, I'm from Kyiv, Ukraine. I have 20 years experience with MS Excel/Access/VBA: databases, finance, statistics, accounting, CRM etc. Any code I provide is well structured and Lagi

$145 USD dalam 7 hari
(14 Ulasan)
4.7
Cupilo

Yes, I can help you. I am the right individual to help with your Access and Excel project. I am very good at designing database solutions and have worked extensively with user interface. I like practical solutions; si Lagi

$200 USD dalam 10 hari
(3 Ulasan)
3.6
collonmade

Hello, Check our profile we have 100 % completion rate with on time delivery . We have expert developers here and they are fast so you will have guaranteed delivery on time . We also worked on penalty for late deliver Lagi

$132 USD dalam 2 hari
(3 Ulasan)
3.3
cracken

Hi Brivazac, I am competitive to this kind of task, can take good care of this project. In fact, I already done related to this job before. Let me know the best of your time so we can discuss further based on your req Lagi

$249 USD dalam 3 hari
(4 Ulasan)
2.7
jjalop

I believe that I am the best candidate for this position because of my extensive customer service and management experience and my ability to adapt to any situation. I have a passion for success and goal oriented demea Lagi

$166 USD dalam 3 hari
(0 Ulasan)
0.0
Ketzangel

A proposal has not yet been provided

$55 USD dalam 3 hari
(0 Ulasan)
0.0
christiancundumi

75 in 2 dias

$155 USD dalam 3 hari
(0 Ulasan)
0.0
sudeepxiomi

Sir, this can be done using Excel macro. We can connect any database in Excel using ODBC and even pull out data from websheets. I am confident about this project. But I am new in freelancer. If your company is a verifi Lagi

$222 USD dalam 7 hari
(0 Ulasan)
0.0
cooley29212

View online portfolio at http://www.jeannettecooley.com. Reviewed project specifications and can complete the project within the three days allocated.

$155 USD dalam 3 hari
(0 Ulasan)
0.0
engrouwaida

As i'm experienced in DB design and developing, and as i worked before for more than 5 years in access and VBA , it's my pleasure to bid on your project. and i guarantee that you will like my final work.

$150 USD dalam 7 hari
(0 Ulasan)
0.0