Sunday, October 10, 2010

Email Merge thru Thunderbird

This is a tutorial to use the email merge thru Thunderbird 3.1.4 or later (Can be found here http://www.mozillamessaging.com/en-US/thunderbird/ ). I have also used the add-on called 'MailMerge'.

First install the latest ver of Thunderbird & configure the email a/c. (I have not included the instructions here). Then install the add-on found here -> https://addons.mozilla.org/en-US/thunderbird/addon/47144/


'MailMerge' is a Thunderbird extension designed by Alexander Bergmann. The Mail Merge extension is compatible with the latest Thunderbird 3.0.* releases, and is cross-platform. It supports two features, dubbed Mass Mail and Personal Mail.

'Mass Mail' allows you to create a draft email, put your intended recipients in the To:, CC:, and BCC: fields, then automatically split the draft into a set of identical copies with one addressed to each recipient. This is all done without special preparation beforehand; the extension adds a button labeled Mass Mail to the toolbar; you compose your mail as usual, then click on Mass Mail to perform the split.

The 'Personal Mail' feature is far more like a traditional paper mail-merge. You create a message template, with control codes in place of the fields you wish to include, then link the template to a comma-separated-value file (CSV) populated with your intended recipients. The control characters use double braces, and you can define any fields you want — just place their field names in the first line of the CSV. You will probably only use the recipient’s name and email address, so your template might just include {{name}} and {{email_address}}, but you could include other information from your address book in the body of the message if you need to.

Close Thunderbird for now.

Now lets get down to preparing the database containing the fields that you will use in the email that is going to be sent to 'X' number of people. As you will see in the fig. Below I have made columns with the title

'Salutations' which will contain 'Dear', 'Mr', 'Ms', 'Maam', 'Pachi' etc



'Fname' will contain the First Name of the recipient.

'Lname' will contain the Last Name of the recipient.

'EmailID' will contain the Email ID of the recipient.

After giving the column headings save the file as a .CSV file (Comma Seperated Values). Now fill in the details of all the recipients. This file can be opened in Microsoft Office or in OpenOffice. You can add other details if required taking care to give a column name which is indicative of its contents.

Now open Thunderbird click on 'Write' as seen below


In this window as seen below I have specified the column headings enclosed in double braces. For the recipients its {{EmailID}}. ie: In the 'To' type {{EmailID}}When the email is sent the email ids from this column in your database will occupy this space & that is what the recipients will see at his end.

Now you can type out the contents of the email & can be addressed as seen in the figure below, ofcourse you can format it in anyway. Some examples are

Eg 1:

To,

Dear {{Fname}} {{Salutations}} which will appear as

To,

Dear Shailesh Maam to the recipient

Eg 2:

To,

Dear {{Fname}} {{Lname}} which will appear as


To,

Dear Shailesh Parab to the recipient

You can try out any permutation and combination but remember that if you have a column in your database, you can place its contents in your email at a location of your choice.


Now to send the email click on 'File' in the Menu bar (seen below) & then click on 'Personal Mail'



you will get a window which looks like this (see below)


In this window you will have to click on 'Browse' push button to select the file which contains your database. If your database is small then leave other entries as you see them & then click on 'Ok'. But if your database is large I would suggest that you specify the 'Start' & 'Stop' containing the record numbers to limit the output of emails being sent at any given time.

One drawback of this add on, ver 1.3.1 working with Thunderbird ver 3.1.4, is it does not allow embedded pictures to be transmitted. Hopefully this will be rectified in future versions.


Saturday, October 09, 2010

Setup instructions for MyPhoneExplorer for Samsung Galaxy S

Samsung Galaxy S is also called i9000 on the Samsung website http://www.samsung.com/in/consumer/mobile-phone/mobile-phone/touch-phone/GT-I9000HKAINU/index.idx?pagetype=prd_detail&returnurl=

If you start MyPhoneExplorer ver 1.8.0 & click on ‘File’->’Settings’->’Phone with Google Andriod OS’ & then take the mouse pointer to ‘Sample’ next to it you will see that Samsung i9000 is mentioned in it which is the nomenclature for Samsumg Galaxy S. so this phone is compatible with this s/w. Also mentioned here http://www.fjsoft.at/forum/viewtopic.php?t=8965&sid=bd29b3f5949597ab220c86627645474a

You have to remember two things here in this setup

1) If you want to connect via cable or by Bluetooth the settings will be different & you will have to reconfigure separately for each type of connection.

2) If you are connecting thru USB cable AND you happen to connect thru different USB port then your configuration will change & you will have to come to this section of ‘Setting’ to click again on the push button ‘Search for Device’.

Before starting I suggest that backups be made of important data on your phone also remember that 'Andriod' is still 'Work-In-Progress' . :) Now lets get to the setup. Close the s/w & connect the USB cable (or bluetooth dongle) & then start the s/w, you should see some balloons popping up in your task bar, let that process go on.

Click on ‘File’->’Settings’ then click on 'Connection' (seen in the left pane). (See below).

Click on ’Phone with Google Andriod OS’.

‘OBEX packet size’ should be ‘Autodetect’.

Select ‘Write log file’.

Remember that the COM port number & Baud rate number seen in the figure below maybe different from what you see in the s/w on your machine, do not change it.



At this point DO NOT CLICK ON 'Search for Device'. That will be done last when all selections are done. (Page 6)

Now make the selection as seen in the following picture.

Next click on ‘Startup’ in the left pane & the following window will be seen.


Next click on ‘Appearance in the left pane & the following window will be seen. Here you can change the 'Font' & 'First Day of the Week'


Next click on ‘Behaviour' in the left pane & the following window will be seen.


Next click on ‘Sync in the left pane & the following window will be seen.


As seen the picture immediately above 'Only MyPhoneExplorer' is selected, as syncronisation is being inside this s/w itself in case you want to sync with another s/w like MS Outlook, MS Outlook Express, Thunderbird, Windows Live Mail etc (depending on whether any of the above mentioned is installed on your computer), you will have to make the appropiate selection in 'Contacts', 'Calender', 'Notes' seen in picture above. Also the correct 'Sync protocol' should be selected. 'SyncML' is usually the universal standard but you might have to experiment here as the 'User Guide' is silent on this maybe the forum can help !!!

Next click on ‘Multi-Sync in the left pane & the following window will be seen.


Next click on ‘Advanced 1 in the left pane & the following window will be seen.


Next click on ‘Advanced 2 in the left pane & the following window will be seen. Here you can change the location of 'Photo Sync' folder (where photos are stored) & location of your database. Its preferable to keep them on a drive other than C:\ where the computer OS is stored.



After making all the selections as seen in the figures above are done, lets go back to 'Connection' again.


Click on ‘Search for device’. It should usually detect your phone without any problems, IN CASE it does not then you should play around with the ‘COM port’ selection depending on which USB port you have connected to & ‘baud rate’ to get it going. If it still does not, then post your problem on the forum (link given below) to get an answer from the developer.

Hope this helps :)

Forum for this s/w & can be useful in future for further reading about any bugs, shortcomings etc. They can be directly communicated to the developer for remedies.

http://www.fjsoft.at/forum/viewforum.php?f=6&sid=31449d2cff846bbedbf6d47708a2b32b


After this done I suggest you take a 'Backup' by clicking on 'Extras' in the Menu bar & then clicking on 'Create Backup' before exploring any further :)