View Single Post
  #12  
Old April 1st, 2009, 10:02 PM posted to microsoft.public.outlook.contacts
eriko
external usenet poster
 
Posts: 2
Default Create distribution list in Outlook from Excel spreadsheet?

i created a distribution list using .csv from excel. how ever when i opened
it the fields were not correct. in excel i had fields for first name; last
name and email
when i mapped i used display for last name: however in outlook 2007 i had
fields for name (first name) and email address. how can i get the original
three fields into outlook. if u can help thank you. i look forwards for some
advice.

"Brian Tillman" wrote:


m wrote:

-- HOW do I export the DL to a text file, considering that past text
files from Outlook's export process have omitted all DLs?


Open the DL and and choose FIleSave As.

Re (2) & (3): Any chance of answers to these?


2) Can I import address/contact data from Excel (or CSV file) into a
separately-named Outlook address/contacts folder rather than to the
general
Contacts folder?


Yes.

If so, how? Outlook doesn't seem to allow selecting a
particular destination contacts folder for imported data.


FileImport and ExportImport from another program or fileComma Separated
Value (Windows)Next. Browse to the CSV, select it, click OK, select the
duplicate handling you want, and click OK. Select the folder into which you
want to import it and click Finish. Works for me.

3) Considering that Outlook does allow opening a .pst file with
address/contacts data into a separately named contacts folder, can the
current Excel file be converted into a .pst file either directly or via an
intermediate CSV file? If so, how?


You cannot convert a CSV file or a spreadsheet into a PST. You must import
into Outlook.
--
Brian Tillman