+ Reply to Thread
Results 1 to 6 of 6

email validation/verification from website ( remove non-existing valid emails )

  1. #1
    Forum Contributor
    Join Date
    04-25-2014
    Location
    India
    MS-Off Ver
    Excel pro plus 2021
    Posts
    186

    email validation/verification from website ( remove non-existing valid emails )

    hello friends ,
    went through entire forum , but wouldnt find solution ,

    i have around 10000 emails address in column a,
    i am able to send email to all those 10000 , format of those email address are correct ,

    after sending email to those email address ,
    many emails are bounce back in my inbox saying following this :

    Recipient address rejected:
    Host or domain name not found
    The email account that you tried to reach does not exist...

    so in order to find which email address dont have problem , i came accross below links :
    https://tools.email-checker.com/
    http://www.mailtester.com/testmail.php

    but it would be great if we can incorporate in excel vba/marco .....cos manually one by one its time and energy consuming .

    thanks in advance .

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: email validation/verification from website ( remove non-existing valid emails )

    did you try this?
    http://www.vbaexpress.com/kb/getarticle.php?kb_id=281
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Contributor
    Join Date
    04-25-2014
    Location
    India
    MS-Off Ver
    Excel pro plus 2021
    Posts
    186

    Re: email validation/verification from website ( remove non-existing valid emails )

    yes i tried but , as i said ....

    email addresses i have are all correct......

    for example : [email protected] is correct email id ,
    but when we send to this email address ,
    we get message in inbox saying it no longer exit .

    [email protected] is correct in excel ,
    but invalid in server ( web )

    also for better idea i have attach screenshot , please have a look .

  4. #4
    Forum Contributor
    Join Date
    04-25-2014
    Location
    India
    MS-Off Ver
    Excel pro plus 2021
    Posts
    186

    Re: email validation/verification from website ( remove non-existing valid emails )

    [email protected]
    [email protected]
    [email protected]

    all this example are correct in format of email address ,
    but in real web they don't exist .....

    how to recognize them through with given website address ?
    https://tools.email-checker.com/
    http://www.mailtester.com/testmail.php

  5. #5
    Forum Contributor
    Join Date
    04-25-2014
    Location
    India
    MS-Off Ver
    Excel pro plus 2021
    Posts
    186

    Re: email validation/verification from website ( remove non-existing valid emails )

    [email protected]
    [email protected]
    [email protected]

    all this example are correct in format of email address ,
    but in real web they don't exist .....

    how to recognize them through with given website address ?
    https://tools.email-checker.com/
    http://www.mailtester.com/testmail.php

  6. #6
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: email validation/verification from website ( remove non-existing valid emails )

    so i went to the website they have brief description of how the programs work
    while not understanding all of it, this does not sound like something that (standard) excel can do

    anyway, they have a paid versions of it on the site
    what you are asking for is a way to do it without paying
    if i knew a way i should be charging

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Valid email id check
    By luxmraj in forum Excel General
    Replies: 5
    Last Post: 11-09-2021, 12:51 PM
  2. possible to extract emails through all pages of a website?
    By lubbamkt in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 10-28-2014, 11:34 PM
  3. Extracting valid emails
    By sathishkm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-08-2013, 05:33 AM
  4. existing macro to send emails to multiple recipents needs fix
    By kiranpat in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-17-2013, 12:17 AM
  5. Replies: 0
    Last Post: 02-21-2006, 05:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1