Post Project
  • Search
    • Buyers can
    • Search offers to buy now
    • Search freelancers to request a proposal
    • Freelancers can
    • Search projects to quote on
  • How it works
  • Log in
  • Sign up
  • Freelancer?
Browse by Category
    Technology & ProgrammingWriting & TranslationDesignDigital MarketingVideo, Photo & ImageBusinessMusic & AudioMarketing, Branding & SalesSocial Media

    Excel Spreadsheet email address creator

    - or -

    Post a project like this
    3402
    £100(approx. $121)
    • Posted: 9 years ago
    • Proposals: 1
    • Remote
    • #228945
    • Awarded
    Jpad Solutions
    has already sent a proposal.
    • 0
    • 0

    Description

    Experience Level: Intermediate
    I need someone highly proficient in excel to create an email iterator. The idea is that there would be an input sheet with a variety of contact records, each with 3 pieces of data:

    First name | Surname | Website address

    e.g. for my own it is:

    Antony | Sommerfeld | www.xxxxxxxxxxxxxx.com

    What I need you to do is from this listing is to create another 12 email patterns e.g.

    antony.sommerfeld@xxxxxxxxxxxxxx.com
    a.sommerfeld@xxxxxxxxxxxx.com
    asommerfeld@xxxxxxxxxxxxxx.com
    antony_sommerfeld@xxxxxxxxxxxxxxxxxxxx.com
    sommerfeld@xxxxxxxxxxx.com
    antonysommerfeld@xxxxxxxxxxxxxxxxxxx.com
    antony@xxxxxxxxxxxxxxxxx.com
    antonys@xxxxxxxxxxxxx.com
    a_sommerfeld@xxxxxxxxxxxxxxxxxx.com
    sommerfelda@xxxxxxxxxxxxxxxxxxxx.com
    as@xxxxxxxxxxxxxx.com
    antony-sommerfeld@xxxxxxxxxxxxxx.com

    This is the case of just simply recognising the email pattern e.g. firstname.surname@websiteaddress.com etc.

    The macro you write must be capable of applying the email pattern to approximately 8,000 contacts i.e. 96,000 contacts would be generated (12 x 8,000). Perhaps sheet 1 could be the input data and sheet 2 could be the output data.

    The sheet you create must be able to be operated on excel 2007 and 2010.

    If you can draw reference to any similar excel work then that would be advantageous.

    Antony S.
    Antony S.
    99% (158)
    Projects Completed
    153
    Freelancers worked with
    105
    Projects awarded
    27%
    Last project
    3 Aug 2022
    United Kingdom

    New Proposal

    Login to your account and send a proposal now to get this project.

    Log in

    Clarification Board Ask a Question

      There are no clarification messages.
    3402
    £100(approx. $121)

    - or -

    Post a project like this
    Antony S.
    Antony S.
    99% (158)
    Projects Completed
    153
    Freelancers worked with
    105
    Projects awarded
    27%
    Last project
    3 Aug 2022
    United Kingdom

    Related project Searches


    spreadsheets web

    Product

    • About
    • Team
    • Careers

    Support

    • How it works
    • Trust & Safety
    • Help Centre

    Discover

    • GuidesStoriesNews

    Resources

    • Customer Stories
    • Business Cost Calculator
    • Startup Cities

    Browse

    • Freelance Services
    • Freelance Services By Country
    • Freelance Skills
    • Terms
    • Privacy
    • Sitemap
    • Company Details
    • © 2022 People Per Hour Ltd
    We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
    Cookie Settings
    Accept All Cookies