I have an Excel spreadsheet containing first name, last name, email address, and username. I would like to send an email to each user in the spreadsheet, but I would like for each email to be customized to the user (Dear Mr. <LASTNAME> and so on).
The body of the email would be the same. Each email would be sent to a different email address and the body would contain a different username and lastname as depicted in the Excel spreadsheet.
Is there a way that I can do this with Outlook 2010?