 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Contacts / October 2005Importing XLS to Outlook/exchange Contacts
Installation has SBS2000 with Exchange 2000 integrated on same server. Client has received an Excel spreadsheet of name and address information that he'd like set up in a contact list(or address list) in Exchange for manipulation and use by his staff. I have looked through NG for instructions on how to "import" this data and cannot find anything. Can someone enumerate explicit instructions on how to create contacts or address from an Excel Spreadsheet. TIA RickD Select all the rows and columns in the Excel worksheet and choose Insert | Name | Create to create a named range. Save the worksheet. Create a new contacts folder (temporary import target) in a mailbox or .pst file in the current Outlook mail profile. Choose File | Import and Export and follow the prompts to import the worksheet data. Either copy the entire folder to the Public Folders\All Public Folders hierarchy or copy the data items into an existing public contacts folder. Set permissions on the public folder's Properties dialog to allow access by the desired users.  SignatureSue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx > Installation has SBS2000 with Exchange 2000 integrated on same server. > [quoted text clipped - 11 lines] > > RickD Thank you Sue.....this all worked perfectly and I configured the shared contact list(Employers) with security to allow a specific group to read-only and the administrative assistent to RWED. Now the task at hand is to send an email to all contacts with a valid email address( only about 20% have email addresses) with a MS Word doc attached. TIA RickD Select all the rows and columns in the Excel worksheet and choose Insert | Name | Create to create a named range. Save the worksheet. Create a new contacts folder (temporary import target) in a mailbox or .pst file in the current Outlook mail profile. Choose File | Import and Export and follow the prompts to import the worksheet data. Either copy the entire folder to the Public Folders\All Public Folders hierarchy or copy the data items into an existing public contacts folder. Set permissions on the public folder's Properties dialog to allow access by the desired users. -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx > Installation has SBS2000 with Exchange 2000 integrated on same server. > [quoted text clipped - 11 lines] > > RickD If you want to have both a cover message and the Word attachment, you'll have to use a third-party tool. See http://www.slipstick.com/addins/mail.htm#massmail. If it's OK to use the Word document as the message body itself or send the attachment without a cover message, create a new filtered view to show only contacts with email addresses, apply that view, select all contacts, then choose Tools | Mail Merge and follow the prompts. SignatureSue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx > Thank you Sue.....this all worked perfectly and I configured the shared > contact list(Employers) with security to allow a specific group to read-only [quoted text clipped - 43 lines] >> >> RickD |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.