Find Jobs
Hire Freelancers

Use VBA in Excel to automate emailing based on data in the Excel document

$250-750 USD

Completed
Posted over 8 years ago

$250-750 USD

Paid on delivery
We use Excel as a project managing tool. We would like to email our customers based on the data that is in our Excel document. Each customer has their own row. So we will enter the customer's email address into our Excel document, along with all of their data, and when we run the script we need Excel to open up a separate email for each row and enter the appropriate information from our document into the "To", "CC", "Subject" and "Body" fields. In the attached documents you can see an example of what the Excel sheet may look like and what the email will end up looking like. Everything in the email must automatically be entered, so that once we run the script an email will open up for EACH project and we just hit "Send" on each email. Also, IF you can have Mozilla Thunderbird automatically change the "Identity" before sending the message that would be helpful. Otherwise we will need to manually change the identity for every email message which is very time consuming.
Project ID: 8844732

About the project

30 proposals
Remote project
Active 9 yrs 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'm a developer with over 5 years of experience. I work for Pratt and Whitney Canada where i'm responsible for process automation with tools like Access and Excel. I have extensive knowledge regarding C#, VBA, ABAP and T-SQL language i'm also proficient with databases like SQL server, Access and My Sql. If you find this offer interesting please contact me or if you want i could prepare a short presentation for you of what can i offer you regarding this project You could see example of my work here : [login to view URL] (Those are presentations for my other clients but should give you perspective what can i do.) Hope to hear from you. Best Regards Lukasz Ozóg
$250 USD in 3 days
5.0 (30 reviews)
6.9
6.9
30 freelancers are bidding on average $319 USD for this job
User Avatar
A proposal has not yet been provided
$300 USD in 3 days
4.9 (254 reviews)
7.6
7.6
User Avatar
Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel :) and i can do make VBA macro to automate emai lin based on data in excel documnet :) please give me a chance for doing your job and im able to start doing your job right now :) Thank You Sincerely Prameswara
$250 USD in 1 day
4.9 (310 reviews)
6.9
6.9
User Avatar
Hi: I have done several similar projects in the past. Please also note that I have 100% completion rate and 5-star feedback on projects. More than 90% of my projects are related to Excel and VBA programming. Please connect with me to discuss more
$250 USD in 2 days
4.9 (156 reviews)
6.9
6.9
User Avatar
Hello Sr., how are you ? Jorge is my name and I have experience doing programs using VBA and other tools I'd like to offer you a script, to run freely in your computer which one will interacts with your Main Excel Document and also, with your Email Client tool. The tool I'm talking is called WinAutomation and is a powerfull tool, Windows compatible which permits you to automate almost anything there. If you are interested to take 10 minutes of your valuable time, I could explain you better. Also the best way to automate this is working directly on your computer, to interact directly with the Excel and the Email Client software (because I don't have it installed and configured as you there). The final product I'm offering you is an EXE standard app, Windows compatible. You can visit my Portfolio to know my last jobs regarding these skills, the reviews received from clients and as you can see, a higher percentage of jobs completed. i'm interested to help you on this particular project. What I prefer is to discuss with you more in detail all your terms and I'll give you a better proposal. No more Sr.; contact me if you'd like it and I will do the best, Regards. Jorge. P.S.: I will not accept any award before to discuss with you all the details needed.
$350 USD in 3 days
5.0 (155 reviews)
6.9
6.9
User Avatar
Dear, we are Team of French + US. I checked your project description, and I confirm I can develop email automation. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
$250 USD in 4 days
4.7 (61 reviews)
7.1
7.1
User Avatar
Dear client, I can accomplish the job for you. I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me for further details. Thanks and regards Roy
$250 USD in 3 days
4.9 (255 reviews)
6.5
6.5
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$250 USD in 8 days
4.9 (144 reviews)
6.7
6.7
User Avatar
I have versatile experiences about to do the online research, excel data analysis work. Please find below my overview: I am very much interested and have experience to do this work. Extensive Excel and pivot table development experience Excellent familiarity with all Microsoft Office applications Strong skills in maintaining accurate Excel spreadsheets High ability to meet strict project deadlines Exceptional proficiency with Build Scripts, macros, Excel add-ins and mail merges I am looking forward to discuss further if necessary for this position with you. Sincerely,
$250 USD in 10 days
4.9 (123 reviews)
6.2
6.2
User Avatar
Hello I can get you this task done using VBA programming in the next 24 to 48 hours. Do let me know if you are interested. I have done plenty of projects related to this here in freelancer. Please checkout my profile for recent projects and review. Thanks
$250 USD in 1 day
5.0 (98 reviews)
6.0
6.0
User Avatar
A proposal has not yet been provided
$500 USD in 20 days
5.0 (3 reviews)
6.2
6.2
User Avatar
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 50 projects, almost 45+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
$250 USD in 1 day
4.8 (73 reviews)
5.8
5.8
User Avatar
Hello, I am Excel and VBA expert. I did a similar project with Microsoft Outlook. I think I could do well with Mozilla Thunderbird. I can see over at the weekend and let you know. Best regards Jan
$555 USD in 10 days
5.0 (64 reviews)
5.7
5.7
User Avatar
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will deliver flawless work. I am very much able to work on this. ***I am ready to start Waiting for further discussion.. with thanks and regards
$277 USD in 4 days
4.6 (45 reviews)
5.6
5.6
User Avatar
Hi Im an expert in .Net technologies with iver than 20 years of experience in banking sw development. Have u an SMTP server? if so i can build a simple c # app tio send the emailing Regards Carlos
$555 USD in 3 days
4.8 (30 reviews)
4.9
4.9
User Avatar
Hi, Please give me a chance to make your work done in time accordingly as desired. Besides this my expertise in MS Office, Presentations, Data Entries, Designing, PDF document, Google Spreadsheet, VBA, Macros and Typing. Your kind response is being awaited.
$337 USD in 5 days
4.9 (30 reviews)
4.5
4.5
User Avatar
Hi, I have completed a project that sends mail to the agents for their commissions . I can do what you want. I can do what you want using Excel and Outlook. If Thunderbird is mandatory please let me know, so that I can check whether I can do it with Thunderbird. Regards
$250 USD in 10 days
5.0 (21 reviews)
4.4
4.4
User Avatar
Hello, I'm an expert in VBA and VB.NET with almost 10 years of experience. For my previous job I have written a similar macro to create an outlook email message and automatically fill in the To, CC, Subject, Body, Attachments from the data in an excel file. I still have the code of the macro somewhere, so I can quickly supply you this functionality. I would suggest I create a new Excel file containing the macro. In this excel file you specify the file containing all the data, and maybe which columns contain which data. And by hitting a button all the mails will be created. I don't have the code to change the identity. Because of this I would lower my bid with 50 $, but I'm not able to give in a bid lower than 250$. So my bid is 200$ Regards Wesley
$250 USD in 2 days
5.0 (9 reviews)
3.9
3.9
User Avatar
Hi, I've got 10 years experience developing VBA macros in Excel for companies like Microsoft, lululemon and large banking clients. I've looked into your requirements and can confirm I can create the required emails from the spreadsheet provided. My proposal included: -Creating thunderbird emails for each row in the sheet. -Validating details in the sheet and reporting errors (e.g invalid email address) -Setting the identity field In relation to the identity field, Thunderbird automation can only use the identity ID from what I can see - I'd need to work with you to identify the ID which holds the email address you want to use - otherwise I can't see any issues making that work. I'm happy to answer any questions you might have about my ability to complete this peice of work. Thanks, Adam
$250 USD in 3 days
4.7 (4 reviews)
3.2
3.2
User Avatar
A proposal has not yet been provided
$333 USD in 10 days
5.0 (3 reviews)
2.4
2.4
User Avatar
Hello. I'm understand how to do this job. Skills in VBA, experiance of working in excel, access two years. Good luck and succeed in this project.
$250 USD in 10 days
4.3 (5 reviews)
2.8
2.8

About the client

Flag of UNITED STATES
Grand Prairie, United States
5.0
7
Payment method verified
Member since Mar 31, 2015

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.