
Excel Spreadsheet email address creator
- or -
Post a project like this4411
£100(approx. $133)
- Posted:
- Proposals: 1
- Remote
- #228945
- Awarded
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.
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.
99% (186)Projects Completed
181
Freelancers worked with
128
Projects awarded
29%
Last project
9 May 2025
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
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