[mso] Re: Importing Excel 2000 list into Outlook 2000
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Wed, 29 Jan 2003 18:58:20 -0500
Well...I can't do it in Access, tho I know it's possible, but if you export
it from Access into Excel, you can follow the directions I gave her and do
it that way. (I've left the directions below)
I'm assuming you know how to export a table from Access to Excel, right?
Linda
Publisher ~ ABC ~ All 'Bout Computers
Owner ~ Linda's Computer Stop
http://personal-computer-tutor.com
FREE MS Office eBook Tutorial
http://personal-computer-tutor.com/library.htm
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Hough, John
Sent: Wednesday, January 29, 2003 5:46 PM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Importing Excel 2000 list into Outlook 2000
I have a similar situation in my office with an Access database. We have a
huge client list in Access and I'd love to import or sync it with Outlook
contacts. Is there something similar I can do?
-----Original Message-----
From: Linda F. Johnson [mailto:linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx]
Sent: Wednesday, January 29, 2003 12:33 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Importing Excel 2000 list into Outlook 2000
Open the file in Excel and highlight all the data that you want included in
what you are importing into Outlook....then click inside the Name box on
your formatting toolbar....it's on the far left end of the toolbar and it
usually displays the name of the cell you are inside (like A1 or G10 or
something)....when you click in there, you will see the cell number get
highlighted and shoot over to the left end of the box....type a name...make
it short and no spaces, and it can't begin with a number....use something
like addylist or something...then HIT ENTER (you must do this or the name
won't take)...now you have a named range...save and close the workbook
Now try the import from Outlook again and when it asks you for the named
range, you should see addylist as a choice (or whatever you named the
range)...just choose that and it should work fine.
Linda
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
