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.