It would be helpful if you posted more of the code you're using. It appears you're trying to use code to generate some sort of mailmerge process, but not a very efficiently.
FWIW, it's quite possible for a mailmerge to generate working hyperlinks with both different display text and different hover text.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|