RSS

Run Free E-mail Campaign : Use MS Office

03 Jun

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. http://support.microsoft.com/kb/294683

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 yahoo.com.

 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.

<prkbhup.hr@gmail.com>:

 74.125.127.27 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) prkbhup.hr@gmail.com

Now your excel sheet will look like this:

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

 

 

 

Advertisements
 
1 Comment

Posted by on June 3, 2012 in Miscellaneous, My Home

 

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: