" trying to extract info using the html formatting tags as your data type indicators "

Yeah those are like the anchors to look for particular areas of data to extract info, since the data is very tricky once i extract the block in the 2nd window in that window i have look for >-Current</i>" in that block of data to look for current phone numbers if not found then go back to 1st window and get another record.

" but your methodology is overly complicated. "

It is, but it get the data out and i can later on cleanup it up more in word.

The raw data file that I attached has the the following output, if there is any way to process this data internally and me without have to constantly keep pressing the hot key to keep the macro going (since the loop breaks) so i have to press the hot key again and get this data that's what i'm looking for.

output data
=========
Citi Bank 1000 Technology Dr, O Fallon, MO 63368 (727) 542-6974
Zuijing Liu -Current
Nillie M Lau 7 Rosebank Pl, Staten Island, NY 10305 (718) 354-5270

Thanks.