At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.
Go to file in the outlook.
click on import and export
select import from another program of file, click next
select Microsoft Excel 97-2003, click next
type in or browser for the Excel file you want to import, and select don not import duplicate items. click next
select destinationfolder-contact folder click next
***********To add or remove fields to determine the way the contact information is saved in the new imported file,***********
click on map custom field.
click and drag the item in the left panel to the right panel, where you want the item to appear.
click finish.
if you don't like the way the items imported. just hight all of the items that was imported in the contact folder and press deleted.
you can start again.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
When you install Outlook 2010, it automatically converts the Personal Address Book that you used in an earlier version of Microsoft Outlook. Outlook 2010 then adds the converted data to your Outlook 2010 Contacts folder.
If Outlook 2010 does not automatically convert your Personal Address Book, you can import your Personal Address Book to Outlook 2010. To do this, follow these steps:
Start Outlook 2010.
Click the File menu.
Click Open, and then click Import. The Import and Export Wizard opens.
Click Import from another program or file, and then click Next.
Click Personal Address Book, and then click Next.
Click Browse, locate the Personal Address Book that you want to import, and then click OK.
Note Earlier versions of Outlook assign a .pab file name extension to a Personal Address Book. By default, Outlook stores the Personal Address Book in the following folder:
C:\Documents and Settings\username\Local Settings\Application Data\Microsoft\Outlook
Microsoft's Outlook is integrated into Microsoft Office 2000, 2002, 2008 and Microsoft Exchange Server. Outlook is complete e-mail manager by which you e-mail, calendaring, and contact management. Outlook enables you to filter and organize e-mail messages, integrate and manage e-mail from multiple e-mail accounts, personal and group calendars, contacts, folders, and tasks. Using Import and Export feature in Outlook, you can create the full backup of outlook contacts. Because without backup yon can lose your e-mail accounts data any time due to virus, power failure and hard disk problem. Follow the given steps to export your outlook contacts to Excel file: Click on Start button, go to Program then click on Microsoft Outlook to export the contacts.
Now go to File menu and click on Import and Export
option.
Choose Export to a file as show in the below figure then click Next. Now on next dialog
box,choose Microsoft Excel and click Next. Select the
Contacts Folder you want to backup to Excel file as shown below then
click Next. Choose a name and
location where to save the Excel file by clicking Browse button, then
click Next. Click Finish to
start the back up procedure which may take little time depending on how
many contacts you have.
There could be two problems first once you used comma separated values spaces in contact names are definetly going to occur that is going to ruin the file. This approach is entirely not recommended. Secondly if the file while copy has triggered any event in the OS that will be unavailable and would be shown under using category. Hence, first hit ctrl + alt + del open processes tab right click processes and select end process tree wait for 10 seconds click on first tab and click new task command button and type explorer and ok. Now try to import the contacts in outlook. I'm providing this so you can do this with your own method. There are many more methods to achieve the same. Kindly let me know if this does not works.
Do you remember when you imported the output from your BB? One of the last steps after you have chosen the file to import shows a button for Map Custom Fields. Choose that button and then drag Full Name from the left side to FIRST NAME on the right side. When I did that, Outlook shows them in order of First name.
Because your previous import mapped FullName from BB to Last Name, that's the way it's showing. I tried within Outlook to change it around and it would not change it for me either.
I just stumbled on this one. Actually it's EASY! Open up your contacts list in Notes, go to the File menu, choose export. You can pick either "Structured Text", "Tabular Text", or "Comma Separated Value". All of these import well into either of those programs.
>lets open windows address book
>Export the contacts>as Address book (wab)>save it on to desktop and give a file name
>Once it is saved copy and paste it to flash drive
>lets connect the flash drive to another computer
>lets copy the file and paste it to desktop
>lets import the file from desktop
In Excel, you can import the scan, by importing a picture. You will need to put the scan into a compatible format. Can you open the scan and save it as a JPEG or other format that Excel can recognize? You can then import it, resize it as necessary, and place it next to your data. Then you can select a specific grid of cells as the Print Area, and tell Excel to 'fit' your document to one page wide by one page tall in your Print Setup.
×