+ Reply to Thread
Results 1 to 4 of 4

Anyone willing to help create this permutator?

  1. #1
    Registered User
    Join Date
    02-08-2015
    Location
    New Jersey
    MS-Off Ver
    365
    Posts
    24

    Anyone willing to help create this permutator?

    Hi everyone,

    As much as I hate asking, I figured it would be much less time consuming than me trying to figure this out myself. I am trying to create a small email permutator. Ihave a list of first and last names with company domains. I want to create the most common email addresses using formulas. Attached:

    Column A = First Name
    Column B = Last name
    Column C = company domain
    Column E = the email variation I would like to create

    If anyone is willing to help it would be extremely appreciated. I'm close to finally finishing this project.


    -m
    Attached Files Attached Files

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Anyone willing to help create this permutator?

    Might I ask the purpose of such a project?
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    02-28-2015
    Location
    Tennessee, USA
    MS-Off Ver
    2010
    Posts
    25

    Re: Anyone willing to help create this permutator?

    I attached a solution (not a very fancy one though). The trim function is included in the formulas because the "John " has a space following the last letter. Hope this isn't contributing to more spam, but whatevs...
    Attached Files Attached Files
    Last edited by ibt; 03-01-2015 at 12:38 AM.

  4. #4
    Registered User
    Join Date
    02-08-2015
    Location
    New Jersey
    MS-Off Ver
    365
    Posts
    24

    Re: Anyone willing to help create this permutator?

    ibt-thank you very much. i appreciate you taking the time to help me out!

    J - I have a number of contacts with no email addresses. This permutator will allow me to send an email to multiple addresses at once and and with addition by subtraction, I will be able to obtain their correct email addresses.

+ 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. Replies: 1
    Last Post: 07-23-2014, 04:33 AM
  2. [SOLVED] Help me fix attached code (create Outlook email then create calendar item)
    By Rerock in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-19-2013, 08:15 PM
  3. Vba cmd1 create workbook cmd2 create worksheet depend upon combobox values
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-17-2013, 03:20 AM
  4. Replies: 3
    Last Post: 11-12-2012, 10:33 AM
  5. Create dictionary of terms, create first time user site
    By Solitaire Jane Austin in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-19-2006, 05:55 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