For marketing reasons (direct mail (post) and emails) I have gathered a lot of address sets in MS Ecxel. As this gets hard to manage (update, select, review) I would like to have them in one relational database. (MS Access would be fine as I work in a MicroSoft Office environment - other proposals welcome).
What I need:
1. Normalized database with some fields (name, addresses, email, date, interest, target group, source, ...). Where names can be linked to multiple intrest / target groups.
2. Easy way to select addresses (based on intrests or target groups they belong to) and export them to Excel.
3. Easy way to add addresses, preferably through import of Excel files. Should ideally check for eventual pre-existence of added name so that I do not overwrite data without knowing)
4. linked to (3.): a way to deduplicate data (double names, addresses, ...) [some of the data I have will contain double information]
And that's it!
(I have the table field names and target groups listed, will send it when we work together)
31 freelancere byder i gennemsnit €133 for dette job
hi we could do it perfectly with accuracy, please let us know if you want any clarification. if you want us to share our skill and previous work please initiate the chat..
Hi Dear, I am having 7+ yrs of exp in PHP/MYSQL/MS ACCESS. I can design such a CRM for you in PHP. You can import/export the list from it. Will provide you functionality like, Run-time EDIT, delete, duplicate check.