Run Free E-mail Campaign : Use MS Office

Mail-merge is one of the most useful facilities offered by MS Office. It is the joining together of two sources of information into a single document, usually a list of names and a standard letter/mail to whom a personalized copy of the letter/mail must be sent. This is most commonly done in creating address labels or creating a form letter and most importantly running mail campaign. Only certain details on the mail/letter will change, like having the same mail addressed to a number of different people.

Mail-merge happens with the help of 3 tools i.e. MS Word, MS Excel, MS outlook. Write the body of the mail in word, insert senders list in the form of excel, send mails through outlook. This is the best way to run free mail campaigns.

How to run mail-merge please click here.

How to handle “bounced back” emails or “unsubscribed” emails

Create few rules in your outlook for different mail groups. For Ex, if the subject line contains “unsubscribe” then push all the mails to a new folder named “Unsubscribed”. Similarly the same can be done for bounced back emails.

In case of mail campaigns you can expect at least 7-10% bounced mails. It means if you are running a campaign of 50K mails, then you can have 3k to 5k bounced mails and few subscriptions. Now it’s the tough time to handle to bounced mail IDs and unsubscribed mail IDs.

Now let’s understand how to handle these bulk bounced mails. Outlook provides an option to export all the mails from a particular folder into an excel sheet. We’ll use this to extract the data into the excel sheet.

It’ll export all the details to an excel sheet. The sheet looks somewhat similar to this.

You’ll find the bounced email IDs from this message in the form of

Hi. This is the qmail-send program at

 I’m afraid I wasn’t able to deliver your message to the following addresses.

 This is a permanent error; I’ve given up. Sorry it didn’t work out.

<>: does not like rec


So now our task is to extract only the email IDs so that we can remove these email IDs from out database for our future mail campaigns with more accuracy.

=FIND(“<“,A17) =FIND(“>”,A17) =C17+1 =D17-E17 =MID(A17,E17,F17)

Now your excel sheet will look like this:

Now easily we can remove these emai IDs from our database.




One Reply to “Run Free E-mail Campaign : Use MS Office”

Leave a Reply

Your email address will not be published. Required fields are marked *