Виконано

Advising how to complete a mail merge which uses calculated excel tables

I need help and guidance on how:-

to create 50 Word reports using including data for 50 specific data sets - ‘Locations’. I also need a similar report with the Totals for all 50 Locations.

I have a spreadsheet with 50 rows of data (text and numbers) – one for each Location. So far so good – I can use Mail Merge.

I have some spreadsheets tables which use data unique to each Location and calculates projected Costs over a 10 year period . I want to be able to include this table – unique to each Locatin - into my Word report so that it picks up the whole table of 10+columns and 20+ rows (Cost items). I do not want to manually copy it in Location by location.

I am hoping that I do not need to create 200 columns on my Locations spreadsheets and then create merge names for each field on the table. In fact I will have a couple of this type of table to merge so it would be a laborious work around.

I don’t know how to do this correctly and need advice as Im sure there is a solution

I use Word and Excel. I do not have the luxury of time to learn about databases - though I am happy to learn about more advanced Excel techniques.

Though not essential I would also like to merge images/photos unique to each of the locations in each of the Word reports without manually copying them over.

Навички: Excel, Обробка даних, Word

Деталі: excel data entry mail merge form, excel existing pdf mail merge, mail merge email excel, excel using mail merge sticker print, mail merge nested table excel, excel vba mail merge word document excel macro, mail merge address list excel word, mail merge word from excel, how to mail merge labels from excel to word 2013, how to mail merge labels from excel to word 2016, how to mail merge labels from excel to word 2010, mail merge pictures from excel to word 2016, mail merge labels from excel, macro to populate a mail merge document from excel, how to mail merge labels from excel to word 2007, how to do mail merge labels from excel to word, mail merge pictures from excel to word 2013

Про роботодавця:
( 0 відгуки(-ів) ) Hadlow, United Kingdom

ID Проекту: #24444180

Доручено:

mowachira77

Hi there, I am pro in excel, word, VBA and data processing. Having understood your work, I am available to start and complete your work in one day only. I have previously completed similar task and would like to comple Більше

£15 GBP за 1 день
(16 відгуків(-и))
3.7

8 фрілансерів(-и) у середньому готові виконати цю роботу за £19

sorinacho88

Hello, I have taken a look at the requirements and there are two options: 1. Create a new work document directly from Excel with VBA with all data needed 2. Use a Word template and insert only the required data from Більше

£30 GBP за 1 день
(58 відгуків(и))
5.2
indrapandu

Hi, I'm VBA expert. The mail merge you want have can be done using VBA. I've done similar project before. It would need to create clean excel using VBA then use mail merge to automatically pull the data from it. Please Більше

£23 GBP за 1 день
(44 відгуків(и))
5.0
expertsol3

Hi Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have checked your requirements. We h Більше

£14 GBP за 7 дні(-в)
(0 відгуків(и))
0.0
sonatonmojumdar

Hello, Dear Sir, i understood for your intention. i am start work right now. Please knock me more discuss. Please give me yopur project. I am spreadsheet expart i am create 50 Word reports using including data Більше

£15 GBP за 3 дні(-в)
(0 відгуків(и))
0.0
£18 GBP за 3 дні(-в)
(0 відгуків(и))
0.0
BFB777

I have read your information, I would be happy if I could do whatever you want, and if you give me your information I will be able to transfer your data to a word file within a specified timeframe.

£20 GBP за 3 дні(-в)
(0 відгуків(и))
0.0
onyangojosphat5

I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations.I am very conversant and experienced with Microsoft excel. Relevant Skills and Experience I have experie Більше

£20 GBP за 1 день
(0 відгуків(и))
0.0