Hi all
I have a large PDF file (450ish pages) that I can export to Word or Excel. This report has info for approximately 1000 individuals and I would like to be able to split the report into 1000 individual files so I can then email them to those people individually. I just don't know of an easy way to split up the large PDF.
Each new chunk of info start with a unique "word" (YYC_76W_FL). Is there a way to use VBA in Excel or Word to say "copy and paste everything from "YYC_76W_FL" to the last character before the next "YYC_76W_FL" and paste it into a new document and save"?
As always, thanks for your guidance.
I have a large PDF file (450ish pages) that I can export to Word or Excel. This report has info for approximately 1000 individuals and I would like to be able to split the report into 1000 individual files so I can then email them to those people individually. I just don't know of an easy way to split up the large PDF.
Each new chunk of info start with a unique "word" (YYC_76W_FL). Is there a way to use VBA in Excel or Word to say "copy and paste everything from "YYC_76W_FL" to the last character before the next "YYC_76W_FL" and paste it into a new document and save"?
As always, thanks for your guidance.
