excel spreadsheets as a source for mail merging

Mail merge from Excel spreadsheet data

Have you ever had to send out similar messages to a substantial number of recipients with just a few slight alterations in the body and the subject of the message? Have you ever had to deploy a personalized marketing campaign or send special offers to your most loyal customers so that any of them would feel truly special? Then you might have probably made use of the mail merge technology, or, at least have heard of it. In a nutshell, mail merge works as an inverse template or, rather, super-template, when, instead of using the same template to create similar messages over and over again, a user creates just one template with a number of placeholders which propagates itself across all the messages adding specific values for each recipient from a pre-set database, such as the recipient’s email address, first name, date, price, city or position.

Continue reading