Spreading Knowledge World Wide....

How to do Mail Merge

Written by @
One day I was working in office, one of my colleague come to me and say, Sir I have to do mail merge. I gone in thinking mode and ask, firstly tell me what is Mail Merge and what do you want to do with Mail Merge. Then I research with my colleague and that is here for you also.

Sometime, we want to send a letter to large number of people. This is very difficult work to write address of each person to each letter. It’s also hectic and also take time. To avoid this, we can use mail merge techniques.

Let me discuss problem firstly, I have to send a letter to 1000 people. I have to write Person name and address at each letter. It is very difficult to write name and address to each letter. To avoid this, Mail Merge techniques firstly comes in mind. 

Suppose we have two file. One is Excel file which contains all the information related to Recipients and other is Microsoft word file which is basically that letter which have to send all recipients. For this I have created two file.

1. Letter and 2. Recipients Details

From recipient’s details, we have to fetch Name and address.

Step for Mail Merging
1. Open your documents (letter) which need to be send 

2. Click on the MAILING Tab, then Select Start Mail Merge. A list of various menu will be displayed. Select Step-by-step mail merge wizard.

3. When you click on this Menu, a window will be appear on right side of documents.

4.Now select – Next: Starting Document. When you select this, another set of instructions will be displayed, in that you have to select – Select Recipients. After this another set of instruction will be displayed. In that instruction click on Browse.
5. A window will appear, now you have to select your target file means from where you want to fetch data.
6. Select your target file. Then Click on Open. After this a pop up window will appear having your target file name, Click on OK button. After pressing OK, another window will appear containing all the information related to the target file so again press 
7. Now this is time to put required data in letter.
8. First Put Cursor, where you want to place the data. Then Select Insert Merge Field. It will display all the column of sheet.

How to increase page views of a website-II

Written by @

Structure of URL: - The URL of page should be easier and friendly. It can be easily understandable.  To display URL containing document name and folder name can confuse the User so URL should not be so long.  URL should contain only such portion which are more important for the user. Because URL also take part into search engine to increase the page view of any website. If URL show many parameters then it can break the link. If URL contains relative information then that will provides whole information about page and its content. It may be remember that URL are displayed in search engine when a user make search for any information. For every type of URL, Googled make crawling but simple URL are very helpful in making crawling by Google.  Always choose URL that is easy for both users and google search engine. Words should be used in URLs so that maximize the linking of URL by users.

Navigation: When a webmaster or blogger apply for Google AdSense, the team of google check every perspective of Blog/Website. Also they mention result. That also depend on the navigation of website or blog.  Navigation play a very important role to find out the content of website. Better the navigation better the performance of website. Navigation is important because its help to visitor to find content quickly. It also help to search engines tells that which content is important.  Navigation should be planed according the home page. If it is possible then just put an internal link to bottom of every post if their posts are interconnected. If there is no page available on website you can display coming soon page if link are available.