It worked Thank you!

One final tangential question. I have one other link in the document where the text is not variable and should be the same in every mail merge, but the link changes. I input a hyperlink the regular way, and then replaced everything after the hyperlink with inserting a merge field, and it works while I remain in the document.

However, everytime I reopen the document after closing it, the merge field is no longer a part of the hyperlink, and it only links to the first link throughout all the documents. Any idea why it is not retaining the merge field upon saving, closing, and reopening?

Also, when I closes, the links change so instead of http://www..... they are some how connected with my computer so when I hover over them they say "file:///c:\username\documents\http:.....", and some of them don't even work. When I alt + f9, there are "%20"'s within the links.

Several of the links are to online pdfs (.pdf). Perhaps this is the issue. If so, I would love to know if there is a workaround.

Thanks again!

Cheers!