Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import contacts from outlook
I can't seem to find the import option in excel 2007. I would prefer to
import my contacts into an excel table. Where is it import tool? thanks -- Bob Levin |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import contacts from outlook
You need to go into Outlook and export them, excel is an option there.
"Bob Levin" wrote: I can't seem to find the import option in excel 2007. I would prefer to import my contacts into an excel table. Where is it import tool? thanks -- Bob Levin |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import contacts from outlook
Thank You dlw: I exported contacts from outlook to excel and it worked fine
except in the address field, there are separation marks after the street address, after the state, and after the zip code. When I did field mapping, I used address only. Not seperate fields for street, state, and zip. I would prefer that the complete address be in the same field, but why are those marks there, and is it possible to ge rid of them? Thank you much -- Bob Levin "dlw" wrote: You need to go into Outlook and export them, excel is an option there. "Bob Levin" wrote: I can't seem to find the import option in excel 2007. I would prefer to import my contacts into an excel table. Where is it import tool? thanks -- Bob Levin |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import contacts from outlook
Hello.
Sub LectureContacts() Set olApp = CreateObject("Outlook.Application") Set olns = olApp.GetNamespace("MAPI") Set olfFolder = olns.GetDefaultFolder(10) ligne = 2 On Error Resume Next ' contacts incomplets For Each i In olfFolder.Items Cells(ligne, 1) = i.FirstName Cells(ligne, 2) = i.LastName Cells(ligne, 3) = i.Email1Address Cells(ligne, 4) = i.Categories ligne = ligne + 1 Next i On Error GoTo 0 [A1].Sort Key1:=[A1], Header:=xlYes End Sub http://boisgontierjacques.free.fr/fi...jb-outlook.zip JB http://boisgontierjacques.free.fr/ On 25 août, 06:52, Bob Levin wrote: Thank You dlw: I exported contacts from outlook to excel and it worked fine except in the address field, there are separation marks after the street address, after the state, and after the zip code. When I did field mapping, I used address only. Not seperate fields for street, state, and zip. I would prefer that the complete address be in the same field, but why are those marks there, and is it possible to ge rid of them? Thank you much -- Bob Levin "dlw" wrote: You need to go into Outlook and export them, excel is an option there. "Bob Levin" wrote: I can't seem to find the import option in excel 2007. I would prefer to import my contacts into an excel table. Where is it import tool? thanks -- Bob Levin- Masquer le texte des messages précédents - - Afficher le texte des messages précédents - |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import contacts from outlook
Thank you JB: I forgot to mention. I'm just learning this program. I don't
understand that post. would it be possible to explain it in easy steps. Thank you so much. -- Bob Levin "JB" wrote: Hello. Sub LectureContacts() Set olApp = CreateObject("Outlook.Application") Set olns = olApp.GetNamespace("MAPI") Set olfFolder = olns.GetDefaultFolder(10) ligne = 2 On Error Resume Next ' contacts incomplets For Each i In olfFolder.Items Cells(ligne, 1) = i.FirstName Cells(ligne, 2) = i.LastName Cells(ligne, 3) = i.Email1Address Cells(ligne, 4) = i.Categories ligne = ligne + 1 Next i On Error GoTo 0 [A1].Sort Key1:=[A1], Header:=xlYes End Sub http://boisgontierjacques.free.fr/fi...jb-outlook.zip JB http://boisgontierjacques.free.fr/ On 25 ao{t, 06:52, Bob Levin wrote: Thank You dlw: I exported contacts from outlook to excel and it worked fine except in the address field, there are separation marks after the street address, after the state, and after the zip code. When I did field mapping, I used address only. Not seperate fields for street, state, and zip. I would prefer that the complete address be in the same field, but why are those marks there, and is it possible to ge rid of them? Thank you much -- Bob Levin "dlw" wrote: You need to go into Outlook and export them, excel is an option there. "Bob Levin" wrote: I can't seem to find the import option in excel 2007. I would prefer to import my contacts into an excel table. Where is it import tool? thanks -- Bob Levin- Masquer le texte des messages pricidents - - Afficher le texte des messages pricidents - |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import contacts from outlook
Hi,
The Import and Export Wizard in Outlook makes it easy to export contact information from Outlook into an Excel worksheet (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.). Note Before you use the wizard, it helps to understand the difference between the Outlook Address Book (Address Book: The collection of address books that you can use to store names, e-mail addresses, fax numbers, and distribution lists. The Address Book may contain a Global Address List, an Outlook Address Book, and a Personal Address Book.) and Outlook Contacts. Both are part of Outlook. However, the Address Book is a compilation of the different address lists you might have stored in Outlook, such as a Personal Address Book (.pab), Lightweight Directory Access Protocol (LDAP): A protocol that provides access to Internet Directories.) Internet directories, the Global Address List (GAL) (Global Address List: The address book that contains all user, group, and distribution list e-mail addresses in your organization. The administrator creates and maintains this address book. It may also contain public folder e-mail addresses.), or other third-party address books. Contacts is just one of the address lists that make up the Address Book. Only contacts can be exported directly from Outlook to Excel. 1. In Outlook, on the File menu, click Import and Export. 2. Click Export to a file, and then click Next. 3. Click Microsoft Excel, and then click Next. 4. In the folder list, click the Contacts folder, and then click Next. 5. Browse to the folder where you want to save the contacts as an Excel file (.xls). 6. Type a name for the exported file, and then click OK. 7. Click Next. 8. To add or remove fields to determine the way the contact information is saved in the new Excel worksheet, click Map Custom Fields. 9. Click Finish. Challa Prabhu "Bob Levin" wrote: I can't seem to find the import option in excel 2007. I would prefer to import my contacts into an excel table. Where is it import tool? thanks -- Bob Levin |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import contacts from outlook
Thank You Challa: That was very helpful. However, after exporting contacts
to the excel worksheet, why is it that in the address field, there are marks separating the street from the city, the city from the state, and the state from the zip code? It's almost like a "comma separated file. in field mapping I had the option to export the street, city, state, and zip in separate fields. I prefer them to be in the same field but can those marks be removed somehow? Thanks again -- Bob Levin "challa prabhu" wrote: Hi, The Import and Export Wizard in Outlook makes it easy to export contact information from Outlook into an Excel worksheet (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.). Note Before you use the wizard, it helps to understand the difference between the Outlook Address Book (Address Book: The collection of address books that you can use to store names, e-mail addresses, fax numbers, and distribution lists. The Address Book may contain a Global Address List, an Outlook Address Book, and a Personal Address Book.) and Outlook Contacts. Both are part of Outlook. However, the Address Book is a compilation of the different address lists you might have stored in Outlook, such as a Personal Address Book (.pab), Lightweight Directory Access Protocol (LDAP): A protocol that provides access to Internet Directories.) Internet directories, the Global Address List (GAL) (Global Address List: The address book that contains all user, group, and distribution list e-mail addresses in your organization. The administrator creates and maintains this address book. It may also contain public folder e-mail addresses.), or other third-party address books. Contacts is just one of the address lists that make up the Address Book. Only contacts can be exported directly from Outlook to Excel. 1. In Outlook, on the File menu, click Import and Export. 2. Click Export to a file, and then click Next. 3. Click Microsoft Excel, and then click Next. 4. In the folder list, click the Contacts folder, and then click Next. 5. Browse to the folder where you want to save the contacts as an Excel file (.xls). 6. Type a name for the exported file, and then click OK. 7. Click Next. 8. To add or remove fields to determine the way the contact information is saved in the new Excel worksheet, click Map Custom Fields. 9. Click Finish. Challa Prabhu "Bob Levin" wrote: I can't seem to find the import option in excel 2007. I would prefer to import my contacts into an excel table. Where is it import tool? thanks -- Bob Levin |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import contacts from outlook
Hi,
Sorry. I am not getting any notification in hotmail account, even after clicking the "Notify me of replies" check box. That was the reason, why I could not respond to you. I will check and let you know why it happens so. Challa Prabhu "Bob Levin" wrote: Thank You Challa: That was very helpful. However, after exporting contacts to the excel worksheet, why is it that in the address field, there are marks separating the street from the city, the city from the state, and the state from the zip code? It's almost like a "comma separated file. in field mapping I had the option to export the street, city, state, and zip in separate fields. I prefer them to be in the same field but can those marks be removed somehow? Thanks again -- Bob Levin "challa prabhu" wrote: Hi, The Import and Export Wizard in Outlook makes it easy to export contact information from Outlook into an Excel worksheet (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.). Note Before you use the wizard, it helps to understand the difference between the Outlook Address Book (Address Book: The collection of address books that you can use to store names, e-mail addresses, fax numbers, and distribution lists. The Address Book may contain a Global Address List, an Outlook Address Book, and a Personal Address Book.) and Outlook Contacts. Both are part of Outlook. However, the Address Book is a compilation of the different address lists you might have stored in Outlook, such as a Personal Address Book (.pab), Lightweight Directory Access Protocol (LDAP): A protocol that provides access to Internet Directories.) Internet directories, the Global Address List (GAL) (Global Address List: The address book that contains all user, group, and distribution list e-mail addresses in your organization. The administrator creates and maintains this address book. It may also contain public folder e-mail addresses.), or other third-party address books. Contacts is just one of the address lists that make up the Address Book. Only contacts can be exported directly from Outlook to Excel. 1. In Outlook, on the File menu, click Import and Export. 2. Click Export to a file, and then click Next. 3. Click Microsoft Excel, and then click Next. 4. In the folder list, click the Contacts folder, and then click Next. 5. Browse to the folder where you want to save the contacts as an Excel file (.xls). 6. Type a name for the exported file, and then click OK. 7. Click Next. 8. To add or remove fields to determine the way the contact information is saved in the new Excel worksheet, click Map Custom Fields. 9. Click Finish. Challa Prabhu "Bob Levin" wrote: I can't seem to find the import option in excel 2007. I would prefer to import my contacts into an excel table. Where is it import tool? thanks -- Bob Levin |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import contacts from outlook
this is very helpful. Now that i created my new spreadsheet is there an easy
way to update it as i add contacts in outlook without recreating a new spreadsheet with every new entry? thanks for your help. "challa prabhu" wrote: Hi, The Import and Export Wizard in Outlook makes it easy to export contact information from Outlook into an Excel worksheet (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.). Note Before you use the wizard, it helps to understand the difference between the Outlook Address Book (Address Book: The collection of address books that you can use to store names, e-mail addresses, fax numbers, and distribution lists. The Address Book may contain a Global Address List, an Outlook Address Book, and a Personal Address Book.) and Outlook Contacts. Both are part of Outlook. However, the Address Book is a compilation of the different address lists you might have stored in Outlook, such as a Personal Address Book (.pab), Lightweight Directory Access Protocol (LDAP): A protocol that provides access to Internet Directories.) Internet directories, the Global Address List (GAL) (Global Address List: The address book that contains all user, group, and distribution list e-mail addresses in your organization. The administrator creates and maintains this address book. It may also contain public folder e-mail addresses.), or other third-party address books. Contacts is just one of the address lists that make up the Address Book. Only contacts can be exported directly from Outlook to Excel. 1. In Outlook, on the File menu, click Import and Export. 2. Click Export to a file, and then click Next. 3. Click Microsoft Excel, and then click Next. 4. In the folder list, click the Contacts folder, and then click Next. 5. Browse to the folder where you want to save the contacts as an Excel file (.xls). 6. Type a name for the exported file, and then click OK. 7. Click Next. 8. To add or remove fields to determine the way the contact information is saved in the new Excel worksheet, click Map Custom Fields. 9. Click Finish. Challa Prabhu "Bob Levin" wrote: I can't seem to find the import option in excel 2007. I would prefer to import my contacts into an excel table. Where is it import tool? thanks -- Bob Levin |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import contacts from outlook
Challa when I export my contacts from Outlook to Excel like you suggested I
get an apostrophe in every field. How can I get rid of the apostrophes with out deleting them from every field? Suxan "challa prabhu" wrote: Hi, Sorry. I am not getting any notification in hotmail account, even after clicking the "Notify me of replies" check box. That was the reason, why I could not respond to you. I will check and let you know why it happens so. Challa Prabhu "Bob Levin" wrote: Thank You Challa: That was very helpful. However, after exporting contacts to the excel worksheet, why is it that in the address field, there are marks separating the street from the city, the city from the state, and the state from the zip code? It's almost like a "comma separated file. in field mapping I had the option to export the street, city, state, and zip in separate fields. I prefer them to be in the same field but can those marks be removed somehow? Thanks again -- Bob Levin "challa prabhu" wrote: Hi, The Import and Export Wizard in Outlook makes it easy to export contact information from Outlook into an Excel worksheet (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.). Note Before you use the wizard, it helps to understand the difference between the Outlook Address Book (Address Book: The collection of address books that you can use to store names, e-mail addresses, fax numbers, and distribution lists. The Address Book may contain a Global Address List, an Outlook Address Book, and a Personal Address Book.) and Outlook Contacts. Both are part of Outlook. However, the Address Book is a compilation of the different address lists you might have stored in Outlook, such as a Personal Address Book (.pab), Lightweight Directory Access Protocol (LDAP): A protocol that provides access to Internet Directories.) Internet directories, the Global Address List (GAL) (Global Address List: The address book that contains all user, group, and distribution list e-mail addresses in your organization. The administrator creates and maintains this address book. It may also contain public folder e-mail addresses.), or other third-party address books. Contacts is just one of the address lists that make up the Address Book. Only contacts can be exported directly from Outlook to Excel. 1. In Outlook, on the File menu, click Import and Export. 2. Click Export to a file, and then click Next. 3. Click Microsoft Excel, and then click Next. 4. In the folder list, click the Contacts folder, and then click Next. 5. Browse to the folder where you want to save the contacts as an Excel file (.xls). 6. Type a name for the exported file, and then click OK. 7. Click Next. 8. To add or remove fields to determine the way the contact information is saved in the new Excel worksheet, click Map Custom Fields. 9. Click Finish. Challa Prabhu "Bob Levin" wrote: I can't seem to find the import option in excel 2007. I would prefer to import my contacts into an excel table. Where is it import tool? thanks -- Bob Levin |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import contacts from outlook
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mistake in Import Excel work sheet to Outlook contacts | Excel Worksheet Functions | |||
Import Excel File to Contacts in Outlook | Excel Discussion (Misc queries) | |||
Error message when trying to import csv into Outlook contacts. | Excel Discussion (Misc queries) | |||
can I import the outlook contacts into the excel spreadsheet? HOW | New Users to Excel | |||
outlook contacts | Excel Discussion (Misc queries) |