Excel Spreadsheet email address creator
- or -
Post a project like this4038
£100(approx. $125)
- 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% (171)Projects Completed
165
Freelancers worked with
115
Projects awarded
26%
Last project
22 Apr 2024
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