|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
| Tags: 2003, contacts, excel, exporting, mailing, outlook, versions |
|
|
Thread Tools | Display Modes |
|
#1
August 14th 07, 09:44 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
Exporting Excel Contacts and mailing to Outlook, 2003 versions.
I'm having troubles exporting an excel file xls. into outlook for a large
contact section, I've tried everything i can but something seems to want to work, the last thing i want to do is type every contact out onto outlooks contact section as i have over 150 contacts complete with name, address, phone number, etc. The one suggestion i noticed the most was re-naming the cells to show how much of the data i want imported into outlook, I've tried that and to no avail keep getting my excel file un-accessible to outlooks contacts, thanks... 
|
| Ads |
|
#2
August 14th 07, 10:10 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Exporting Excel Contacts and mailing to Outlook, 2003 versions.
Your description is a little confusing so just to clarify:
#1 - You don't export from Excel to Outlook - you import an XLS file from Outlook (using the import wizard) into your desired Outlook contact folder #2 - If you're importing an Excel worksheet - you need to have a "named range" for the data you want to export. Or a much more simpler approach if you're not familiar with what a "named range" is - just save the worksheet as a CSV file and import that file using Outlook's import wizard #3 - No need to re-name any cells in either case - just make sure you "map" the correct fields. In fact, a whole lot safer then using Outlook's "automap" feature. Since you haven't provided any other info - the above assumes the following: #1 - Target contact folder is located in a PST file or in your Exchange Mailbox (if using Exch) #2 - You are not using any custom forms (to import any data to ANY user-defined fields whether or not a custom form is being used) #3 - Your question was not related to using your Excel file as your "contact source" for everyday operations (you can't) Karl __________________________________________________ _ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter "Power contact importers/exporters for MS Outlook '2000/2007" http://www.contactgenie.com "PB" wrote in message ... I'm having troubles exporting an excel file xls. into outlook for a large contact section, I've tried everything i can but something seems to want to work, the last thing i want to do is type every contact out onto outlooks contact section as i have over 150 contacts complete with name, address, phone number, etc. The one suggestion i noticed the most was re-naming the cells to show how much of the data i want imported into outlook, I've tried that and to no avail keep getting my excel file un-accessible to outlooks contacts, thanks...
|
|
#3
August 14th 07, 10:11 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Exporting Excel Contacts and mailing to Outlook, 2003 versions.
PB wrote:
I'm having troubles exporting an excel file xls. into outlook for a large contact section, You can't export using Excel into Outlook. You must import from an Excel spreadsheet (or a comma-separated values file) using Outlook. Exactly how are you trying to perform the operation? -- Brian Tillman [MVP-Outlook]
|
|
#4
August 14th 07, 11:38 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Exporting Excel Contacts and mailing to Outlook, 2003 versions
Yea sorry i've never been good at explaing things when i get frustrated lol,
anyway yes the CSV. file worked and i mapped everything accordingly thank you. PB. "Brian Tillman" wrote: PB wrote: I'm having troubles exporting an excel file xls. into outlook for a large contact section, You can't export using Excel into Outlook. You must import from an Excel spreadsheet (or a comma-separated values file) using Outlook. Exactly how are you trying to perform the operation? -- Brian Tillman [MVP-Outlook]
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How can I select mailing address when exporting outlook to excel? | needs help badly! | Outlook - Using Contacts | 6 | August 2nd 07 01:04 PM |
| Exporting contacts from outlook to excel problem | higherground | Outlook - Using Contacts | 1 | October 31st 06 06:46 PM |
| Exporting email from Outlook to Excel 2003 | Cryptographic_ICE@yahoo.com | Outlook - General Queries | 3 | August 3rd 06 02:38 AM |
| Exporting Excel Contacts to Outlook - Want to Change the Display | MKC | Outlook - Using Contacts | 4 | March 22nd 06 06:22 PM |
| Exporting Contacts from Outlook emails don't go thru into Excel | neilccarter | Outlook - Using Contacts | 1 | January 18th 06 05:58 AM |
Linear Mode
