Kapalı

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.

Beceriler: Excel, Visual Basic

Daha fazlasını gör: 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

İşveren Hakkında:
( 0 değerlendirme ) Herzelia, Israel

Proje NO: #18951036

Bu iş için 28 freelancer ortalamada $129 teklif veriyor

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 ( Daha Fazla

$150 USD in 0 gün içinde
(681 Değerlendirme)
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 gün içinde
(835 Değerlendirme)
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. Daha Fazla

$220 USD in 3 gün içinde
(307 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(193 Değerlendirme)
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 Daha Fazla

$250 USD in 3 gün içinde
(76 Değerlendirme)
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 gün içinde
(302 Değerlendirme)
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 gün içinde
(80 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(75 Değerlendirme)
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 gün içinde
(37 Değerlendirme)
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 Daha Fazla

$150 USD in 3 gün içinde
(75 Değerlendirme)
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 gün içinde
(47 Değerlendirme)
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 Daha Fazla

$144 USD in 3 gün içinde
(45 Değerlendirme)
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 Daha Fazla

$90 USD in 3 gün içinde
(69 Değerlendirme)
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] Daha Fazla

$100 USD in 2 gün içinde
(84 Değerlendirme)
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 Daha Fazla

$95 USD in 3 gün içinde
(25 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(57 Değerlendirme)
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 gün içinde
(21 Değerlendirme)
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 Daha Fazla

$100 USD in 2 gün içinde
(22 Değerlendirme)
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 gün içinde
(1 Yorum)
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 Daha Fazla

$100 USD in 4 gün içinde
(6 Değerlendirme)
2.4