Find Jobs
Hire Freelancers

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

$250-750 USD

Teljesítve
Kiadva ekkor: több mint 8 évvel ezelőtt

$250-750 USD

Teljesítéskor fizetve
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.
Projektazonosító: 8844732

A projektről

30 ajánlat
Távolról teljesíthető projekt
Aktiválva: 9 évvel ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
Neki odaítélve:
Felhasználó avatár
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 napon belül
5,0 (30 értékelés)
6,9
6,9
30 szabadúszó adott átlagosan $319 USD összegű árajánlatot erre a munkára
Felhasználó avatár
A proposal has not yet been provided
$300 USD 3 napon belül
4,9 (254 értékelés)
7,6
7,6
Felhasználó avatár
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 napon belül
4,9 (310 értékelés)
6,9
6,9
Felhasználó avatár
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 napon belül
4,9 (156 értékelés)
6,9
6,9
Felhasználó avatár
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 napon belül
5,0 (155 értékelés)
6,9
6,9
Felhasználó avatár
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 napon belül
4,7 (61 értékelés)
7,1
7,1
Felhasználó avatár
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 napon belül
4,9 (255 értékelés)
6,5
6,5
Felhasználó avatár
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 napon belül
4,9 (144 értékelés)
6,7
6,7
Felhasználó avatár
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 napon belül
4,9 (123 értékelés)
6,2
6,2
Felhasználó avatár
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 napon belül
5,0 (98 értékelés)
6,0
6,0
Felhasználó avatár
A proposal has not yet been provided
$500 USD 20 napon belül
5,0 (3 értékelés)
6,2
6,2
Felhasználó avatár
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 napon belül
4,8 (73 értékelés)
5,8
5,8
Felhasználó avatár
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 napon belül
5,0 (64 értékelés)
5,7
5,7
Felhasználó avatár
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 napon belül
4,6 (45 értékelés)
5,6
5,6
Felhasználó avatár
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 napon belül
4,8 (30 értékelés)
4,9
4,9
Felhasználó avatár
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 napon belül
4,9 (30 értékelés)
4,5
4,5
Felhasználó avatár
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 napon belül
5,0 (21 értékelés)
4,4
4,4
Felhasználó avatár
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 napon belül
5,0 (9 értékelés)
3,9
3,9
Felhasználó avatár
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 napon belül
4,7 (4 értékelés)
3,2
3,2
Felhasználó avatár
A proposal has not yet been provided
$333 USD 10 napon belül
5,0 (3 értékelés)
2,4
2,4
Felhasználó avatár
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 napon belül
4,3 (5 értékelés)
2,8
2,8

Az ügyfélről

UNITED STATES zászlója
Grand Prairie, United States
5,0
7
Fizetési mód hitelesítve
Tagság kezdete: márc. 31, 2015

Ügyfél-hitelesítés

Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.