I need some advice on solving a puzzle.
I have two types of document after processing. Those with the recipient address at the top of the page , and those where the recipient address is at the bottom.
In both documents these addresses are always top or bottom of the page in the same place , but do vary in size in terms of the amount of lines they occupy , and lines of other information above and below them.
For each , I need a reliable way to select and copy just the address in each. I've tried various ways but not found anything to cope with the variant size of the address.
I'm hoping that someone can suggest some VBA to select the address whether it be at the top or the bottom of the document in a reliable way. Perhaps it will need separate macros for each type.
Perhaps selecting between the beginning of the address to the next return on the page where it is at the top , or from the end of the address to the first return above where it is at the bottom.
I'll attach samples of each. Grateful for any advice.
