Завершено

Word - create automatic offer from excel - mail merge - makros

Your job will be to set up two demo-files (excel table+word). Do the coding (makros?) in word and show me how it works. So I can insert and adjust the original files.

Merge mail (Excel+Word)

I want to insert data from excel into a word-template. The word-template containing ALL articlenumbers, articletext and different headlines. Thats easy todo, but

1. I want that only the article will be selected (shown) in word when a „1 or more“ in excel colum „amount“ or colum „opt“ is entered. If = 0 then dont show in word at all.

2. When „opt“ is entered, then show articel(text) with single price, but in total the word „optional“

3. Automatic counting in word, we need style like this „10.10“...“10.11“...“10.12“. The first number „10“,„20“,30,40,50 are stored in excel.

4. Insert Name in word from different tab/sheet (same excel file)

5. Insert calculated amounts (cells from excel). I tryed but I get "0"

6. Show different headlines like „A“ if articels are choosen containg „A“ in Artikelnumber

7. We have up to three „Installation places“ so the offer includes three times „all above“

8. It would be cool to have a „button“, bat-file or whatever to call this automatic.

Pls check attached PDF File

Квалификация: Ввод данных, Обработка данных, Excel, Word

Показать больше generate word document from excel macro, excel mail merge without word, vba mail merge from excel to word, populate word document from excel vba, vba mail merge from excel to outlook, macro to populate a mail merge document from excel, auto generate word document from excel, auto populate word document from excel, remove duplicates excel mail merge, create access data base mail merge, excel mail merge word, word excel mail merge layout, create pdf word mail merge, mail merge word 2010 create pdf, vba mail merge excel 2010 word 2010, word vba create mail merge, excel mail merge layout, excel excel mail merge, microsoft excel mail merge, excel mail merge macro

О работодателе:
( 11 отзыв(-а, -ов) ) NoName, Germany

ID проекта: #19782701

Поручен:

Rasel2543

Hello there I am a data entry and excel formula expert. If you want to done your task perfectly and accurately then please contact me. Hope to hear from you. Thanks.

$10 USD за 1 день
(11 отзывов(-а))
3.2

9 фрилансеров(-а) в среднем готовы выполнить эту работу за $22

sparkingboy2010

Hi, I'm an expert in Google AdWords. Understood your all requirements. I have done many projects like this. I will set up and maintain your Google AdWords. Also, I can help you to increase your sales. I'm ready to Больше

$30 USD за 1 день
(219 отзывов(-а))
6.9
musthree

Hi, First of all I can't do this project for $30. I am proposing a price around $500 and deliver in around 3 days or maybe earlier depending on the details. We need to clarify a bit more and would like to have a call f Больше

$30 USD за 3 дней(-я)
(5 отзывов(-а))
2.6
Aishwaryakumari

Dear Client, I am Expert in Excel Macros and I can do this Job. I have excellent experience of Data entry, Web Scrapping,MS Office and Web Research for more than 4 Year’s. Never ends up until you are 100% satisfied wi Больше

$30 USD за 1 день
(10 отзывов(-а))
2.2
xoho88

staff input staff input staff input staff input staff input staff input staff input staff input staff input

$15 USD за 3 дней(-я)
(0 отзывов(-а))
0.0
nityamittra772

Hi, Hope you are fine. I am a Graphic Designer and Photoshop Expert. I have read your job description and understood properly. I am highly interested to do your job. Your satisfaction is my main priority. If you fully Больше

$20 USD за 1 день
(0 отзывов(-а))
0.0
vinodgajula1

Thanks for taking time to read my [login to view URL] are also welcome to review my 5-star upworking profile for more information,and please see my attached samples.I am ready to begin immediately. Больше

$25 USD за 1 день
(0 отзывов(-а))
0.0
channasali245

hello sir i can help you this project and i can work this project. and i can do wod,excel,and power point thanks.

$25 USD за 1 день
(0 отзывов(-а))
0.0
HudaIqbal

Hello,my name is Huda.I am a dedicated and hard working person who believes in honesty and good working [login to view URL] I am new here but I have certain qualities which makes me good at this. I am very skilled in data Больше

$15 USD за 2 дней(-я)
(0 отзывов(-а))
0.0