Extract emails from excel database

Everyone know the importance of Email marketing. Sometimes we have a forum with lot of registered members. We usually send an email to them by generating a list but most of the companies does not allow to send 200 or 300 emails at once.

In this case this is the best idea to make list by exporting user table of a VB database to MS EXCEL. here I will assume that you have exported the user table in an MS EXCEL file already. Our main concern will be at the emails column.

1. Insert a blank column to the right of the email column
2. In the empty cell to the right of the first email address, type = and click on the first email address, and press enter. this should cause the first email address to appear in that cell.
3. in the empty cell to the right of the SECOND email address, type in =concatenate( and before you push enter, click on the cell immediately above it that contains the COPY of the first email address, then type ,",", and click on the second email address and press enter.
4. click this cell, then double click the little black box that appears in the lower-right corner. this will auto-fill the formula to the bottom of the sheet.
5. scroll down to the last line and copy!

Now you can use this email list for email marketing. If find any problem. Please ask in comments

Use Adsense Section Targeting

We all know that relevant ads perform well than non relevant ads.  It is normal for a blog to contain lot of irrelevant keywords. For e.g. – if you are writing a post on keyword research and take an example of pet industry in the post.  You’d never want Google to show ads related to dog training on your blog based on that example. Adsense Section targeting solves this problem for you. With Section targeting you can tell Adsense the important sections of your blog based on which Google should show the advertisement

Safer Registry Editing

Safer Registry Editing

Make sure before modifying your system Registry about its backup and you need to know how to organized the registry, how to perform the basic editing, because Registry contains all information how your system runs. This backup will help you to restore Registry in case any problem occurs after modifying. Learn how you can Export and Import Registry File before Editing?

You can backup the whole Registry and only Registry subkeys also.

Click Start Button then type regedit in Run dialog box and click Ok button. Here you can backup the whole Registry or you can locate the required subkeys that contain the information that you want to edit.

Go to File menu option then click on Export option for backup and save it with on any your system drive with .reg extension and you can restore this backup going File menu using import option.

Task Manager running but hidden from view

Task Manager running but hidden from view

If you are using Windows Task Manager to display the information about programs and processes that are running on your computer. You can start your Windows Task Manager with pressing Ctrl+Alt+Delete keys or with pressing Ctrl+Shift+Esc keys.

To keep Task Manager hidden when it is minimized.

• First open it by pressing Ctrl+Alt+Delete keys then go to Options menu and click on Hide When Minimized.
• You can easily restore it, if you click on the icon of Task Manager that will appear in taskbar near the time display.

Write A Batch File To Start Program In Startup

Write A Batch File To Start Program In Startup

You can start your computer applications automatically and control the sequence of the programs when your computer comes up.

Here we consider you want to run three different applications (WordPad, calculator, and notepad) and minimized automatically with sequence at windows startup. However, you can write a batch file to do the job for you. Open any text editor like notepad and type the following command.

start /min wordpad.exe start /min calc.exe start /min notepad.exe

Now choose the option, Save As to save this file with .bat extension. For example filename.bat.

Now Right- click on Start button and choose open > Double click Programs > here open Startup folder. Now drag your .bat file in the Startup folder and close the dialog box.

Next time When you restart the computer, WordPad, Calc will start first and then Notepad. You won't see the batch file run because you told it to run minimized.

Recycle as Much as You Want.

Recycle as Much as You Want

You can increase and decrease the size of the Recycle Bin. There are some size limitations with Recycle Bin size, its default size is equivalent to 10 percent of the drive size. But if you delete a larger size file accidentally, you can retrieve this file from Recycle Bin that is why you should set the maximum storage size of the Recycle Bin.

• First Right click on the Recycle Bin icon on the Desktop of your computer then go to Properties.
• Adjust the slider bar in the center of the screen from 10% to maximum size as you want.
• Then click OK button to save your new sitting and exit the Recycle Bin Properties Window.
• After change reboot your computer to have Windows fully initiate the necessary changes to your system.

How to delete files that are used by other programs in windows XP/Vista?

How to delete files that are used by other programs in windows XP/Vista?

Today tip will help you to delete the files and folders that are being used by another programs and applications, for example a virus affected file. You have tried to delete such kind of files or folders and received the any following messages.

• Cannot delete file: the file is in use by the other program
• Cannot delete file: There has been a sharing violation
• Cannot delete file: The file is in use by another program or user
• Cannot delete file: Disk is not full or write-protected and that the file is not currently in use.
• Cannot delete file: The source or destination file may be in use

Normally, a windows restart will allow you to delete such files or folders that are being used by other program, but if you want to manage it without restart your computer then simply you need to download a freeware tool called Unlocker.

You can download this tool for any windows version using Unlocker link. Download it and run the easy setup.

After installation, right click on file or folder that you want to delete and select the option Unlocker.

If your requested file or folder is used or locked by other application then a small window listing of lockers will appear. 

Here simply click on “Unlock All” button and  now you can easily delete this file.

How to enable the advance performance setting in windows vista?

How to enable the advance performance setting in windows vista? 

If you have noticed that the speed of your system is very slow with windows vista then today tip is very useful for you to increase the performance of windows vista. There is some default setting in vista which is used to manage the write caching on disk. By default windows enabled the write caching on disk but the advanced performance setting is disabled. 

Follow the given steps to configure the advance performance setting in Windows Vista:

To enable this feature, you will need to be logged into your computer with administrative rights.

First right click on My Computer icon then select the option Manage.

Here small windows will appear with title Computer Management, now select the Device Manager option, then locate the SATA Disk under the Disk Drives.

Here select the enable advanced performance sittings on the SATA disk.

Now click on Ok button to apply the setting and restart your computer after any changes to go into effect.

How to increase the Browsing and Downloading speed in Windows Vista?

How to increase the Browsing and Downloading speed in Windows Vista?

With windows Vista you have noticed the slow internet speed. The web browsing and downloading speed is very slow as compare to previous versions of windows. You can open the same sites in windows XP and server 2003 with the normal speed. 

Follow the given steps to increase the Vista browsing speed: 

First go to Advance tab in Internet Explorer and turn off the TLS (Transport Layer Security) encryption option. Here to fix problem with some secure pages turn on the SSL 2.0 (Secure Sockets Layer) feature and click Ok button to close it. 

Follow the major fix for this problem:

In windows Vista, the TCP autotuning feature is enabled by default. Some web servers do not respond properly to this feature, so it appears that some sites open with very slow speed. 

To use this feature, you will need to be logged into your computer with administrative rights.

First click on Start button and type CMD in Run option then press Enter.

At Command Prompt, type the following command and press enter.

netsh interface tcp set global autotuninglevel= disabled

This command will disable the TCP autotuning feature. Now close the command Prompt and restart your computer after any changes to go into effect.

You can easily restore these setting by typing the following command at Command Prompt.

netsh interface tcp set global autotuninglevel= normal

Now close the command Prompt and again restart your computer after any changes to go into effect.

How to Choose The Sounds For Each Windows Event?

How to Choose The Sounds For Each Windows Event?

Here is a cool tip to choose the sounds for each windows event, you can get these sounds files using windows special sound folders but you can add sounds from any third source.

• First Click on Start button, Control Panel and then Click the Sounds and audio devices icon.
• Click on sounds option , select it and then click Browse button.
• After clicking browse option you will go c:\WINNT > Media or Sounds folder (windows default sounds folder), but you can add sounds here from any third source.
• Simply locate here the sound file you want to associate with the selected event and double-click it.
• Now you can play this sound file in preview to observe if your like the sound file or not.
• Click OK, and then Click OK again to close the dialog box.

How to login with multiple ID's at the same time in Yahoo messenger?

How to login with multiple ID's at the same time in Yahoo messenger?

If you have multiple yahoo ID's and wants to login with more than one yahoo ID at the same time then don't worry, you can login with more than one yahoo ID at the same time using this tip. There is no need to install any other yahoo multi messenger version, you can easily covert your normal yahoo messenger into multi messenger and enjoy your many ID's at the same time.  

Follow the given steps to change the yahoo messenger registry value:

• Click Start button and type regedit in Run option then press Enter for next.
• 
• Here locate the location to:

HKEY_CURRENT_USER/Software/Yahoo/Pager/Test

Here in right side panel, right click to create a new Dword value with name Plural and give it value 1.

Now close the registry editor and restart your computer after any changes to go into effect.

For signing in with new YAHOO ID open another messenger open as many messengers you need.

If you want to disable the multiple messenger option then again open registry editor and change Plural value 1 to 0.

How to recover lost bookmarks on Firefox?

How to recover lost bookmarks on Firefox?

Today cool tip will help you to recover the lost bookmarks on Firefox. You can export the bookmarks folder to a specific folder or location using import and export option in Firefox. If you are new computer user, first you should learn about the importance and need of backup, because without backup yon can lose your favorite websites list any time due to any virus, power failure and hard disk problem. 

So, what happen if your Firfox's bookmarks suddenly disappear? It is very frustrating and disappointing but don't worry, Firefox actually do this job for you to create automatic backup. 

Follow the given steps to retrieve the lost bookmarks list:

Now go to your system C drive and navigate the following path "C:\Documents and Settings\your account name\Application Data\Mozilla\Firefox\Profiles\".

Under profiles folder, you will see a folder with random name, in our case this folder name is awrvfkuo.default.
Double click on awrvfkuo.default folder and you will see another folder with name "bookmarkbackups". Here is actual place where firefox store your bookmarks backup.

Now copy the all latest bookmarks detail and go up one level then past it.
Here rename the file to "bookmarks.html" and now your bookmarks should be restored.

How to logoff your computer automatically after a period of inactivity?

How to logoff your computer automatically after a period of inactivity? 

Today tip will help you to log off your computer automatically after some specific period of inactivity. Because most of the users left logged on their computer may represent a security threat for the company. For this purpose, first install the Winexit.scr tools that includes in Windows 2003 Resource Kit (rktools.exe) and you can free download it from Microsoft site. 

To use this feature, you will need to be logged into your computer with administrative rights.

After installing the rktools.exe setup, locate the Winexit.scr file in the following location.

C:\Program Files\Windows Resource Kits\Tools

Here right click no Winexit.scr file and select the Install option.

A Display Properties dialog box will appear, select Screen Saver tab and choose "Logoff Screen Saver" entry under the Screen saver area.

Now click on Setting button, again a small dialog box will appear with the title "WinExit Setup Dialog".

Here select the "Force application termination" check box under the "Force logoff" area

and type the number of seconds in "Countdown for n seconds" box under Time to logoff area.

Now type the message that appears during the logoff countdown timer in the "Logoff Message" box

and click on Ok button.

Click on "Preview" button to verify the settings.

Here a small dialog box will appear with the title "Auto logoff in progress", it displays the countdown

timer and logoff message.

Click on Cancel then Ok button to finish the process

How to enable the Hibernation feature in windows XP?

How to enable the Hibernation feature in windows XP? 

In windows environment, the hibernation is a built-in feature used to increases your work performance and also minimizes the windows startup time. For example, if you have to keep open a lot of files and windows applications then you can leave you system in hibernate mode without closing the open programs. When you restart computer after hibernation, all the running files and applications will be restore as you have left them. Windows store the all hibernated information in the Hiberfil.sys file using system root folder. The size of this file is roughly equal to the RAM of your system.

Follow the given steps to activate the hibernation in windows XP: 

To use this feature, you will need to be logged into your computer with administrative rights. 

First click on Start button> Control Panel, click on Performance and Maintenance then click on Power Options.

A new "Power Options Properties" dialog box will appear, select Hibernate tab and then select the "Enable hibernation" check box to enable the hibernate feature.

If you system does not support the hibernation feature then the hibernation tab will not available there.

Now click on Apply button to implement the changes then click on Ok button to end the configuration process. 

After enabling the hibernation feature click on Start button then click on "Turn off Computer". In the "Turn off Computer" dialog box, press the "Shift" for some time and click on Hibernate button. Your system will take some time to complete the hibernation process.

How to uninstall the windows XP using command prompt?

How to uninstall the windows XP using command prompt? 

Today tip will help you uninstall the upgraded version of windows XP using the command prompt options. If you have upgraded your operating system from the previous versions of windows 98 Second Edition, or Windows Millennium Edition (Me) and now you wants to revert to the operating system that was previously installed on your computer. Windows XP can be removed by uninstalling from a Command Prompt option in Safe mode because XP includes the Uninstall Windows XP option.

Follow the given steps to revert to the operating system that was previously installed on your computer: 

To manage windows XP, first you should log onto your computer with administrative rights.

First boot your system in Safe mode by pressing F8 button at the same time before the windows logo appears.

First click on Start button and type cmd in Run option then press Ok button to display the Command Prompt.

At the command prompt type cd/ command and press enter.

Now again type the command cd\windows\system32 and press enter button. After execution of this command, system will change the previous directory mode.

Now type the command at command prompt osuninst.exe to start the process.

Now on the computer screen, follow the instructions on the screen to begin uninstalling Windows XP from your computer to restore the previous operating system.

How to start windows programs quickly with Run Command?

How to start windows programs quickly with Run Command?

The run option of Start menu is used to run a program or to open a document directly. If you do not know the exact location of the program or document then click on Start button to open Run and type the programs shortcut name to open it directly.

Run Commands

• appwiz.cpl -- Used to run Add/Remove wizard
• Calc --Calculator
• Cfgwiz32 --ISDN Configuration Wizard
• Charmap --Character Map
• Chkdisk --Repair damaged files
• Cleanmgr --Cleans up hard drives
• Clipbrd --Windows Clipboard viewer
• Control --Displays Control Panel
• Cmd --Opens a new Command Window
• Control mouse --Used to control mouse properties

Dcomcnfg --DCOM user security

Debug --Assembly language programming tool

Defrag --Defragmentation tool

Drwatson --Records programs crash & snapshots

Dxdiag --DirectX Diagnostic Utility

Explorer --Windows Explorer

Fontview --Graphical font viewer

Fsmgmt.msc -- Used to open shared folders

Firewall.cpl  -- Used to configure windows firewall

Ftp -ftp.exe program

Hostname --Returns Computer's name

Hdwwiz.cpl -- Used to run Add Hardware wizard

Ipconfig --Displays IP configuration for all network adapters

Logoff -- Used to logoff the computer

MMC --Microsoft Management Console

Msconfig --Configuration to edit startup files

Mstsc -- Used to access remote desktop

Mrc -- Malicious Software Removal Tool

Msinfo32 --Microsoft System Information Utility

Nbtstat --Displays stats and current connections using NetBIOS over TCP/IP

Netstat --Displays all active network connections

Nslookup--Returns your local DNS server

Osk ---Used to access on screen keyboard

Perfmon.msc -- Used to configure the performance of Monitor.

Ping --Sends data to a specified host/IP

Powercfg.cpl -- Used to configure power option

Regedit --Registry Editor

Regwiz -- Registration wizard

Sfc /scannow -- System File Checker

Sndrec32 --Sound Recorder

Shutdown -- Used to shutdown the windows

Spider -- Used to open spider solitaire card game

Sfc / scannow -- Used to run system file checker utility.

Sndvol32 --Volume control for soundcard

Sysedit -- Edit system startup files

Taskmgr --Task manager

Telephon.cpl -- Used to configure modem options.

Telnet --Telnet program

Tracert --Traces and displays all paths required to reach an internet host

Winchat -- Used to chat with Microsoft

Wmplayer -- Used to run Windows Media player

Wab -- Used to open Windows address Book.

WinWord -- Used to open Microsoft word

Winipcfg --Displays IP configuration

Winver -- Used to check Windows Version

Wupdmgr --Takes you to Microsoft Windows Update

Write -- Used to open WordPad

How to disable auto-start applications on windows startup?

How to disable auto-start applications on windows startup?

Using this tip, you can minimize the startup time of windows XP and Vista also. You can disable some optional windows applications like windows messenger, Yahoo messenger, QuickTime and many others auto startup programs that run automatically when you start your computer.

Follow the given steps to disable the windows auto run applications: 

To use this feature, you will need to be logged into your computer with administrative rights.

Click Start button and type msconfig in Run option then press Enter for next.

A small System Configuration Utility dialog box will appear with many options like General, System.ini Win.ini, Boot.ini, Services, Startup and Tools.

Now select Startup tab and uncheck the applications that you want to disable from windows startup.

Now click on Apply button to implement the changes then click on Ok button to end the configuration process.

Again close the all program and restart your computer after any changes to go into effect.

How to set specified folder view to all Folder Views in windows XP and Vista?

How to set specified folder view to all Folder Views in windows XP and Vista?

Today tip will help you to manage the specified view of all folders in windows XP and Vista. By default, you have options to choose the view of folders contents as thumbnails, titles, icons, list or display with details. But this change will apply on the folders that you are currently working in. On the other hand, with the just few more clicks, you can change the view of all the folders on your computer.

Follow the given steps to accomplish this task through the Folder Options dialog box.

First of all open any folder, click "View" and choose the view you would most like to use.

Now from the Tools menu, click on Folder Options" to open the Folder Options dialog box.

Here on Folder Options dialog box, select the View tab.

At the top of the dialog box, click Apply to all folders button.

Now a new confirmation message will appear as "Set all the folders on your computer to match the current folders view settings (except for toolbars and folder task)? Change will occur the next time you open them."

Click OK in the Folder Options window to save the changes.

Now all the folders on your computer should display contents in your chosen view. As before, you can still change the view in individual folders via the "View" button.

How you can Automate the DIR Command.

If your are using same switches frequently in Command prompt then open your system command prompt using open Run option

Click Start and open Run option then type cmd to open command prompt, here type

set dircmd=/w/o/p

then press Enter, now every time thereafter that you type

dir

the /w/o/p switches will be automatically applied and now need to type every time. If your are interested to use single switch like /w you can use it

set dircmd=/w

and press Enter.

and same if you wants to undo these switches then you can very easily by typing

dir /-switch

For example, if you wanted to do a directory with only the /w switch, you could enter

dir /-p/-o

When you exit the Command prompt window, however, the Dircmd setting returns to its default settings.

How to create a System State data backup?

Using System State backup technique, you can create the backup of windows critical components on any system drive and this backup file can be used if the original copy is lost, damaged, or destroyed. On windows 2000/XP/Vista, system state data wizard backed up the following components.

• Windows registry
• 
  
• 
  
• 
  
• 
  
• 
  
• 
  
• 
  
• 
  
• 
  
• 
  
• Windows boot files

• 
  
• 
  
• 
  
• 
  
• 
  
• COM+ class registration database 

But if you are running domain controller, system state data wizard backed up the following components.

• Active Directory
• System volume (SYSVOL)
• Windows registry
• Windows boot files
• COM+ class registration database 

Follow the given steps to run System State data backup wizard:

To use this feature, you will need to be logged into your computer with administrative rights. 

First click on Start button> All programs> Accessories> System Tools then click on Backup.

Now by default backup wizard will start, click on advanced mode option to change the backup settings.

Here a dialog box will appear with title "Backup Utility", select "Welcome" tab and click on Backup Wizard [Advanced] button to create backup of windows important components.  

Click on Next button to continue backup wizard.

Now select option "Only back up the System State date" on what to back up page and click on Next button.

Here click on Browse button to specify the destination for backup file and also set backup file name under "Type a name for this backup" box then click on Next button. 

Now verify your selected settings and click on Finish button to start backup process.

How to restrict user's to access shutdown button?

This tip is very interesting for home and some small office users, who wants to restrict user's ability to shutdown their computer. You can hide the Shutdown button from the Start menu using registry editor and also restrict access to shutdown, if a user clicks on Ctrl+Alt+Del. 

Follow the given steps to hide system shutdown button from start menu:

• To use this feature, you will need to be logged into your computer with

        administrative rights.

• Click Start button and type regedit in Run option then press Enter for next.
• Here locate the location to:
• HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion \Policies\Explorer

Here in right side panel, right click to create a new DWORD value with name NoClose.

Now assign number 1 to its value data box.

Now close the registry editor and restart your computer after any changes to go into effect.

But next time, if you want to unhide the shutdown button then simply change the value data box to 0 or delete this DWORD item.

Again close the registry editor and restart your computer after any changes to go into effect.

How to adding your favorite image to a folder?

Dear friends here I have a very useful and interesting tip for you. Sometimes you have to face some problem to distinguish the folders because in standard configuration of window explorer each folder seems closely the similar to others.            

If you want to explore your folder in windows explorer's thumbnail view and make these folders are prominent then it is easier to distinguish using text name, for example you're download audio files or digital photos. But if you want to add image to a folder to distinguish with others then you should choose that folder which you want to decorate.

First open Window Explorer and right click on the folder to display the folder menu. Now choose Properties option from the menu, here a new dialog windows will appear with title "Program Properties".

Select Customize tab and click on "Choose Picture" button to add favorite image./p>

The image which you want to use navigates to that image and then clicks "Open" to view a sample of the picture inside the folder icon. Click on Ok button, if you are satisfied from that image .If you are not satisfied then choose another image.

Now at the end, go to View menu to display the folder in Explorer's thumbnail with image.

Windows Hot shortcut keys

Shortcut keys                        Action

Win                                 Press windows key to open start menu

Win+R                           Apply to open Run dialog box                           

Win+M                           Apply to minimize all opened windows                                

Win+Shift+M                 Apply to maximize all opened windows                                                              

Win+F                            Apply to open search options                                 

Win+U                            Apply keys to open Utility Manager                                   

Win+D                            To view desktop/minimize all windows                                  

Win+F1                           To view the detail windows help page                                           

Win+Pause                    To view the System Properties dialog box                               

Win+Tab                         Move through taskbar programs                             

Win+F+Ctrl                      Apply to open search for computers

Alt+Tab                            Move through opened windows programs                                

Alt+F4                              Press keys to close active windows program                                

Alt+Enter                         Apply to open properties of selected item                               

Alt+ SPACEBAR            Open the system menu of active window                                  

Alt+ SPACEBAR +N      Press keys to minimize the active program                                 

Alt+ SPACEBAR +R      Press keys to restore the active program                                

Alt+ SPACEBAR+C       Press keys to close the active program                                

Alt+ SPACEBAR+X        Press keys to maximize the active program                                 

Alt+ SPACEBAR+M       Press keys to move the active program                                

Ctrl+Alt+Delete              Apply to open windows task manager                               

Ctrl+Shift+Esc               Apply to open windows task manager                                

Ctrl+Esc                         Press keys to open start menu                                 

Shift                                 Shift key to prevent CD from automatically playing                                

Shift+Delete                  To delete items permanently