In this Excel tutorial I walk through how to generate a “pretty” hyperlink that is a mail-merge from Excel cells. This can be very handy when you have, relevant, information for each email that you want to send.
Normally I’d use the offset command (as demonstrated here) and then just select a range however this is the quick/dirty approach. Having said that, it still gives you a good overview of what is needed.
Code used in video to perform email merge in Excel
Use the following for a webpage post: