Find Jobs
Hire Freelancers

Convert Sales order in Excel to Automatic Email

$30-250 USD

Closed
Posted about 5 years ago

$30-250 USD

Paid on delivery
We have a simple sales price list with columns as follows : Category_code, Source : categories sheet first col Part_number , A string containing hyper link Description , A string Category Description, Source : categories sheet based on the category code Price 1 : if part number is empty copy from category sheet : column price 1 price 2 :if part number is empty copy from category sheet : column price 2 price 3 :if part number is empty copy from category sheet : column price 3 Order Quantity : default 0 , if value >0 , multiple price1 or price2 or price3 ( depending on the volumes in categoy sheet ) by Order_quantity into Item_cost Item_cost - result field Comment : text Calculate Sub_total after each change ( Excel) If Sub_total > parameters.Free_Sheepment_minimum_order Shipment_cost is Zero otherwise = parameters.shipment_cost Total Cost = ( Sub_total + shipment_cost) * (100 + parameters.vat_percentage)/100 Near the Total_cost add a button "Make_Order" . The button will create an Excel report containing all the lines with Item_cost > 0 plus all the summary data. This Excel report should be sent automatically to the email address in parameters.send_to email address. The email title should be taken from parameters.send_to_email_title The top part of the price_list sheet must be fixed and include another copy of the "Make_Order" button. The summary part of the price_list sheet must be float and appear all the time at the bottom of the screen even if its in line 5000.
Project ID: 18951036

About the project

27 proposals
Remote project
Active 5 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
27 freelancers are bidding on average $131 USD for this job
User Avatar
Hi, I am good at Excel VBA and sending the email. Looking forward to discuss in the chat. I have referred the attachment. -Chandra
$150 USD in 2 days
5.0 (855 reviews)
7.9
7.9
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$220 USD in 3 days
4.9 (315 reviews)
7.8
7.8
User Avatar
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an application in Excel to retrieve data from Parameters and Categories sheets and send an email. This is a trivial task for me, and I can develop it flawlessly. I'm among the most experienced, and skilled Excel, and VBA developers on this platform. I have completed over 280 projects successfully in six years, and I feel confident in achieving your task as well. You're welcome to visit my page (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I provide to my clients. I will charge you $140 and can deliver within a day (a single milestone to release once you're satisfied with the final result). I'm online from 8 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas
$140 USD in 1 day
4.9 (204 reviews)
7.3
7.3
User Avatar
Shalom, I can suggest to you a module in Microsoft Excel which sends sales order by email (by Microsoft Outlook). The application allows you to open/edit/delete records and shows the documents by filters. There is a search engine with high search capability to find a specific record. During the process, Excel validates the data and prepares reports and documents based on the needed parameters and criteria. There is a report generator which enables you to develop templates independently; username id and password can secure the files About me: I am a financial expert and a guru in Excel and VBA. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. Furthermore, I have experience in accounting, financial reports, consolidating, forecasting, budgeting, costing, cash flow, multi-currency, including collections, payments, inventory, bill of materials, taxation and bank reconciliation.
$250 USD in 3 days
4.9 (79 reviews)
7.0
7.0
User Avatar
Dear client, 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. Roy
$150 USD in 3 days
4.9 (314 reviews)
6.8
6.8
User Avatar
I am interested you project, As I have experience with excel and vba. Please review my profile. Mohsan
$120 USD in 3 days
5.0 (83 reviews)
6.3
6.3
User Avatar
Hello, My name is Chrys. As you can see from my profile, I have 18+ years experience working with Excel/VBA and 14 years teaching them both (all levels). I can certainly do excellent work with your project. Please contact me to further discuss the details. Looking forward to hear from you, Kind regards, Chrys
$155 USD in 1 day
4.9 (75 reviews)
6.5
6.5
User Avatar
Hello! Here is my offer to automate your workbook. I will try to use formulas as much as possible, but for email, I will need to use VBA. Are you using Outlook? Regards, Branislav Mihaljev
$155 USD in 3 days
5.0 (40 reviews)
6.1
6.1
User Avatar
Hello. As a Excel VBA expert, i 'm interest to your project. I hope to work with you. Contact me please. Thank you.
$140 USD in 3 days
4.8 (98 reviews)
5.9
5.9
User Avatar
With respect to this project I would like to present myself as a candidate for your consideration. I am proficient with Microsoft Excel and macro/VBA development. I read your project descriptions carefully. I checked the attached workbook as well… I can write the macro to generate email based on excel content as requested. You’re welcome to checkout my reviews and project completion rate to have some idea about the quality of my previous works, kindly get back to me if you wish to proceed. I am available to start your project immediately. Looking forward to discuss further and work on your project.
$150 USD in 3 days
5.0 (81 reviews)
5.8
5.8
User Avatar
Hello. I am an Excel VBA coder with 4 years + experience. After read tour requirement, I can give you some scripts then U can click 1 button to do all your process. Email will be automatically created in PDF or excel attachment in outlook. Please contact me and we can start soon. Thanks.
$40 USD in 1 day
5.0 (96 reviews)
5.4
5.4
User Avatar
Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some samples for you there. Please send me a message so we can discuss further details of your project
$95 USD in 3 days
5.0 (32 reviews)
5.1
5.1
User Avatar
Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I will create excel vba program to fulfill all requirements. I saw attached files and understood all conditions which you described. I have developed vba program to send email with attachments through Outlook. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start, please message me to discuss your project in more details. Thanks, Virendra
$90 USD in 3 days
4.8 (71 reviews)
5.5
5.5
User Avatar
Sir, I am well versed in these kind of jobs and can do your project as per requirement. I have over 12 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards
$144 USD in 3 days
4.6 (45 reviews)
5.6
5.6
User Avatar
Hi giltenne284, I know advance excel very well and will complete your task soon with high quality in place. I will rebuild your current file into more interactive template with final option to send emaila utomaticaly. Here is my Portfolio link : https://www.freelancer.com/u/gsanggara looking forward to hearing from you. Regards - GS Anggara
$100 USD in 2 days
4.8 (23 reviews)
4.0
4.0
User Avatar
Hi I can develope it on Google Sheet. I recommend to use Google sheet instead of Excel because in future it provide more possibilities to integrate with internet processes etc
$90 USD in 2 days
5.0 (2 reviews)
3.5
3.5
User Avatar
I can do the job! The e-mail will be sent by outlook, is that ok? I'm an engineer with advanced working knowledge and experience in Excel and VBA including interaction between different software (Word, Excel, Powerpoint, Access, Outlook, MS Project, Autocad, pdf, CorelDraw, etc.), web scraping, Access DB design, management Dashboards, stock and financial worksheets, KPI's, proficient coder in VB.Net, C#, Python, JavaScript (google sheets), VB6. I value and honor customer service so I will be available for help, small adjustments, bug fixes even long after the project has been paid for and closed.
$100 USD in 4 days
5.0 (6 reviews)
2.4
2.4
User Avatar
Hi. I have writen excel macros for many years. I am ready to write your project. Thank you for visiting my profile
$35 USD in 1 day
5.0 (5 reviews)
2.3
2.3
User Avatar
Hi - I am Ashish. Thanks for sharing your Data Entry requirement and I will be more than happy to help you. Let me share with you my expertise with Data Entry. I have 8+ Years of experience now and have been doing a lot of Data Entry, Web Search, Excel, Virtual Assistant Jobs. Apart from this I have many clients where I have been served recently. I am also expert in Web App, Wordpress, SEO etc. I can start on your project immediately and let me know if you would like to discuss anything further with me. Thank you for taking the time to read my application. Best Regards,
$100 USD in 3 days
5.0 (1 review)
1.6
1.6
User Avatar
I can do this for you, no trouble. I'm just finishing another MS Office programming project on Freelancer here: https://www.freelancer.com/projects/software-architecture/Database-Report-Application/?w=f . I have years of advanced experience in programming for large North American companies. Regards, Barry OBrien
$130 USD in 3 days
4.8 (2 reviews)
1.2
1.2

About the client

Flag of ISRAEL
Herzelia, Israel
0.0
0
Member since Oct 6, 2017

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.