Results 1 to 1 of 1

Thread: ~How To Make An Excel E-mail List~

  1. #1
    Sarah xmxsummer's Avatar
    Join Date
    Feb 2012
    Thanked 96 Times in 64 Posts

    109 Post(s)
    Time Online
    29 d 9 h 40 m
    Avg. Time Online
    22 m
    Rep Power
    Gamer IDs

    Steam ID: xmxsummer

    ~How To Make An Excel E-mail List~

    Excel is an amazing tool when it comes to wanting to create a huge list of emails with the same base name and different numbers. I read a guide on a different forum last year about using Excel but her method doesn’t work anymore. This one will!

    Now many of the accounts won’t be Unregistered or linked to a Neopets account if it is UR (For example I had 1205 emails run through the checker and only 3 came up as Unregistered and linked to a Neo account) So it's a good idea to make a lot (it only takes a few seconds anyways)

    Pictures demonstrating the steps will be provided at the end of the written steps!

    The Steps (Written)

    Open up Excel and pick a neopets related name (in could be any name but neopets related works fairly well). In Column A Row 1 type in your desired word. Then click in the bottom right corner and drag as far down as you want.

    In Column B Row 1 put in the number 1. Then in Row 2 put in the formula =B1+1. Then repeat the Click and drag process *start with Row 2, not Row 1!*

    In Column C Row 1 type in ‘ The apostrophe is very important! If you don’t put it in before typing the it will say there is an error! It will disappear after you hit enter. Repeat the Click and Drag

    Finally, In Column D type in =Concatenate( *this will be at the top of the little drop down list that shows up* and click A then put a comma and click B then put another comma, and then click C and hit enter. Now you have a full email! Repeat the Click and Drag process
    Then Copy Column D in to a Notepad file. Save it. Run it through the Email Checker and good luck!

    The Steps (Images)
    ---I used but you can use any email site =)

    I hope this helped some of you out! I know it's a simple process and many people probably know how to do it. But I had no idea this was even possible before I read that guide last year xD
    Last edited by xmxsummer; 02-28-2012 at 05:01 PM.

  2. The Following User Says Thank You to xmxsummer For This Useful Post:

    Emiley (02-28-2012)

Posting Permissions

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