Hyperlink Problem in Excel

Here is my problem: When I click on a hyperlink which opens up an e-mail, often times the address in the “to” section is different than the one I clicked on.

For instance, I open up an order sheet template. I click on abc@123.com to send that person an email, but when the email opens, xyz@456.com is the address in the “to” field.

Any ideas?