Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Can Excel find dead email addresses????

0

On average about 10% of email addresses go stale every year, people change jobs change from Gmail to Yahoo, Etc.

How do I get Excel Define did email addresses to minimize the bounce rate?

Thanks.

Answer
Discuss

Answers

0
Selected Answer

I've used zerobounce.net to help clean an old list. It's not perfect and it's not free, but it did a pretty good job for me. Along with that, you should send your emails through a system that manages bounces and other issues so that they will automatically be removed from your list. If you want, I can tell you what I did for teachexcel this year to transition to a more automated email setup that manages all of this for a very reasonable cost, unlike mailchimp.

Update: What I Do/Did

Clean my List

First thing is to make sure your current list is clean and good.

I used zerobounce.net and I chose them after, at the time, looking through lots of different providers of this service. I did a lot of research and tried to figure out what would work well and zerobounce.net seemed like a good option to me, so, I chose them.

At this point though, honestly, I think that most providers of this type of service will offer a similar level of service since the mechanisms that they use to verify the emails are not particularly sophisticated; the checks are pretty standard but most sites just use snazzy language to trump themselves up and make themselves look better than the other guys.

I used zerobounce and they worked ok and I don't have any complaints.

In reality, this should be a 1-time thing that you do. So, chose a provider and get it over with and move on to the next step.

Email Sending Management

This is rather ridiculous at the moment, as companies out there, looking at you MailChimp!!!!!!, charge an insane amount of money if you have a large list. I just checked MailChimp and, though their prices seem like they have come down, they are still very expensive AND the price doesn't scale in a linear fashion!!!! This means that when you hit certain thresholds, you will have a rather large increase in price.

MailChimp: 60,000 subscribers, unlimited emails - $4,200 PER YEAR!!!

Ok, that's a bit of a rant, but I got really annoyed with all these email providers when I was searching for a cost-effective solution.

Solution: Amazon SES + Sendy

Amazon SES  - .10 cents per 1,000 emails - 60,000 email sends = $6

Sendy - $60 USD one time fee.

This is the setup that I now use.

Sendy is something that you setup on your server, VERY easy to do - don't listen to websites that tell you that it's difficult to setup and then want you to user their service!

Amazon SES is what actually sends the emails.

Sendy lets you compose the emails, manage the subscriber lists, do things like that, and then, when you send the emails, Sendy sends them to Amazon SES, which then sends them.

The best part is that Amazon SES sends data back that says if the email bounced or was bad or was reported as spam by the user. Sendy takes this data and updates your email list by removing the bad emails automatically.

The one thing is that Sendy might not have some of the subscriber list management features that you would like. They have some pretty good stuff, but it is not yet as automated as I would like. What this means, to me, is that I have to send multiple campaigns each week to multiple sets of subscribers in order to send them the email in their timezone, versus sending one campaign and having it automatically send the email when it's best for the user. This is, really, my only complaint.

Summary

MailChimp: 60,000 subscribers - unlimited emails - $4,200 yearly.

Sendy Amazon SES: 60,000 subscribers - 52 weekly emails (1 year) - $312 (+$60 1-time fee to buy Sendy)

Let me know if you have more questions or thoughts :)

Discuss

Discussion

I have 35,000 subscribers so I'd love to learn more about how you keep your list scrubbed.

I dobt mind spending money but i don't dwant to wsdte it so any idea how ZeroBounce stacks up against NeverBounce?
gzfraud (rep: 11) Sep 7, '18 at 5:16 am
Most of my sending varies by month so I use ESPs that charge for emails sent, not contacts in my list. 
gzfraud (rep: 11) Sep 7, '18 at 5:22 am
Sorry for the delay, I will update the answer to tell you more - it took me a while to learn about some of these things because all of the big companies spend a lot of money to get in your face and the little, and good guys, can get drowned out.
don (rep: 1989) Sep 13, '18 at 2:32 am
I've been looking at Sendy and the prices are great compared to majors like constant contact and MailChimp but I'm accountant nit ttechie. Could we switch to email or even better is phone call?
[Contact Info. Removed to save you from the Spam Monsters]
gzfraud (rep: 11) Oct 3, '18 at 2:52 pm
I am happy to help you on a forum like this for free but, if you want more specific help, via Email or phone conversation, please use the Contact link at the top of the page and email a support request; this way, everything will be in the system and easier to manage.
don (rep: 1989) Oct 9, '18 at 4:05 am
Been couple years so wondered if you're still using Amazon SES and Sendy? 

If not...
- Why not, what went wrong/features did you need that they didn't have?
- What system are you using now?
- How does new system compare to SES/Sendy?

Thanks.
gzfraud (rep: 11) Nov 25, '21 at 8:01 am
Add to Discussion
0

Excel manages and evaluates data. It doesn't create them. So, imagine that once a year you send out a mail to the tune of "if you wish to continue receiving my emails please reply to this mail with 'Yes'". You might send this mail from a dedicated address so that replies result in a list of all the people who have responded.

This is where Excel can come in. Now, if you pass this list to Excel you would be able to reconcile it with the original mailing list and identify those who didn't respond. There are other ways of creating the list I described. Unfortunately, Excel can help only in processing it but can't be of assistance in its creation.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login