I would like to create an email template using data from an excel spreadsheet. I need to get the email address and a url from the excel spreadsheet. I also need to create a ‘display link’ for the url. The url is 300 chars long and different for each e-mail address. Can I do this using vba in outlook? One additional question, can I record a macro in outlook?