Summary: I need you to move 75,000 email addresses into my online autoresponder.
I have an Excel file containing a list of many companies, sorted into more than 100 business categories. For example:
Accounting and bookkeeping: 3,594 companies
Advertising agencies 728 companies
Architects 1,361 companies
I need you to:
1. create 100 new excel files, each named as a business category (eg 'architects').
2. select the email addresses in the relevant business category in the original excel file, and copy them into the new file. Note that I only want the email address, not the company name etc. So only one column needs copying into the new file.
2. create 100 autoresponders (one for each business category, eg 'architects') in my online autoresponder program
3. Then import each new file into the respective category of the program, using the Import function.
I've attached screenshots of:
- the original excel file, showing around 20 Abrasive Suppliers (one of the categories)
- creating an autoresponder in my program (there are five fields to complete, with an email address and the name of the autoresponder)
- importing a file into the autoresponder
You will need to do two files as a test, for me to check, before completing the work.
I will pay a deposit for this work.
Hi, I am hardworking and reliable with good organization and keep constant communication. I have attention for detail and double check my work. I have knowledge in excel and have reviewed your description of the job. I look forward to being your virtual assistant.