Find Jobs
Hire Freelancers

Excel Data Extraction & Automated Emailing

$15-25 USD / hour

In Progress
Posted about 2 months ago

$15-25 USD / hour

I require a freelancer who has expertise in working with Excel data and automated emailing. This is what I need: - Extract specific columns only from an existing Excel file. - Create multiple new Excel files from this data. - These files must be organized according to a format I will provide in a template. - Attach these newly created Excel files to an Outlook email. - Draft the email with text I will provide. - Automate the sending of this email. The freelancer should ideally have advanced Excel skills, including familiarity with data extraction and manipulation. Experience with email automation, preferably in Outlook, is also required. A high level of attention to detail will be crucial to structure the data according to my provided template. Good English communication skills required to draft the email content.
Project ID: 37928111

About the project

50 proposals
Remote project
Active 28 days ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello. I am a Microsoft certified Excel professional. I can automate this process for you. But I think it will be easier using python too. I am happy to discuss both the scenarios. Could you please tell me if you will be uploading these “existing excel files” on daily basis. Best, Aisha
$20 USD in 40 days
5.0 (315 reviews)
8.6
8.6
50 freelancers are bidding on average $24 USD/hour for this job
User Avatar
As an experienced full-stack developer with a specialization in Excel, Excel Macros, and Visual Basic, I'm confident that I'm the ideal candidate for your data extraction and automated emailing project. Over my 7-year career, I've worked extensively with top-notch companies like Metlife GOSC, DXC technologies, and Elite Services delivering solutions around data analytics and automation. My proficient command over Excel Formulas, VBA, Macros, along with data scraping and crawling expertise will enable me to swiftly extract specific columns from your existing Excel files and organize the data just the way you need in multiple new files using your provided template. Additionally, my experience extends to working with Microsoft Outlook for automating various tasks. I can not only attach the restructured Excel files but also draft emails based on the content you provide, ensuring prompt delivery. Whether it's about scripting a code for automation or crafting an email that strikes the perfect tone, attention to detail has been my guiding principle throughout. And finally, communication! My good command over English will come in handy while drafting email content as per your requirements.
$20 USD in 40 days
4.9 (569 reviews)
8.5
8.5
User Avatar
Hi, my name is Selim. I am the Director of ANC, registered in the UK. I read your "Excel Data Extraction & Automated Emailing" project descriptions carefully before bidding. I got what you need and keen to discuss project details when you are available... I am 5-star excel and vba coding expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my work. I had many similar excel tasks, including automated data extraction, aggregation and reporting, all achieved with 5/5 rating. Kindly get back to me if you wish to proceed with a top-rated and reliable partner here...pls note that I only deliver best quality at a reasonable price, and I am open for longterm partnerships, if you wish too... I bid my best for you to start business, and I am ready to prepare an excel workbook template for you to check & validate, once you give me a reply... Kind Regards, Selim
$25 USD in 40 days
5.0 (304 reviews)
8.2
8.2
User Avatar
Hi there! As I have read, I see you need help and I could help you! I'm a professional Database Administrator and Analytics Engineer with more than 10 years of experience and more than 300 projects done here on this platform. I offer unlimited revisions and I don't require any payment in front. I always meet delivery deadlines working until I get the desired results. I know all the most used softwares to do this project specifically, I could even give you some other options in case you think is better to use other tools. Send me a message so I can show you my previous work and we can discuss more. Best regards, Giovanni. ""
$15 USD in 40 days
4.9 (60 reviews)
7.0
7.0
User Avatar
Hi, I am here for your Assistance in MS Excel and Google Sheet with 4 year professional experience and knowledge of advance excel which will give your spreadsheets an organized and professional data view. Includes: Spreadsheet Google Sheet MS Excel Dashboard Automation Graphs & Charts Formula & Tools Data Analysis Pivot Tables Macro & VBA Financial Budgeting Data Validation Web Scrapping Investment Calculators Conditional Formatting VLOOKUP and HLOOKUP Excel Data Entry
$20 USD in 40 days
5.0 (18 reviews)
5.8
5.8
User Avatar
Good day, I have read initial high level requirements of your project & discussed with my technical team lead too. I was wondering, if you can please spare few minutes to discuss requirements thru' chat? I can then also ask few questions to clear the scope of work and after that it would be easy for me to give you our firm bid. For quick response & one-on-one communication, you may click on the chat button, as I am online most of the time. Look forward to hearing from you. Regards, Yasir LEADconcept
$20 USD in 40 days
4.9 (3 reviews)
5.9
5.9
User Avatar
Hi, I have gone through the Job details and am interested in taking it up. I need you to share more details with me, and I will deliver the required tasks fast and accurately. I’m Ahmed Hassanein. I’ve been working with MS Office since the 90’s as a user, developer, and trainer. I've been using formulas, VBA, and macros in Excel since 2004. I completed Excel VBA and Google Sheets Apps Script jobs for happy customers (check my job reviews). I have over 25 years of experience supporting systems and users in the information technology field such as office applications, domain servers, application servers, network security, information systems audit, etc. I would be happy if we connect to talk more about your Job and discuss how I can help you accomplish it. Thank you and kind regards, Ahmed Hassanein
$25 USD in 40 days
5.0 (46 reviews)
5.5
5.5
User Avatar
I'll start by extracting specific columns from your Excel file and organizing them into new files using a provided template. Then, I'll attach these files to an Outlook email, draft the email with your text, and automate its sending. With advanced Excel skills and email automation expertise, I'll ensure precision and efficiency. Let's begin now!
$20 USD in 40 days
4.9 (14 reviews)
5.3
5.3
User Avatar
I can automat organizing/filter/sorting data and sending it through outlook , all of that by Excel VBA (Automation),I ALREADY MADE PROJECT LIKE THAT BEFORE, About me ADVANCE EXCEL , more 7 years experience I am a CERTIFIED Excel VBA Programming , CERTIFIED Business Analytics and Professional Certificate in Excel Accountant i have a MASTER of BUSINESS ADMINISRATION
$20 USD in 40 days
5.0 (30 reviews)
4.9
4.9
User Avatar
Hello, I can help you out with your project. I am a VBA Developer with extensive experience in task automation in Excel and Outlook, and I can quickly and easily deliver the results you need. Please feel free to contact me to discuss your project in more detail. Thanks a lot. Best regards, Emilia
$20 USD in 20 days
5.0 (33 reviews)
5.0
5.0
User Avatar
Hello, I just finished very similar project and added email sending. Actually client wanted to recheck data before sending emails, so it is not so automated as it can be. With your Excel-based project at hand, I'm confident my advanced Excel VBA and Visual Basic skills can not only get the job done, but also provide excellent results. I've honed these skills through years of experience automating data extraction, analysis, sorting and filling – all tasks that align perfectly with your needs. One of my unique strengths is being deliberate in developing solutions that yield better results rather than just quick ones. With your data extraction requirements, you can trust me to thoughtfully extract and organize specific columns into new Excel files using a format you provide. My knack for creating effective formulas and macros will also ensure that the data is structured accurately according to your template. Additionally, I have prior experience with email automation which fortifies my capability to automate the generation of emails with the newly created Excel files attached. Being detail-oriented and having good English communication skills, I guarantee my drafts of the emails incorporating your text will be precise and polished. Let's work together on this project to achieve maximum efficiency. Best regards, Remis
$15 USD in 20 days
4.9 (22 reviews)
4.5
4.5
User Avatar
I am an Excel expert with extensive experience in data extraction, manipulation, and automated emailing. I have a proven track record of efficiently handling Excel data and automating email processes. Here's how I can assist you with your requirements: Extract Specific Columns: I will extract the required columns from your existing Excel file using advanced Excel functions and techniques. Create New Excel Files: Utilizing the extracted data, I will create multiple new Excel files following the format provided in your template. Organize Data: Ensuring adherence to your provided format, I will meticulously structure the data in the new Excel files for clarity and coherence. Attach Files to Outlook Email: Using VBA (Visual Basic for Applications) scripting, I will attach the newly created Excel files to an Outlook email. Draft Email Content: Based on the text you provide, I will compose the email content ensuring it aligns with your communication requirements. Automate Email Sending: I will set up an automated process to trigger the sending of the email at specified intervals or events, using Outlook's built-in functionalities or scripting if necessary. With my expertise in Excel and email automation, along with my attention to detail and proficiency in English communication, I am well-equipped to handle your project effectively and deliver results that meet your expectations
$15 USD in 40 days
4.8 (17 reviews)
3.6
3.6
User Avatar
Hello I can extract data from Excel, create new Excel file according to your format and email from Outlook following your all instructions. Let's discuss it in more over the chat. Thanks
$15 USD in 40 days
5.0 (14 reviews)
3.5
3.5
User Avatar
As a seasoned software developer with over 12 years of experience, I've mastered several platforms and created numerous web applications. My proficiency in data management and extraction through Excel is one of my core skills. Additionally, I've crafted more than 20 game products which demand meticulous attention to detail - an attribute I'll bring to properly structure your extracted data into the appropriate format. Given that you require multiple new Excel files to be created from the extracted data, my expertise in handling large datasets, separating columns, and utilizing pre-made templates will prove to be immensely beneficial for this project. I can also automate the creation of these files so that you can save time and effort. Moreover, I have prior experience with email automation using several platforms including Outlook. Having created and managed mobile-friendly applications, I assure you that attaching the newly created Excel files to an Outlook email will be seamlessly executed. Finally, my practical approach revolves around ensuring client satisfaction; hence, I'm open to revising any job until you're completely satisfied. Signal strength isn't measured by technology but the prowess it impartsbersome to attain good communication skills. Let's communicate all aspects of the job professionally!
$25 USD in 40 days
5.0 (3 reviews)
2.9
2.9
User Avatar
With my extensive expertise in Excel, including advanced functions and proficiency in VBA programming, I am well-equipped to handle your project's need for data extraction and manipulation. My precise attention to detail ensures that I will efficiently organize the extracted data into multiple new Excel files, as per your template format. My ability to troubleshoot errors means I can ensure the accuracy of these files so they're ready to be attached to the automated emails. Speaking of which, my experience extends to Outlook automation using macros, so you can rest assured that not only will the created files be attached seamlessly, but the emails will also be sent automatically with zero hassle. To make this process even smoother, my strong communication skills will enable me to draft informative email text according to your requirements. My content creation background complements this project as well. My focus on clarity and audience engagement will help draft Emails that effectively communicate your message. Moreover, my familiarity with SEO practices means that the emails I draft can incorporate any relevant keywords that may maximize its reach and impact. In conclusion, with my comprehensive skill set in excel, automation, and content creation paired with a steadfast commitment to delivering superior-quality work on time -- I believe I am the ideal candidate for your project!
$20 USD in 40 days
5.0 (3 reviews)
2.5
2.5
User Avatar
Hello, I am writing to express my interest in the position requiring expertise in Excel data extraction and automated emailing. With advanced skills in Excel, including data manipulation and extraction, coupled with experience in email automation, I am confident in my ability to fulfill your requirements efficiently and accurately. Here's a brief outline of how I propose to handle the tasks: 1. Extract specific columns from the existing Excel file. 2. Organize the extracted data into multiple new Excel files, adhering to the provided template format. 3. Attach the newly created Excel files to an Outlook email. 4. Draft the email using the text provided and send it out automatically. I am well-versed in structuring data according to predefined templates and ensuring a high level of accuracy and attention to detail throughout the process. Moreover, my proficiency in English will enable me to draft clear and concise email content. I am eager to contribute my skills to your project and am available to discuss further details at your earliest convenience. Thank you for considering my proposal. Best regards, Leads Lab
$20 USD in 40 days
5.0 (4 reviews)
2.1
2.1
User Avatar
As a dedicated IT strategist with a broad background in web development, my skills extend far beyond front and back end technologies. I've spent years honing my Excel skills specifically in data extraction and manipulation - two absolute essentials for this project. From your description, it's clear that you need someone who is not just proficient with Excel, but also someone who can meticulously organize and structure the data according to your specific template - and that's exactly what I can deliver. In addition to my Excel prowess, I have extensive experience in email automation – particularly with Outlook. Creating multiple new Excel files from specific columns of existing data and automating the entire emailing process will be second nature to me. Despite the inherent technicality of these tasks, I bring a creative edge that allows me to develop unique and tailored solutions to exceed client expectations. Finally, our collaboration on this project won't be hindered by language barriers or ineffective communication. My English proficiency ensures clear understanding of your vision and exceeds clarity when drafting the email content. If you're looking for an experienced professional who can leverage advanced Excel skills alongside Outlook automation for efficient data handling tasks while expertly delivering your message through emails, I'm the ideal fit for your project. Connect with me to bring your project to fruition!
$20 USD in 40 days
5.0 (1 review)
1.8
1.8
User Avatar
Hi, I have read the requirement and understood. My Profile: 13+ years of experience with with different SP versions -SP Online/2019/2016/2013/2010 3+ years of experience with power platform Power automate, PowerApps. worked for Sharepoint migration from on-premise to online using sharegate and microsoft tool. worked with power automate desktop for scraping data and excel automation. Worked with Nintex Forms and flows Experience with SPFx, ReactJS, JavaScript, jQuery, Typescript, REST Apis, Webhooks etc. Looking forward for your response. Regards, Chandrashekhar
$25 USD in 30 days
5.0 (3 reviews)
1.6
1.6
User Avatar
Hello, I am Abhishek Gupta. As a ⭐ ⭐ ⭐ ⭐ ⭐ highly skilled Developer, I bring to the table a broad and adaptive skill set that translates seamlessly into the demands of your project. My advanced Excel mastery and knowledge of Excel Macros, as well as my extensive experience with Visual Basic, make me well-equipped for tasks such as data extraction and manipulation. Moreover, my capacity to align my work with differing platforms stretches to Outlook automation. I possess hands-on expertise in organizing emails and attaching necessary files with automated flair. In line with your requirement, I am well-versed in crafting personalized emails keeping the perspective of clients in mind. Your desired draft message will be delivered gracefully to the target audience. Additionally, I assure you that attention to detail is one of my distinguishing traits - be it decoding intricate codes or structuring data cautiously according to templates – this accuracy is something that gives quality to my work. Finally, besides being proficient in English communication for drafting your email content, I pride myself on effective collaborative skills and ensure regular communication during projects in order to deliver high-quality service that meets your expectations. In short, choosing me for this data-driven task will not only result in proficient execution but also bring an innovative touch that can streamline your future ventures.
$20 USD in 40 days
5.0 (1 review)
1.0
1.0
User Avatar
With over 7 years of experience under my belt, and holding a degree in Industrial Statistics and Mathematical Finance, I’m confident that I have the exact expertise you need for your project. My skills in Excel range from automating Excel reports with VBA/Power Query to designing customized Excel macros. I strongly believe in the power of visualization, which is why my designs are always visually appealing and functional. Coming to the specific requirements of your project, data extraction and manipulation sits at the core of my specialties. I can extract desired columns from your existing Excel file, create new files organized according to your template, and attach these files in Outlook email – all within a tight structure that your project demands.I'm also highly proficient in using VBA as well as excel Macros to perform tasks at scale, ensuring both quality. By choosing me for your project, you're not just investing in an accomplished freelancer but someone who seeks toenhance user experience with technical excellence. So, let's get started!
$20 USD in 40 days
4.3 (3 reviews)
0.9
0.9
User Avatar
Hi, ------SCRAPING, AUTOMATION EXPERT------- Please check my portfolio, I have scraped and created automation script for tons of websites. Excel, Excel Macros and Visual Basic are my core skills. I am always ready and you will get the best result you ever have.
$50 USD in 35 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Gaithersburg, United States
0.0
0
Payment method verified
Member since Mar 27, 2024

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.