![]() |
| 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: contacts, excel, uploading |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
I use Outlook (not express version) and need to upload hundreds of e-mail
address from an excel spreadsheet - only the addresses are listed - no names. Suggestions? |
| Ads |
|
#2
|
|||
|
|||
|
Not entirely sure what your exact question is vis-a-vis importing email
addresses versus no names so in the interests of saving time and minizing number of posts - a generic response: #1 - To import into Outlook - use Outlook's import/export function. Make sure that you have a "named range" defined in the Excel worksheet that covers the info you want to import. If your first row in the Excel worksheet is not a "header" row defining the column names - be sure to add one and include it in the "named range". If not comfortable with "named range" names in Excel (see Excel help file for adding a "named range" - just save the file as a CSV file and import that. #2 - Unless you want a whole whack of contacts with no names, suggest you add these to the Excel worksheet before importing - would be a whole lot faster and easier then doing it "after the fact". Add a minimum of 2 columns to your worksheet (First & Last Name) - or whatever parts of the Full Name you want to import (you can also get away with having only one column for the name - label it FullName for ease of reference). Fill in the blanks, make sure you change the Excel "named range" accordingly to include new columns or save updated worksheet as a CSV file. 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 "mcamp" wrote in message ... I use Outlook (not express version) and need to upload hundreds of e-mail address from an excel spreadsheet - only the addresses are listed - no names. Suggestions? |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Uploading contacts from Outlook 2003 contacts into outlook express | RevAl | Outlook - Using Contacts | 0 | April 18th 07 02:04 AM |
| Uploading outlook emails to hotmail | ggrothendieck@gmail.com | Outlook - General Queries | 4 | January 11th 07 10:04 PM |
| uploading messages from desktop | Lane Browning | Outlook Express | 15 | September 4th 06 07:37 AM |
| uploading to a group | Richard K | Outlook - Using Contacts | 1 | May 29th 06 08:23 PM |
| Uploading a club programme | Alex C | Outlook - Calandaring | 2 | May 20th 06 03:05 PM |