Create distribution list in Outlook from Excel spreadsheet?

"Brian Tillman [MVP - Outlook]" wrote:

> "hsvgal" <hsvgal.TakeThisOut@discussions.microsoft.com> wrote in message
> news:1B7495A7-3E26-4A46-976F-B487B2082B85@microsoft.com...
>
> > I just copied the list of email addressess from my excel spreadsheet, and
> > followed
> > your steps above. However, I did not have any colons, semi-colons or coma
> > separators.
>
> If you have name/address pairs, one pair per row, it will also work.
> --
> Brian Tillman [MVP-Outlook]
>
> Unfortunately, I only had the email addresses, but for my purposes, it worked out fine. The email address showed up both the Name and Email fields.

Thanks, hsvgal

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:

> d.deane(nospam)@comcast.net
> <ddeanenospamcomcastnet.RemoveThis@discussions.microsoft.com> 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 FIle>Save 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.
>
> File>Import and Export>Import from another program or file>Comma 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
>
>

you have to map the last name to the last name field. Try re-importing
them.

--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:
mailto:dailytips-subscribe-request@lists.outlooktips.net

EMO - a weekly newsletter about Outlook and Exchange:
mailto:EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.


"eriko" <eriko.DeleteThis@discussions.microsoft.com> wrote in message
news:7FDC18B5-E140-4BB8-820D-104DC3927FA5@microsoft.com...
> 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:
>
>> d.deane(nospam)@comcast.net
>> <ddeanenospamcomcastnet.DeleteThis@discussions.microsoft.com> 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 FIle>Save 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.
>>
>> File>Import and Export>Import from another program or file>Comma
>> 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
>>
>>

"Bruce" wrote:

> I have about 70 email addresses (non-profit assoc. members) in an Access
> database that, if needed, I can convert to an Excel spreadsheet.
>
> What I want to do is generate a distribution list in Outlook without having
> to start from scratch and select each name in the Address Book. Can this be
> done?
>
> Thanks