Greater Pinellas Point Neighborhood

Computer Tips and Tricks

Problems and Solutions

Importing data from an EXCEL file in MICROSOFT OUTLOOK.

To successfully import data from an EXCEL file in MICROSOFT OUTLOOK, a "NAMED RANGE" must be assigned to the EXCEL worksheet.
To do this, carry out these steps:
1: In the EXCEL worksheet, select the rows and columns that contain the data you want to import.
2: On the INSERT menu, point to NAME and then click DEFINE.
3: In the NAMES IN WORKBOOK box, type a name for the range you just selected and click ADD. (The NAME can be whatever you like but cannot contain spaces, and cannot be the same as the name of a column header)
4: Click OK, and on the FILE menu, click SAVE.
5: Quit EXCEL
6: Open MICROSOFT OUTLOOK, on the FILE menu, point to IMPORT/EXPORT and follow the wizard instructions.

IS YOUR COMPUTER SECURE?

Cookies, Shareware, Spyware etc.. may track your surfing habits and send data stored on your computer to third parties without your permission!
Get rid of dangerous parasites by scanning your machine regulary with AD-AWARE and SPYBOT software.
These programs are FREE!
Use the first two links below to download them.

EXCEL TIPS

Would you like to learn, how to use short cuts keys, create an amortization schedule, calculate loan payments, use macros and much more, go to Joseph Rubin's Excel Tips.
This site provides many cool tips to use with Excel as well as many links offering problems solutions. Connect to that site with the 3rd link below.

Email us
claude.jenet@knology.net

Links

Spybot
Ad Aware
Joseph Rubin's Excel Tips