(How an old 1996 database version kicked
tail end of Microsoft Access 2000!)Dear Reader,
Why is it that I feel like I've been to hell and back?
If you email your prospects or customers, or if you know you should but don't, hopefully my experience will be of value to you.
Does any of this sound familiar?
I had a list of names and email addresses I desperately needed to send emails to. These were people who signed up to resell my product, "The Amazing Formula That Sells Products Like Crazy."
I had a ton of duplicates in my list. For some reason, people sign up multiple times. Yet, I only wanted to send them one email.
Emailing your list of associates, customers and prospects is absolutely essential. I felt humiliated that a stupid database problem was preventing me from contacting my associates on a regular basis.
My list was in this format:
12234 firstname lastname email
The data was listed on a password protected web page. I tried to copy and paste
list into Excel, so I could manipulate it, but that wouldn't work. It wouldn't separate
data into columns.
I tried Boxer 99, an ultra-cool text editor with remove duplicate liens feature.
But it wouldn't remove
duplicates because
first number on each record was different. But
name and email were
same. To Boxer 99, it wasn't a duplicate record.
My email program is supposed to remove duplicate records. For some reason I still don't understand, it wouldn't zap
records for me.
EEEEK!
Feeling exasperated, I decided to "get tough" and import
names into Access. Surely
heavy duty database programs would pull through for me and end my misery and humiliation!
Have you ever tried to remove duplicates in Microsoft Access? Oh my gosh. Don't even try unless you're a professional!
I used a "find duplicates" query to locate
duplicates. But how do you remove them from your list?
Whew! What a nightmare. I never did figure it out. I tried to follow
15 steps in
on-line help file, or however many there were.
But it didn't work.
You'd think there would be a button to click on that says, "remove duplicate records," right? It isn't exactly an unusual or exotic procedure.
Anyway, I hunted all over and tried out some other email programs, figuring that one of them surely would import
data in a format that would allow me to de-dupe
list.
But nothing would work. I tried exporting
list out of Access and then importing it into my email program.
Ugggghhhh!
Finally, a friend of mine said, "Hey, why don't you try Lotus Approach? You can do what you want in only one click!"
I tried to buy Lotus Approach at their web site. But if I remember correctly, I couldn't download it. You had to wait for
CD!
What are they thinking? It's called downloading. Hello!
Anyway, thank God I had an old 1996 version on CD. I wasn't confident I could install it since I probably didn't have
unlock code.
Thankfully, Lotus didn't require multiple unlock codes like a lot of software does today. And it wasn't an upgrade version that required you to hunt down
original version you bought back in
dark ages!
Like you can ever find
original version before
3 upgrades you bought. You know what I'm talking about?