The virtual address book in the Microsoft Outlook email program can be filled with all the necessary contacts with a single click now. However, many users don’t know that it’s possible to transfer the data created in an excel sheet to the Microsoft Outlook. It’s difficult to type in the email address of every person you want to add on to the Microsoft Outlook contacts. Microsoft has however incorporated a system in the recent versions of the popular email client designing it in such a way that it allows a user to copy down the email addresses created in an excel sheet into the Outlook contacts. All you have to do in order to bring in an Excel spreadsheet in to the Microsoft Outlook address book is to convert the current spreadsheet from present file format to a comma-separated file format. Once it’s done the Outlook's Import and Export program will upload the comma separated excel spreadsheet in to the Outlook console without any issues. To add on email addresses in to the Microsoft Outlook address book, track the following instructions.
Instructions
• Launch the Microsoft Excel program from the MS Office menu and roll down to the first email address with the serial number "1" and right click on it to make way for the "Insert" tab that drops down from the perspective menu.
• Name the entire columns as “names of the contacts” in to the A1colomn and then the “email addresses” of the contacts into the B1 column.
• From the "File" tab select the "Save as" tab to pave way to the tab portrayed with the label "Save as Type" and pick out the "CSV (*.csv)." file format to Save that particular file in to your computer.
• Now go to the Microsoft Outlook and pick out the "File" to step up to the "Open" tab in which a tab will be portrayed with the name "Import" tab.
• Now hit on the tab "Import From Another File or Program" twice.
• Hit the "Comma Separated Values" tab twice before accessing the "Browse" to pick out the excel sheet saved on your computer.
• Pick out a particular method to handle out the duplicates and tag along the "Next".
• Now just tag on the "Contacts" tab and hit on the "Next" and "Finish" tab respectively to wind up the process.
I hope that you must have understood that the task of adding email address in to the Outlook address book is effortless and these instructions would enable anyone to add contacts without any hassle.
