Find Jobs
Hire Freelancers

Write Macros or visual basic in excel to email excel file

£250-750 GBP

Terminado
Publicado hace alrededor de 7 años

£250-750 GBP

Pagado a la entrega
We currently use mail chimp to email 800 people with an order form. This is returned to us and we use "Template" excel spread sheets to get this into a form that we can upload. The main issue is we do not have the customer number on the spread sheet so we cannot automatically upload it. It also takes us some time to prepare the spread sheet in the first place but this is not the major issue. I want to export I a list of customers and their details. I would like you to develop VBL or similar that will insert the data from that file for one customer (row) into an excel spread sheet and email it to them individually. Ideally we would also be able to change the subject and body of the email (Mail chimp makes it look great, assume it wont be that good but something would be nice). Clearly the better it is the more I would pay. Come up with an ideal solution and I will pay over the budget. Please see the document; Ideal Availability for future with notes for my comments to help [login to view URL] And other documents to explain what I require.
ID del proyecto: 13214344

Información sobre el proyecto

28 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hi, I can suggest you a secured application in Microsoft Excel to manage this process as follows: Preparation of three files (or sheets): a client list, a product catalog (with pictures), a primary database with the orders and it's status (delivered, invoiced, paid, etc.). Excel sends a customized catalog or/and a customized order_form to each customer by email (Microsoft Outlook). Excel adds new order_from's from customers to the primary database. Excel is updated with the status of the orders (open orders, delivery status payments) manually (in user form) or from another system (like SAP or QB). Excel issues status reports regarding the orders. About me: I create all kind of Excel Applications by VBA, formulas, pivot tables, including screen layout's, reports, charts, and dynamic dashboards I am a specialist in financial reports, budget, costing reports, inventories, bill of materials construction models together with extensive knowledge and expertise in Microsoft Excel, Pivot Tables, and Visual Basic Application including preparation of screen layout's, generator reports, dynamic dashboard, and graphs. Throughout my career, I have created dozens of financial modules, business plans, and modules for accounting, budgeting, financial reports, financial plans, and inventories reports for a range of products and services.
£250 GBP en 15 días
4,9 (91 comentarios)
7,2
7,2
28 freelancers están ofertando un promedio de £545 GBP por este trabajo
Avatar del usuario
Hello Sir, My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a sample work before you consider awarding me the project. Thanks, Jay
£550 GBP en 5 días
5,0 (788 comentarios)
8,6
8,6
Avatar del usuario
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
£500 GBP en 5 días
4,9 (367 comentarios)
8,1
8,1
Avatar del usuario
Hi, I am good at Excel, outlook and building useful scripts for my clients. I just checked the description you have provided regarding the project and would be a pleasure to assist you on your project. I will work with full dedication to give you the best output within the desired timeframe. I look forward to hear from you. Looking forward to discuss in the chat. and a long term relationship ahead. Wishing you a great day ahead. https://www.freelancer.com/u/cgullapalli.html#/profile-reviews Regards, Chandra
£750 GBP en 5 días
5,0 (939 comentarios)
8,1
8,1
Avatar del usuario
Hello, I am Excel Expert and VBA Programmer But whats the most important, I am kinda algorithmization expert that means that I work on creating and developing some cool and useful set ups for customers. (Usually demand is on creating spreadsheet to facilitate accounting and similar work)(p.s. actually that just means that I am young and open minded mathematician, nothing more but its cool) Anyways, I have read your requirements and I am not limited at all, I can do everything you have written there, during work, I will have bunch of ideas for you how to make everything better. So, If interested, we can begin developing some cool working files for you Will wait for your response (I mean I will just hope) Thanks & Regards
£611 GBP en 7 días
5,0 (203 comentarios)
8,2
8,2
Avatar del usuario
Hi, I am an Excel VBA coding expert and have done similar projects earlier. Only thing is that MS Outlook should be pre-installed and configured for the default email id from which you wish to send the mails. I am full time freelancer and would be available to take on further enhancements at a later stage. Let me know if you are interested and we can discuss. Regards, Arul
£650 GBP en 5 días
5,0 (202 comentarios)
7,4
7,4
Avatar del usuario
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) 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).
£500 GBP en 7 días
4,9 (267 comentarios)
7,6
7,6
Avatar del usuario
Hello Sr. I'm Jorge from Argentina, a responsible person who have wide experience working building solutions to automate lot of processes and tasks. Would be nice to chat with you and try to understand the whole flow of the process and then, once then, I'll be able to think a solution for that. Is possible that you run a Windows compatible application there ? or do you have Linux environment? Message me please. These kind of processes has been automated: - File(s) handling (copy, paste, edit, delete, create, moving to/from folder) - Automate the use of lots of Windows Desktop applications like MsAccess, MsExcel, Metatrader - Automate the navigation for almost any website (done to scrape content, auto fill forms, auto logins) - And so on...use your imagination. Please, I'm interested to help you on this specific challenge you have in mind, may we could discuss further and agree the workflow to receive the data you are looking for. Also, I'm able to talk about the price for the job completed. Finally, I'll invite you to visit my Portfolio, here, to know me more in deep and see what people says about my jobs. No more Sr., don't hesitate to contact me, I'll be glad to answer you. Have a nice day. Regards. Jorge. P.S.: I will not accept any previous award, before to discuss with you all the details.
£560 GBP en 5 días
5,0 (181 comentarios)
7,2
7,2
Avatar del usuario
Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile. I am ready to discuss and doing the project. Best regards, Eyad
£1.578 GBP en 20 días
5,0 (26 comentarios)
6,9
6,9
Avatar del usuario
Hello, I have seen the attachments and I can develop the required Excel solution using VBA in 3 days. The complete job will be automated on the click of a button. It will automatically pick up the user data from other sheet and append to main sheet. The email shall be sent individually to each customer. Please discuss via chat. Thank you, Usman
£600 GBP en 3 días
5,0 (89 comentarios)
7,0
7,0
Avatar del usuario
I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to complete your project. Just FYI, I own a small engineering consulting business registered in the state of Illinois. You could pay me as an individual freelancer or as a business, whichever suits you better. Please have a look at some Excel projects I've done: https://www.freelancer.com.au/projects/Excel/Calculate-the-semi-deviation-each/ https://www.freelancer.com.au/projects/Excel/Recreate-online-calculator-using-Excel/ https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/
£500 GBP en 5 días
4,8 (187 comentarios)
7,1
7,1
Avatar del usuario
Hi, I have more than 14 years of Excel/VBA exp. Let us discuss more details so that I can estimate cost and time better. I have completed more than 300 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
£500 GBP en 3 días
4,8 (120 comentarios)
6,3
6,3
Avatar del usuario
Greetings for the day!!!! We have done this kind of work in past. We ensure 100% Quality with On-time deliveries. Looking forward to your reply. Thanks And Regards, Team@The24CarrotsInc
£250 GBP en 2 días
4,9 (71 comentarios)
5,8
5,8
Avatar del usuario
I have excellent command on MS Excel. I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance - Built a hotel price comparison system that pulls data using the website's API - Built a complex shift allowance calendar and calculator - Built a complex lookup to sort products into multiple categories You can see the reviews of the same in my profile
£500 GBP en 10 días
4,9 (90 comentarios)
6,0
6,0
Avatar del usuario
ready to discuss further and deliver the project
£555 GBP en 8 días
4,9 (50 comentarios)
6,0
6,0
Avatar del usuario
Hi there! I have read your initial requirements however, I would like to discuss things in detail with you. Our team is stoked to listen you about your business needs and provide you the best possible solution. It’s our team work which lead us to provide excellent services to the client. We need your collaboration to better understand what you exactly require. All we deliver is excellence and you will feel it in our long term relationship. Thanks
£388 GBP en 7 días
4,9 (10 comentarios)
4,7
4,7
Avatar del usuario
Hi. I would like to do your work. Lets discusses and let me Start your work. 100% job satisfaction.....payment after work.
£555 GBP en 10 días
4,5 (20 comentarios)
4,7
4,7
Avatar del usuario
Hi. I am an expert in VBA, VBScript, Visual Basic, C#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now
£750 GBP en 10 días
4,4 (20 comentarios)
3,8
3,8
Avatar del usuario
Hello, I can create a macro that would work step by step as described: - opens a source file with customers and details (file generated by You from Your CRM/ERP) - transforms the data to create a seperate file per customer; each filename receives suffix (customer's ID for example) - creates a new email per each customer, adding individual details to the subject and adding proper file - sends the emails. The trick is to make emails similar to current template. The other VBA can gather attachements from all customers' answers into one master file.
£277 GBP en 4 días
5,0 (1 comentario)
0,7
0,7
Avatar del usuario
Hello, I have read what you exactly need, however I would like to ask you a few questions. I do work smart and do not rest until I get the job done. Please feel free to ping me anytime so we can have a detailed discussion and finalize our budget and timeline. I will deliver in best possible way. Thank you.
£555 GBP en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I'm familiar with mailchimp
£300 GBP en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
Enfield, United Kingdom
5,0
13
Forma de pago verificada
Miembro desde feb 24, 2017

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.