+ Reply to Thread
Results 1 to 6 of 6

Separate thousands of emails into 1000 group.

  1. #1
    Registered User
    Join Date
    07-16-2018
    Location
    usa
    MS-Off Ver
    2013
    Posts
    3

    Separate thousands of emails into 1000 group.

    I currently receive clients through a list with their first, last name and also their email. However there are sometimes over 10,000 emails.
    I would like to push a button that selects exactly 1000 emails. Push button again, another set of 1000 emails that can be selected/copied and put into my email client.
    Not sure if there is a formula out there, or if I have to write a macro for this function to happen.
    Any help would be appreciated.

    Thank you in advance!

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,882

    Re: Separate thousands of emails into 1000 group.

    Do you want them to be sequential from the list or do you just want a random 1000? A macro is the way to go here.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    07-16-2018
    Location
    usa
    MS-Off Ver
    2013
    Posts
    3

    Re: Separate thousands of emails into 1000 group.

    Sequential Would be great, that way the same email isnt used twice.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,882

    Re: Separate thousands of emails into 1000 group.

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    07-16-2018
    Location
    usa
    MS-Off Ver
    2013
    Posts
    3

    Re: Separate thousands of emails into 1000 group.

    Thank You! Worked beautifully! If I have questions, I will let you know.

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,882

    Re: Separate thousands of emails into 1000 group.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks for the rep!

+ 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. Reply to group of emails using a VB script - Outlook
    By maguid9 in forum Outlook Programming / VBA / Macros
    Replies: 1
    Last Post: 03-03-2016, 12:12 PM
  2. Users send emails to themselves and it's delivered to a group of people?
    By MetroBOS in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 09-19-2014, 02:53 PM
  3. I have thousands of emails separated by commas, looking for a formula..
    By Sankeys in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-28-2014, 07:34 PM
  4. [SOLVED] How I can pull out .... unique emails in a separate column?
    By todorko in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-20-2013, 02:52 PM
  5. Do not create separate emails - concatenate in one
    By kamle_b in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2007, 12:24 PM
  6. [SOLVED] separate in hundreds, thousands, etc
    By !..:: Enang ::..! in forum Excel General
    Replies: 5
    Last Post: 09-24-2005, 01:05 AM
  7. send group emails
    By hanasamo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-09-2005, 06:05 AM

Tags for this Thread

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