A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

EXCEL TO OUTLLOK



 
 
Thread Tools Display Modes
  #1  
Old July 6th, 2004, 12:29 AM
Woodsmith
external usenet poster
 
Posts: n/a
Default EXCEL TO OUTLLOK

Hi Lady Layla
I have the same problem as Jeff in PA.
I cannot seem to be able to select the data in my Excel file asn then name the cells to create the necessary link to download the file into Outlook.
When I first tried I did get some downloaded but then gor some error messages. I tried correcting the file and then all I got was 45,000 empty contact spots in that subfolder.
What is the correct protocol for naming the file in the name box?
--
George
Salem OR


"Lady Layla" wrote:

From Excel Help:


Share contact data between Excel and Outlook
Do one or both of the following:
Export Microsoft Excel names and addresses to Microsoft Outlook

Select the data you want to export and create a named range of cells.

Select the range of cells that you want to name.

Click the Name box at the left end of the formula bar .
Name box
Type the name for the cells.
Press ENTER.

Note You cannot name a cell while you are changing the contents of the cell.
Close the workbook that contains the range you want to export.

Start Outlook.
On the File menu, click Import and Export.
In the Import a File Wizard, click Import from another program or file, and then
click Next.
In the Select file type to import from box, click Microsoft Excel, and then
click Next.
Click Browse, select the file you want to import, click OK, and then click Next.
Select the Contacts folder and click Next.
If necessary, map fields from the file you are importing to Outlook fields.
How?
Click Map Custom Fields.
In the From box, drag the field you want to convert onto the Microsoft Outlook
field listed in the To box.
If you want to see additional records in the From box, click Previous or Next.
If you want to remove all mapping, click Clear Map.
If you want to reset the original mapping, click Default Map.
To display additional fields in the To box, click the plus sign (+) next to the
field. For example, to display the Business Street and Business City fields,
click the + next to Business Address.
If no field exists in the To box that would accommodate a field you are
importing, you can create a new custom field. Click Add a Custom Field, and
specify the field name in the New Field dialog box. You can create as many
custom fields as you need.
Click OK.
Click Finish.
Import Outlook contacts into Excel
Start Outlook.
On the File menu, click Import and Export.
Click Export to a file, and then click Next.
In the Create a file of type box, click Microsoft Excel, and then click Next.
In the Select folder to export from box, click Contacts, and then click Next.
Type a name for the file, click Next, and then click Finish.
In Excel, open the file you created in the previous step.
"JEFF IN PA" wrote in message
...
: How do I import an Excel document to Outlook...The excel
: document is a mailing list...ie names,company phone #s
: emails addresses etc...which all are fields in
: Outlook...and I know the initial steps to import to
: Outlook...but I keep getting an error message "fields are
: not recognized"...meaning that the "fields" in the Excel
: document are not being recognized by Outlook???? HELP
: HELP...JEFF



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2000 crushed Sue General Discussion 3 June 30th, 2004 12:25 AM
Excel 2000 STILL hangs on sort Jim Cobban General Discussion 2 June 29th, 2004 11:22 PM
Save as Web Page in Excel 2002 Bob New Users 1 June 23rd, 2004 02:49 PM
Recent Microsoft Excel Updates - March 24, 2004 Rita Nikas [MSFT] Setting up and Configuration 0 March 24th, 2004 05:14 PM
Recent Microsoft Excel Updates - March 24, 2004 Rita Nikas [MSFT] Charts and Charting 0 March 24th, 2004 05:13 PM


All times are GMT +1. The time now is 12:37 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.