Andrew,
Thank for your response. I should have made my question more specific however. Here is what I want to achieve:
Say the email is being sent to a set of 50 people. Each individual has a unique lead ID, say staring from user1 to user50. Through the mail merge process I want to send a unique, custom hyperlink to each recepient. For instance,
Hyperlink for User1 -
http://www.yourdomain.com/folder/test.aspx?leadID=user1Hyperlink for User2 -
http://www.yourdomain.com/folder/test.aspx?leadID=user2...
Now, rather than have this URL show up in full, I want specific text in the email to be linked to the unique hyperlink for that user. For our example lets assume that text to be "click here to view your profile".
Using the insert hyperlink process I can insert the SAME hyperlink for all recepients. I see no option on how to include a merge field in the hyperlink.
Please help.