Windows 10: Indexing of MANY names for a cemetery book
Edit: Sorry I didn't notice that Barman58 has already posted the same suggestion.
I probably haven't understood the problem, but I was wondering if a mail merge might help?
- unformatted data is in Excel (or Access), then
- Word has a formatted version of the fields for one person, using Mail Merge fields
- This could include word field codes around the name, so it can appear in Word's index at the end
- Link the word fields to the Excel data fields
- Mail-merge it into a new document and save the document.
- Add the Word index to the end and update it to generate
But I could be getting hold of the wrong end of the stick. (Does that expression work outside the UK? )
Insider Fast Track Office
Excel will work with word as it is part of same family
Yes, thank-you. However, the page numbers will not be update-able as would a Word-generated index.
The index would be word generated, in a word document, the word document would be created from an Excel Spreadsheet, or any other standard DBMS format that word can accept, that is used as a database table for a Merge and contains the actual entries
Let me give mail-merge a try and I'll get back to you ASAP.
This option did not work...
I would suggest you create three sections - The preamble containing the introduction TOC Etc, the data section which would contain the actual data, merged from the database, and a final section that would contain the Index
the important thing here is to wrap the merge codes you require to be included in the index, in Index codes - then do the merge - then the index. You also need to ensure that the merge is set to place each set of merged data fields on a single line not one per page
Barman58 -- The book is layout is complete. Several chapters have yet to be added. The TOC is fully updata-able.
I DO understand the process and have used it with smaller samples with great success.
Now, must I mark every single one of the thousands of records that I want included in the index? Is there a way to "gang-mark" or to use a special "heading" (like with the TOC, but different, of course). I will spend years marking for the index in 25 books containing 110K names.
Hi that's not quite true
You CAN create an embedded Excel document within Word --if the EXCEL file changes then Word will automatically have access to the new data.
This used back in the days of distant past to be called OLE or something -- it was a successor to DDE (Dynamic Data Exchange).
I haven't done this for ages now as I tend to use EXCEL exclusively but it should be easy enough - create a small TEST excel file, embed it a Word doc and test it.
If you need to mess around in WORD you could have a go with VBA (The basic compiler which allows macros etc) but I think EXCEL would be easier.
With all sorts of nice formats available - why do you HAVE to use word. For text of course you can do it the other way around - embed a WORD document in EXCEL.
With Office the possibilities are endless --IMO office is one of the best Ms products ever.
I have an idea!!!
Where can I look at the Word-generated table that is made when marking for the index? I*d I could access that, and copy-paste to it. That might work... Anyone know how to see that file?
Here's a good guide to get started - this should work.
Linking Excel Data Into Word Documents
Source: Official Google Webmaster Central Blog: Mobile-first Indexing
While trying to do a search in outlook 2016, i got the notice "something happened and search cannot be executed" or something like that. A quick google led to the indexing service. I launched services.msc and looked at "Windows Search". It's set to...
So i am having issues with searching for programs and files on my computer. At first i thought it just wasnt finding things on my D: drive(storage). But now ive recently installed origin on to my C: drive and i search for it but it does not find...
I've got a lot of PDF's in my User directory, which according to the Indexing service has been indexed (and it says it's done and has indexed thousands of files). PDF's are set to search file properties only. When I search for any of the PDF's by...
dual boot system 10 on C:, 7 on D:
Search indexing insists on indexing drive D: instead of C: No matter how many times I uncheck indexing locations on D: and choose proper locations on C:, when indexing starts to rebuild it reverts back to D: I...