View Single Post
 
Old 01-11-2022, 03:31 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

In my experience it is best to minimise the number of docs involved so I'm not sure why step 4 is needed if you are just going to send it immediately to Excel - just cut out that middleman.

In terms of #3, my suggestion is to add a TOC in the merged doc to collect all the instances of the Title style into a list which can then get extracted to Excel. The TOC field code of {TOC \t "Title,1" \n} will give you a nice list to extract for this purpose.

You should try to get away from searching on a large number of font properties because styles are a much better way to work.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote