Find Jobs
Hire Freelancers

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

$250-750 USD

已完成
已发布超过 8 年前

$250-750 USD

货到付款
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.
项目 ID: 8844732

关于此项目

30提案
远程项目
活跃8 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
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 在3天之内
5.0 (30条评论)
6.9
6.9
30威客以平均价$319 USD来参与此工作竞价
用户头像
A proposal has not yet been provided
$300 USD 在3天之内
4.9 (254条评论)
7.6
7.6
用户头像
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 在1天之内
4.9 (310条评论)
6.9
6.9
用户头像
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 在2天之内
4.9 (156条评论)
6.9
6.9
用户头像
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 在3天之内
5.0 (155条评论)
6.9
6.9
用户头像
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 在4天之内
4.7 (61条评论)
7.1
7.1
用户头像
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 在3天之内
4.9 (255条评论)
6.5
6.5
用户头像
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 在8天之内
4.9 (144条评论)
6.7
6.7
用户头像
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 在10天之内
4.9 (123条评论)
6.2
6.2
用户头像
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 在1天之内
5.0 (98条评论)
6.0
6.0
用户头像
A proposal has not yet been provided
$500 USD 在20天之内
5.0 (3条评论)
6.2
6.2
用户头像
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 在1天之内
4.8 (73条评论)
5.8
5.8
用户头像
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 在10天之内
5.0 (64条评论)
5.7
5.7
用户头像
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 在4天之内
4.6 (45条评论)
5.6
5.6
用户头像
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 在3天之内
4.8 (30条评论)
4.9
4.9
用户头像
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 在5天之内
4.9 (30条评论)
4.5
4.5
用户头像
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 在10天之内
5.0 (21条评论)
4.4
4.4
用户头像
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 在2天之内
5.0 (9条评论)
3.9
3.9
用户头像
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 在3天之内
4.7 (4条评论)
3.2
3.2
用户头像
A proposal has not yet been provided
$333 USD 在10天之内
5.0 (3条评论)
2.4
2.4
用户头像
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 在10天之内
4.3 (5条评论)
2.8
2.8

关于客户

UNITED STATES的国旗
Grand Prairie, United States
5.0
7
付款方式已验证
会员自3月 31, 2015起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。