Programming in MS Word

It is interesting to know that we can do some programming in Word. You can get more information in below link:
http://word.tips.net/T001045_Using_Last-page_Headers_and_Footers.html

I ave executed below example:

Hope it helps.

Real-time HTML editor

Real-time HTML editor:

http://htmledit.squarefree.com/

General Tips - Fix Drive letter for your External Hard Disk

When we connect external hard disk, it will be given with next available alphabet. It is quite often that the alphabet will be changed. We have to map the shortcuts/PST files every time the alphabet is changed.

To fix this, we can fix alphabet for a hard disk. Choose an alphabet way out in disk alphabets. With this what ever the USB port we connect the drive, the same alphabet will be assigned. Below are the steps for the same.

1. Go to Disk Management: Right click on My Computer, select Manage, on left panel select Disk Management. (Or Run command: diskmgmt.msc)
2. Right click the device and select Change Device Letter and Paths. Click Button: Change and assign an alphabet way out in the Disk Drives Alphabets (I have chosen K).

Hope this helps.
For Some more tips on external hard disk follow URL: http://lifehacker.com/5624331/top-10-external-hard-drive-tricks

Compareit - Powerful tool to compare files

Compareit is very powerful tool to compare data. Its free and can download it from internet. Some of the links where we can download it form are given below.

http://www.grigsoft.com/wincmp3.htm
http://download.cnet.com/Compare-It/3000-2248_4-10832602.html

MailMerge - Simple reporting in MS Office

We can use MS Office feature called MailMerge to generate simple reports. We can prepare template in Word, link data from Excel sheet. Follow below links for the procedure.

http://office.microsoft.com/en-us/word-help/CH010062628.aspx
http://mistupid.com/technical/mailmerge/

Trick to remove Blank lines in Text

1. copy the content to MS Word

2. Find: ^p^p

Replace: ^p

FYI: If we have complex blank lines the below procedure can help

There may be spaces and tabs that interfere with a normal ^p^p find/replace operation. If tabs and double spaces are not required by the other entries, I suggest this:

Find: ^t

Replace: (space)

Find: (space)(space)

Replace: (space)

(and do this until the find count is 0; remember to save the document every time)

Find: ^l

Replace: ^p

Find: ^p(space)

Replace: ^p

(do this until the find count is 0)

Find: (space)^p

Replace: ^p

(do this until the find count is 0)

Find: ^p^p

Replace: ^p

(do this until you're happy with the result)

Source: http://www.proz.com/forum/office_applications/114649-how_to_remove_empty_lines_in_ms_word_document.html

Change the file name

Refer the below link:

http://www.labnol.org/software/tutorials/rename-multiple-files-bulk-excel-googl-docs/2481/

Please note that this can be used only for the filenames without space in it.

SQL Developer - F8 SQL History

F8 is the keyboard shortcut to get History of SQL Statements executed.

Google Account Tracker

Google, gmail, orkut ....... these are the websites I open more than once in a day. There are many google hosted online products like Blog, Google Docs, picasa, youtube uses same login details as gmail. What can you do if you doubt someone else is also using your details? Some of my friends google account is being hacked and their orkut account is filled with junk photos and comments. Spam mails being triggered from their mail IDs for which they will apologize afterwards.

I came to see an option in gmail with which you we can know our past 10 visits to our account with IP address and location information. We will have an option to signout of all the other sessions and change password. Below pictures will show how we can use the option. Click on the image to view it clearly.

The following link helps to find location of a given IP address: http://www.ip2location.com/free.asp

Have a safe browsing.