Month: August 2014

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

Mail merge in Outlook 2007

As you may know, the famous Mail Merge Outlook function that Microsoft introduced more than a decade ago has endured almost every iteration of the Microsoft Office family. Today, we are going to describe its use in Microsoft Office 2007.

Mail Merge in Outlook 2007 works the same as in other Microsoft Office family releases and targets the same goal: the creation of convenient and efficient mass mailings with some degree of personalization while drastically improving the work process for the people in the field. It allows creation of bulk email letters to each individual on a mailing list, using a single message / Word document / Publisher item, by employing “Macros”, which serve as placeholders for data taken from an external “data-source” and are replaced by the actual values when the messages are generated.

Continue reading

How to clean duplicate messages out of the mailbox even if they are not really duplicates

The reasons for duplicated messages appearing in Outlook mailbox vary. They can be caused by incorrect functioning or configuration of the main synchronization software; problems with mail server or mail client (for example, if the message copies are left on the server and you have to re-create an account in Outlook); or just by human error when doing a copy-paste of a number of selected messages; etc. Any of these events can leave you with numerous duplicates and you will want to eliminate them. This task is easy, just take Duplicate Email Remover and rid all your mail folders from duplicated messages and posts even if the source message and duplicate are located in different folders.

Continue reading