I am looking to manage a big mailing list - I was originally going to do it in microsoft excel but I cant find a good way to compare the lists and find the results that I havent sent to .. Is Microsoft access the only way to do it easily? I have found that excel will find duplicates but i actually need more intricate results
Any help would be hugely appreciated.
Samantha
2007-01-25 09:30:13 · 4 answers · asked by Samantha 1 in Computers & Internet ➔ Software
Thanks to all - please find a few more details.
The mailing list is for old fashioned postal mail addresses. The different lists that need to be compared are the updated lists collected each week. So .. the original list was sent out to on a certain date. I dont want to send to those again for another 6 weeks - but they may appear in the weekly list. So I need to compare to make sure that I dont resend to the same houses each week.
I know I confused this.. By the way .. when I said big I meant maybe 500 per week (thats big for me.. lol) Thanks all ..
2007-01-25 09:55:53 · update #1
Excel can do it but has a cap of about 17,000 records. You can either sort them or create a "if(a2=a1,1,0)" statement to find dupes easily or scrub through the whole database. You are better of with Access if you know sql commands. Access allows far larger databases.
2007-01-25 09:37:00 · answer #1 · answered by Anonymous · 0⤊ 0⤋
I think Excel is a good solution in some cases. You didn't clarify if you mailing list is for emails or the old fashion postal stuff. If email then you can set up Excel to do a simple cut and paste of the names into Outlook or whatever email program you use when you want to send out a group mailing. You also referred to comparing lists. You didn't clarify why you need two lists and what type of results you are looking for when you compare them. Typically the best solution is to avoid the need for two lists. Also, can you give some detail on the "intricate results" that you need?
2007-01-25 09:48:11 · answer #2 · answered by lindhoo 1 · 0⤊ 0⤋
It's not very clear to me what you mean by "manage" and "compare the lists and find the results that I haven't sent to..."
That said, you may want to look at Act. Act is the number one contact database program used by sales people.
Good luck.
2007-01-25 09:40:26 · answer #3 · answered by Birdman 3 · 0⤊ 0⤋
go with access
Excel is not designed for real database operation and you will regret it later when you data becoming bigger
2007-01-25 09:38:48 · answer #4 · answered by sm bn 6 · 0⤊ 0⤋