I am trying to create a macro that will do the following and would like any suggestions on how to get started. Maybe more than one macro? using scripts?

I realize that there can be errors but I suspect no more than if I tried to do the same manually.

  1. Use a PDF document as input. This can be large so some how need to divide it into chunks. May also need to be converted to text. The book or documents are located on my computer.

  2. Take each chunk and run through ChatGPT and ask it to analyze and create a list of each individual along with other information about the individual.

  3. Take each of the results of each chunk and combine them.

  4. Summarize the list of all chunks and return a csv file