Closed

Convert Sales order in Excel to Automatic Email

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.

Skills: Excel, Visual Basic

See more: extract data from gmail to excel, extract data from email body to excel, extract data from email to google spreadsheet, automated order processing software, import data from email attachment to excel, parse gmail to google sheets, free email parser, extract data from email to spreadsheet, send automatic email costumers order oscommerce, send automatic email excel, outlook send automatic email excel database, automatic email excel using outlook, excel sheet automatic email outlook, visual basic automatic email excel, automatic email excel report, excel automatic email, add custom field sales order table magento, send automatic email excel php, php convert sales order invoice, vtiger convert sales order invoice

About the Employer:
( 0 reviews ) Herzelia, Israel

Project ID: #18951036

28 freelancers are bidding on average $129 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( More

$150 USD in 0 days
(681 Reviews)
8.4
cgullapalli

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
(835 Reviews)
7.9
schoudhary1553

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. More

$220 USD in 3 days
(307 Reviews)
7.8
paris2785

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 a More

$140 USD in 1 day
(193 Reviews)
7.2
dgled

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 s More

$250 USD in 3 days
(76 Reviews)
7.0
TonmoyRoy111

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
(302 Reviews)
6.7
MohsanEijaz

I am interested you project, As I have experience with excel and vba. Please review my profile. Mohsan

$120 USD in 3 days
(80 Reviews)
6.2
chriskerpini

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 c More

$155 USD in 1 day
(75 Reviews)
6.5
branislavm

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
(37 Reviews)
5.9
sloker18

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 t More

$150 USD in 3 days
(75 Reviews)
5.6
lightingdavid

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
(47 Reviews)
5.6
sonarkaushik

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 More

$144 USD in 3 days
(45 Reviews)
5.6
vsprybhanu

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 unde More

$90 USD in 3 days
(69 Reviews)
5.4
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] More

$100 USD in 2 days
(84 Reviews)
5.5
urielbaray

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 sam More

$95 USD in 3 days
(25 Reviews)
4.8
nvchien94

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 a More

$40 USD in 1 day
(57 Reviews)
4.6
webanis

Hi, I am interested in your offer: Excel VBA code. Let me start the work. I will start working immediately Br;

$77 USD in 0 days
(21 Reviews)
4.1
gsanggara

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 More

$100 USD in 2 days
(22 Reviews)
3.8
romanapanovich

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
(1 Review)
3.4
ielucerotrad1

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, Powerpoi More

$100 USD in 4 days
(6 Reviews)
2.4