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
    Gender
    Location
    Florida
    Posts
    1,025
    Thanks
    12
    Thanked 96 Times in 64 Posts


    Downloads
    89
    Uploads
    0
    Mentioned
    109 Post(s)
    Time Online
    29 d 9 h 40 m
    Avg. Time Online
    22 m
    Rep Power
    7
    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 ‘@emailsite.com. The apostrophe is very important! If you don’t put it in before typing the @emailsite.com 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 Hotmail.com 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
  •