Email address extract

by 4 replies
5
Hi guys,

Probably a basic question, not entirely sure. How do you extract exact email addresses from your lists. Say I have a .TXT or .CSV file list and have various email address in there. But I am looking for only gmail addresses for example how do I extract just gmail addresses?

Can be from notepad TXT file or Excel as can put the file on both just wondering how to do this?

Cheers
#email marketing #address #email #extract
  • You need a list manager.

    Also, keep in mind that you will need to be able to do more than just filtering, etc...

    When sending CPA offers you are going to need to run MD5 suppression lists against your data and not send to any matching records.

    Some suppression lists can be 1 million plus in size and if you are using an ESP, you don't want to be uploading such a huge list. So you want a program that will write matches and you can then upload a custom suppression list that only contains emails that exist in your data.

    Even if you are not using ESPs and you have a mailer that supports suppression files. You should still keep them minimal size.

    So make sure you can run MD5 suppression list and it has the ability to remove the matches or write the matches.
    • [ 1 ] Thanks
  • Send Safe List Manager
    Opt In List Manager

    You can find both of these with some google searches.
    • [ 1 ] Thanks
  • You can use a formula in excel to split the email addresses up by domain name.

    In Column B, use this formula

    =RIGHT(A1,LEN(A1)-FIND("@",A1))

    Assuming Column A has the email address.

    Then after that you can just do a basic filter on column B and select the domain you want.

    Or you can just do a text filter on Column A for contains "@gmail.com"
    • [ 1 ] Thanks
    • [1] reply
    • Thanks a lot man I will try this.

Next Topics on Trending Feed

  • 5

    Hi guys, Probably a basic question, not entirely sure. How do you extract exact email addresses from your lists. Say I have a .TXT or .CSV file list and have various email address in there. But I am looking for only gmail addresses for example how do I extract just gmail addresses?