In Progress

Data Mining and Data refining for a Mail Merge

I’m looking for someone who help me extract database information from the web and from pdf documents and reform and reformat that data to be placed into columns in an excel spreadsheet for a subsequent mail merge. One source is from the web: [url removed, login to view] On this website there are two options for data: “State and County” and “Probation”. I need the data from the “State and County”. Each day, I go to this website and get the data from the “State and County” report. Incidentally, this report contains a list of every person who was arrested in this county for each particular day. I need a program or whatever function you deem appropriate to grab the specific data I need from the report, and organize and place it into columns in an excel spreadsheet.

Specifically, the data I need is as follows: 1) the full name of the arrested person; 2) the full mailing address of the arrested person; 3) the level of criminal charge the person was arrested for; 4) the name(s) of each specific crime the arrested person was charged with; and 5) the status of the person’s case. I would like this information placed into columns in an excel spreadsheet as follows: 1) first name; 2) last name; 3) street number and street name; 4) city; 5) state; 6) zip code; 7) level of charge (i.e. class a, b, or c misdemeanor or 1st, 2nd, 3rd degree felony or state jail felony); 8) name of crime charged with; and 9) status of case.

The second form of databases I need to do the exact same thing from are the attached reports. These reports are emailed to me daily in pdf format. I need the exact same thing from them.

I then sort and filter through this data and put it into a mail merge so I can send solicitation letters to these people to represent them as their attorney in the specific crime they are charged with. I already process the mail merge myself, but would be interested in further discussing the automation of this entire process if you’re interested in additional work.

I used to have a program that not only downloaded all the foregoing data from the appropriate places (web and e-mail attachment for the pdf documents), but it stopped working. It also did the data refining in excel and completed the mail merge with only two or three keystrokes by me to do all of this (as opposed to the tiedious sorting and refining I do by hand in excel). If you can help me with a program to do all this automatically, I would like to receive a bid on that too (I understand that might cost more than what I am proposing above).

I can provide more detailed information via phone or e-mail if you chose to accept this project. Would like to discuss fully automating this entire project and what additional costs would be entailed. Thanks!

Skills: Bulk Marketing, Data Mining, Data Processing, Excel, Web Scraping

See more: mining refining data, data refining excel, data mining mail merge, data refining, what's data processing, what is sorting data, what is data sorting, what are databases and what are they used for, web attorney, sorting of data, reformat data, processing the data, people as letters, need someone to help with excel reports, m format in excel, looking for attorney, looking for an attorney, html spreadsheet code, html form to spreadsheet, do i need an attorney

About the Employer:
( 0 reviews ) Kyle, United States

Project ID: #2416509

Awarded to:


Hi, I can do it. I'm programmer for year and very familiar with vba for excel automation. I can propose you use excel vba for this tasks. I need more information from you, please check the PMB for detail! Best regards More

$300 USD in 10 days
(20 Reviews)

18 freelancers are bidding on average $439 for this job


I worked on many similar projects, I have big experience in data mining projects. I can finish this task in short time, with the best quality.

$750 USD in 10 days
(18 Reviews)

Web data harvesting pro with ten years of experience

$250 USD in 3 days
(27 Reviews)

Lets start! Please check PM for further details!

$300 USD in 3 days
(13 Reviews)

Hi, I am very much interested in doing this project and also done similar work before. Kindly provide me a chance to do work on it. Awaiting your positive reply. Thanks and Regards:- Sathish

$750 USD in 10 days
(14 Reviews)

Experienced in similar projects.

$700 USD in 15 days
(7 Reviews)

Hi My names Neha from The AeroDynamic Team based in New Jersey,UK. We are experts in high end Internet marketing, social media optimisation and SEO,Data entry, Web scrapping. we would be pleased to help. There are a More

$500 USD in 30 days
(16 Reviews)

Hello! Greetings of the Day! We are IDOCZ, and are interested in your job offer as we will be suitable for it. Our company provides different outsourcing services as you can see on our website and of course we can get More

$400 USD in 5 days
(24 Reviews)


$300 USD in 17 days
(7 Reviews)

Hello, thank you for posting the project here. I would like to offer to automate the two-tier task, i.e. extracting the information required from the website, formatting, sorting (or with any other manipulations needed More

$250 USD in 5 days
(2 Reviews)

Hi, I'm an expert in this field and can provide you what exactly you are looking for you in best way. Please contact me for more details. Regards, CKJ

$300 USD in 4 days
(0 Reviews)

Custom software development (<b><i>Removed by Admin</i></b>)

$750 USD in 1 day
(0 Reviews)

Hi, Please check your PMB. regards, Arun

$250 USD in 20 days
(0 Reviews)

Intital Payment : $0 (No advance) Work 5 years as a Software Developer. Familiar with Enterprise technologies (Different Application Servers) and many programming languages. Technical Skills: Programming More

$251 USD in 5 days
(0 Reviews)

Dear Sir, Experience data miner here, for more information please check your private message box. thanks and regards

$400 USD in 10 days
(2 Reviews)

Hello, I have developed similar applications and please check your inbox for details about the prototype. Thanks

$400 USD in 4 days
(0 Reviews)

By profession i'm an accountant. have knowledge of excel and word. Will do your project as per your requirements

$500 USD in 21 days
(0 Reviews)

Hello, I'm interested on this project.I have experienced in pc skills,my daily work is connected with ddiffernt type of reports and database information processing. Hope my job will be usefull to you. Regards

$450 USD in 10 days
(0 Reviews)

Hello, I have created over 350 successful web data extraction/screen scraping projects in past 4 years of my career in IT Automation industry. I have many scraping applications that i built for many of my clients More

$400 USD in 7 days
(1 Review)