+ Reply to Thread
Results 1 to 4 of 4

Random name pairing, no duplicates, 12 months, auto email

  1. #1
    Registered User
    Join Date
    05-25-2015
    Location
    london
    MS-Off Ver
    2007
    Posts
    54

    Random name pairing, no duplicates, 12 months, auto email

    Hi,

    Tricky task, but I want to create a macro that randomly pairs all names in a column without any repeats, then it will draft and send email to each of those pairs.

    but.. then I want to be able to perform this same action again a month later, but not have any repeats of the previous month, until all possible combinations are exhausted.

    I have added an example worksheet with manually sorted lists and some comments to explain the order of actions.

    Any clues on how to even start this? maybe it's worth solving the pairing aspect first, without the emailing - then add that later/separately?

    Any help appreciated.
    Attached Files Attached Files
    Last edited by jjjjjjjjunit; 11-26-2020 at 07:41 AM. Reason: Adding example worksheet

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,120

    Re: Random name pairing, no duplicates, 12 months, auto email

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

  3. #3
    Registered User
    Join Date
    05-25-2015
    Location
    london
    MS-Off Ver
    2007
    Posts
    54

    Re: Random name pairing, no duplicates, 12 months, auto email

    Hi, apologies for that - Ive not been here for a while and forgotten most of what I learned a couple of years ago - hopefully wont take long to get back on the horse.

  4. #4
    Registered User
    Join Date
    05-25-2015
    Location
    london
    MS-Off Ver
    2007
    Posts
    54

    Re: Random name pairing, no duplicates, 12 months, auto email

    Is there way to get a little help on this topic? I'm happy to just get some instructions to start me off, then i can figure it out and ask for specific help when needed? so far I just don't really know if this is possible or if it's so easy that no one wants to entertain it (hopefully the latter, for my sake).

    thanks all. merry xmas.

+ 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. need macro for auto year workbook with auto months and dates
    By thickwall in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-07-2019, 11:55 AM
  2. Random Pairing for an NFL 51 Draw
    By sln2118 in forum Excel General
    Replies: 1
    Last Post: 08-10-2013, 09:22 PM
  3. Set Teams and Random Pairing of names.
    By michellehmcclur in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-14-2013, 06:30 PM
  4. Excel 2007 : Finding, pairing and preventing duplicates
    By valentineumber in forum Excel General
    Replies: 4
    Last Post: 06-14-2012, 01:44 PM
  5. Replies: 0
    Last Post: 04-13-2012, 03:10 AM
  6. Auto-Generate random set of four numbers without duplicates?
    By adrien23 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2011, 06:03 PM
  7. Random pairing
    By woodnwine in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-28-2010, 01:01 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