Excel mail merge into Word doc (not as easy as that!).
- or -
Post a project like this- Posted:
- Proposals: 31
- Remote
- #2903544
- PRE-FUNDED
- Expired
Description
UPDATE 13 July 2020: some of you have asked for the Excel spreadsheet we use for the data entry, a PDF copy has been uploaded to this project.
We produce building survey reports with various appendices.
We currently complete the data merge (Excel to Word) and produce individual registers as appendices and introduce them into the final PDF but this knocks out or pagination for the entire Word document. The idea is to produce one report (word doc), the data going into the correct registers and resulting in the correct pagination.
We require one Excel database to merge in Word document, sounds easy but here comes the fun bit... We need to produce four registers within this one Word doc. Data to be positioned in the first three registers depending on certain conditions and the fourth register is a data dump where we have a single A4 page for one line of data where we attach a photo. There are other mail merge fields throughout the document such as the client (name and address), site address etc.
If you are up for a challenge then please respond. We have tried to complete this task so many times in the past 6 months, we've given in and are seeking help!!
Nathan W.
0% (0)New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
can you share the other 2 pages of the registers?
-
you mentioned 4 registers but sent only 2 what do the other two look like? Also an will be a gat help however you can produce sample data in your excel spreadsheet and let bidders play with this before agreeing final bid? I am up for the challenge, this is very interesting to me
-
Hello Nathan, thanks for sharing the PDF version of the Excel workbook as per other requests. However, I requested for an example of completed report through my proposal and you haven't attached that yet. Do you need some NDA signed before you can share the same? Please let me know and if so please share the NDA document through email or set it up on People Per Hour so that I can sign it and then have a look at an example of the final report. Thank you!
Partha Sarathi Bhowmick -
SIR DID YOU MEAN THAT I VE TO CREATE SINGLE EXCEL FILE AND MAIL MERGE IT WITH DOC FILE ON DIFFERENT PAGES
-
Please share a sample.
Nathan W.12 Jul 2020The project has been updated with three PDF's. Cheers.
-
Hello Nathan,
this task sounds interesting. Could you please share the source data and instructions so I can take a look at it before bidding?
Thank you,
PetrNathan W.12 Jul 2020Hey, the pdf of the excel spreadsheet has been added to the project. Cheers.