Indexing of MANY names for a cemetery book

Page 3 of 3 FirstFirst 123

  1. Posts : 4,201
    Windows 10 Pro x64 Latest RP
       #21

    Have not constructed a complex report of this nature for a while, but you should create a single line merge in the actual data section in the word document and merge the data from the "database" each entry (person) in the data will occupy one line in the word document

    the important thing is to merge each field from the data individually to the word document the following shows an example (not using actual field or word codes )

    [GivenName] [Index][Surname][/index] [Burial Date] ... .... ....
    [GivenName] [Index][Surname][/index] [Burial Date] ... .... ....
    [GivenName] [Index][Surname][/index] [Burial Date] ... .... ....

    This will create a list containing data, when the "merge is" run, and an index containing the surname and the page it occurs on when an index operation is run

    These would be updated if the two operations were performed again at a later time and data had been added or removed
      My Computers


  2. Posts : 13
    Windeow
    Thread Starter
       #22

    Jimbo45 -- I created the Excel file (Tables-Excel File) for a test index using 5 entries. When I changed the pagination by adding one page before the actual text, the page numbers did not change on the embedded Excel SS. There has to be some connection between the text and the SS... what is it?
      My Computer


  3. Posts : 13
    Windeow
    Thread Starter
       #23

    By George, Nigel, I think we've got it going on now! Let me give this a try and I'll get back to you today!
      My Computer


  4. Posts : 13
    Windeow
    Thread Starter
       #24

    Nigel, I can add the code to the SS BEFORE I import the text to the Word document. I think this might just work. The small tests worked perfectly!
      My Computer


  5. Posts : 13
    Windeow
    Thread Starter
       #25

    Well, Nigel, that last option didn't work either. Word will NOT recognize the input code even though it looks and is placed identically as the Word-marked (for index) code. GRRRR!

    { XE " Young, Leila" } is the format in Calibri Body, 12 pt. for the Word-marked entry.

    I have to take a few days off because of a death in the family but will check back in a few and continue work by mid to end of the week.

    Thanks to everyone and keep thinking about this for me, PLEEZ!

    Best, Leila
      My Computer


  6. Posts : 4,201
    Windows 10 Pro x64 Latest RP
       #26

    What version of word are you using - it may be that the required syntax is different dependent on the version,

    If I get a free hour I'll see if I can knock a sample word doc and excel spreadsheet and get it to work and post them up for you to take a look at when you return
      My Computers


  7. Posts : 13
    Windeow
    Thread Starter
       #27

    Using Word 10
    Thanx!
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 20:58.
Find Us




Windows 10 Forums