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 Outlook » Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Create distribution list in Outlook from Excel spreadsheet?



 
 
Thread Tools Display Modes
  #11  
Old November 19th, 2008, 02:26 PM posted to microsoft.public.outlook.contacts
hsvgal
external usenet poster
 
Posts: 14
Default Create distribution list in Outlook from Excel spreadsheet?



"Brian Tillman [MVP - Outlook]" wrote:

"hsvgal" wrote in message
...

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
  #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


  #13  
Old April 2nd, 2009, 04:15 AM posted to microsoft.public.outlook.contacts
Diane Poremsky [MVP]
external usenet poster
 
Posts: 17,338
Default Create distribution list in Outlook from Excel spreadsheet?

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:


EMO - a weekly newsletter about Outlook and Exchange:


You can access this newsgroup by visiting
http://www.microsoft.com/office/comm...s/default.mspx or point your
newsreader to msnews.microsoft.com.


"eriko" wrote in message
...
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


  #14  
Old November 6th, 2009, 02:24 PM posted to microsoft.public.outlook.contacts
Davena
external usenet poster
 
Posts: 1
Default Create distribution list in Outlook from Excel spreadsheet?



"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

  #15  
Old March 16th, 2010, 06:10 PM posted to microsoft.public.outlook.contacts
RKChesnutt
external usenet poster
 
Posts: 4
Default Create distribution list in Outlook from Excel spreadsheet?

I have 2100 addresses in an excel spreadsheet and when I tried to save them
as a csv it would only save one page of information. Any suggestions?

  #16  
Old March 16th, 2010, 07:14 PM posted to microsoft.public.outlook.contacts
Brian Tillman [MVP-Outlook]
external usenet poster
 
Posts: 2,485
Default Create distribution list in Outlook from Excel spreadsheet?

"RKChesnutt" wrote in message
...

I have 2100 addresses in an excel spreadsheet and when I tried to save them
as a csv it would only save one page of information. Any suggestions?


What does this have to do with Outlook?
--
Brian Tillman [MVP-Outlook]

 




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


All times are GMT +1. The time now is 06:02 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.