distribution list from excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Outlook 2003 and would like to create a distribution list by
importing email addresses from an Excel spreadsheet. I have followed the
directions for importing, but it won't work. I get a message that says it
can't complete the import. Am I going about this incorrectly?

thank you
 
Probably.
Since you failed to tell us what you are doing, it's rather hard for anyone
to know.
 
Really don't want to tell us anything do you?
That method works fine. We would have no way of knowing what you did wrong
without your telling us what you did and what happened.
This method will import into your Contacts. You cannot import directly into
a DL.
 
I am trying to create a distribution list by importing email addresses into
Microsoft Outlook 2003. I have an Excel spreadsheet that has 154 email
addresses listed in column A. Cell A1 is titled "email addresses". There is
no other data in the spreadsheet. I follow the directions, step by step,
exactly as described on the MS Office website sited earlier:
http://office.microsoft.com/en-us/assistance/HA010964231033.aspx

and try to import to either my contacts folder or to a sub folder of the
contact folder. Each time, a window titled "Import and Export Progress" opens
and the progress bar fills with green rectangles. After several seconds, a
second window then opens that reads: "Microsoft Office Outlook has
encountered a problem and needs to close. We are sorry for the inconvenience.
If you were in the middle of something, the information you were working on
might be lost." Restart Microsoft Office Outlook is checked off. It also give
me the option to send a report to Microsoft. I have restarted Microsoft
Office Outlook and repeated the procedure several times. I have also repeated
the entire procedure after restarting the computer. I have also tried
repeating the procedure after closing all other programs on the computer.
Computer has 512 MB RAM.

Russ Valentine said:
Really don't want to tell us anything do you?
That method works fine. We would have no way of knowing what you did wrong
without your telling us what you did and what happened.
This method will import into your Contacts. You cannot import directly into
a DL.
--
Russ Valentine
[MVP-Outlook]
Leslie said:
I followed the directions titled "Import contacts from Excel to Outlook"
http://office.microsoft.com/en-us/assistance/HA010964231033.aspx
Click to expand...
Click to expand...
 
You mean you are trying to import a spreadsheet that has only one field?
You would need a minimum of 2 fields to create a Contact Record: a name must
be associated with an email address to create a Contact.
--
Russ Valentine
[MVP-Outlook]
Leslie said:
I am trying to create a distribution list by importing email addresses into
Microsoft Outlook 2003. I have an Excel spreadsheet that has 154 email
addresses listed in column A. Cell A1 is titled "email addresses". There
is
no other data in the spreadsheet. I follow the directions, step by step,
exactly as described on the MS Office website sited earlier:
http://office.microsoft.com/en-us/assistance/HA010964231033.aspx

and try to import to either my contacts folder or to a sub folder of the
contact folder. Each time, a window titled "Import and Export Progress"
opens
and the progress bar fills with green rectangles. After several seconds, a
second window then opens that reads: "Microsoft Office Outlook has
encountered a problem and needs to close. We are sorry for the
inconvenience.
If you were in the middle of something, the information you were working
on
might be lost." Restart Microsoft Office Outlook is checked off. It also
give
me the option to send a report to Microsoft. I have restarted Microsoft
Office Outlook and repeated the procedure several times. I have also
repeated
the entire procedure after restarting the computer. I have also tried
repeating the procedure after closing all other programs on the computer.
Computer has 512 MB RAM.

Russ Valentine said:
Really don't want to tell us anything do you?
That method works fine. We would have no way of knowing what you did
wrong
without your telling us what you did and what happened.
This method will import into your Contacts. You cannot import directly
into
a DL.
--
Russ Valentine
[MVP-Outlook]
Leslie said:
I followed the directions titled "Import contacts from Excel to Outlook"
http://office.microsoft.com/en-us/assistance/HA010964231033.aspx
Click to expand...
Click to expand...
Click to expand...
 
I did not realize I had to have more than one field. I do not have names,
just email addresses (this is a business leads list). What do you suggest?
Can I add a fake name? Can it be the same for each email address? Do I need
first name and last name or is one name sufficient?
Thank you.

Russ Valentine said:
You mean you are trying to import a spreadsheet that has only one field?
You would need a minimum of 2 fields to create a Contact Record: a name must
be associated with an email address to create a Contact.
--
Russ Valentine
[MVP-Outlook]
Leslie said:
I am trying to create a distribution list by importing email addresses into
Microsoft Outlook 2003. I have an Excel spreadsheet that has 154 email
addresses listed in column A. Cell A1 is titled "email addresses". There
is
no other data in the spreadsheet. I follow the directions, step by step,
exactly as described on the MS Office website sited earlier:
http://office.microsoft.com/en-us/assistance/HA010964231033.aspx

and try to import to either my contacts folder or to a sub folder of the
contact folder. Each time, a window titled "Import and Export Progress"
opens
and the progress bar fills with green rectangles. After several seconds, a
second window then opens that reads: "Microsoft Office Outlook has
encountered a problem and needs to close. We are sorry for the
inconvenience.
If you were in the middle of something, the information you were working
on
might be lost." Restart Microsoft Office Outlook is checked off. It also
give
me the option to send a report to Microsoft. I have restarted Microsoft
Office Outlook and repeated the procedure several times. I have also
repeated
the entire procedure after restarting the computer. I have also tried
repeating the procedure after closing all other programs on the computer.
Computer has 512 MB RAM.

Russ Valentine said:
Really don't want to tell us anything do you?
That method works fine. We would have no way of knowing what you did
wrong
without your telling us what you did and what happened.
This method will import into your Contacts. You cannot import directly
into
a DL.
--
Russ Valentine
[MVP-Outlook]
I followed the directions titled "Import contacts from Excel to Outlook"
http://office.microsoft.com/en-us/assistance/HA010964231033.aspx
Click to expand...
Click to expand...
Click to expand...
 
If I were you I'd go a different route. DL's are not very robust or reliable
anyway.
Why not use a mail merge and just use your spreadsheet as a data source for
the merge?
--
Russ Valentine
[MVP-Outlook]
Leslie said:
I did not realize I had to have more than one field. I do not have names,
just email addresses (this is a business leads list). What do you suggest?
Can I add a fake name? Can it be the same for each email address? Do I
need
first name and last name or is one name sufficient?
Thank you.

Russ Valentine said:
You mean you are trying to import a spreadsheet that has only one field?
You would need a minimum of 2 fields to create a Contact Record: a name
must
be associated with an email address to create a Contact.
--
Russ Valentine
[MVP-Outlook]
Leslie said:
I am trying to create a distribution list by importing email addresses
into
Microsoft Outlook 2003. I have an Excel spreadsheet that has 154 email
addresses listed in column A. Cell A1 is titled "email addresses".
There
is
no other data in the spreadsheet. I follow the directions, step by
step,
exactly as described on the MS Office website sited earlier:
http://office.microsoft.com/en-us/assistance/HA010964231033.aspx

and try to import to either my contacts folder or to a sub folder of
the
contact folder. Each time, a window titled "Import and Export Progress"
opens
and the progress bar fills with green rectangles. After several
seconds, a
second window then opens that reads: "Microsoft Office Outlook has
encountered a problem and needs to close. We are sorry for the
inconvenience.
If you were in the middle of something, the information you were
working
on
might be lost." Restart Microsoft Office Outlook is checked off. It
also
give
me the option to send a report to Microsoft. I have restarted Microsoft
Office Outlook and repeated the procedure several times. I have also
repeated
the entire procedure after restarting the computer. I have also tried
repeating the procedure after closing all other programs on the
computer.
Computer has 512 MB RAM.

:

Really don't want to tell us anything do you?
That method works fine. We would have no way of knowing what you did
wrong
without your telling us what you did and what happened.
This method will import into your Contacts. You cannot import directly
into
a DL.
--
Russ Valentine
[MVP-Outlook]
I followed the directions titled "Import contacts from Excel to
Outlook"
http://office.microsoft.com/en-us/assistance/HA010964231033.aspx
Click to expand...
Click to expand...
Click to expand...
 
That sounds like a fine idea, but I can't find directions on how to do
that..only directions for a merge for printed mailing. Can you point me in
the right direction?
Thank you

Russ Valentine said:
If I were you I'd go a different route. DL's are not very robust or reliable
anyway.
Why not use a mail merge and just use your spreadsheet as a data source for
the merge?
--
Russ Valentine
[MVP-Outlook]
Leslie said:
I did not realize I had to have more than one field. I do not have names,
just email addresses (this is a business leads list). What do you suggest?
Can I add a fake name? Can it be the same for each email address? Do I
need
first name and last name or is one name sufficient?
Thank you.

Russ Valentine said:
You mean you are trying to import a spreadsheet that has only one field?
You would need a minimum of 2 fields to create a Contact Record: a name
must
be associated with an email address to create a Contact.
--
Russ Valentine
[MVP-Outlook]
I am trying to create a distribution list by importing email addresses
into
Microsoft Outlook 2003. I have an Excel spreadsheet that has 154 email
addresses listed in column A. Cell A1 is titled "email addresses".
There
is
no other data in the spreadsheet. I follow the directions, step by
step,
exactly as described on the MS Office website sited earlier:
http://office.microsoft.com/en-us/assistance/HA010964231033.aspx

and try to import to either my contacts folder or to a sub folder of
the
contact folder. Each time, a window titled "Import and Export Progress"
opens
and the progress bar fills with green rectangles. After several
seconds, a
second window then opens that reads: "Microsoft Office Outlook has
encountered a problem and needs to close. We are sorry for the
inconvenience.
If you were in the middle of something, the information you were
working
on
might be lost." Restart Microsoft Office Outlook is checked off. It
also
give
me the option to send a report to Microsoft. I have restarted Microsoft
Office Outlook and repeated the procedure several times. I have also
repeated
the entire procedure after restarting the computer. I have also tried
repeating the procedure after closing all other programs on the
computer.
Computer has 512 MB RAM.

:

Really don't want to tell us anything do you?
That method works fine. We would have no way of knowing what you did
wrong
without your telling us what you did and what happened.
This method will import into your Contacts. You cannot import directly
into
a DL.
--
Russ Valentine
[MVP-Outlook]
I followed the directions titled "Import contacts from Excel to
Outlook"
http://office.microsoft.com/en-us/assistance/HA010964231033.aspx
Click to expand...
Click to expand...
Click to expand...
 
Outlook uses Word for performing mail merge functions such as email merges.
For an overview of these functions take a look here:
http://www.slipstick.com/contacts/printlabel.htm
http://www.outlook-tips.net/howto/mailmerge.htm

--
Russ Valentine
[MVP-Outlook]
Leslie said:
That sounds like a fine idea, but I can't find directions on how to do
that..only directions for a merge for printed mailing. Can you point me in
the right direction?
Thank you

Russ Valentine said:
If I were you I'd go a different route. DL's are not very robust or
reliable
anyway.
Why not use a mail merge and just use your spreadsheet as a data source
for
the merge?
--
Russ Valentine
[MVP-Outlook]
Leslie said:
I did not realize I had to have more than one field. I do not have
names,
just email addresses (this is a business leads list). What do you
suggest?
Can I add a fake name? Can it be the same for each email address? Do I
need
first name and last name or is one name sufficient?
Thank you.

:

You mean you are trying to import a spreadsheet that has only one
field?
You would need a minimum of 2 fields to create a Contact Record: a
name
must
be associated with an email address to create a Contact.
--
Russ Valentine
[MVP-Outlook]
I am trying to create a distribution list by importing email
addresses
into
Microsoft Outlook 2003. I have an Excel spreadsheet that has 154
email
addresses listed in column A. Cell A1 is titled "email addresses".
There
is
no other data in the spreadsheet. I follow the directions, step by
step,
exactly as described on the MS Office website sited earlier:
http://office.microsoft.com/en-us/assistance/HA010964231033.aspx

and try to import to either my contacts folder or to a sub folder of
the
contact folder. Each time, a window titled "Import and Export
Progress"
opens
and the progress bar fills with green rectangles. After several
seconds, a
second window then opens that reads: "Microsoft Office Outlook has
encountered a problem and needs to close. We are sorry for the
inconvenience.
If you were in the middle of something, the information you were
working
on
might be lost." Restart Microsoft Office Outlook is checked off. It
also
give
me the option to send a report to Microsoft. I have restarted
Microsoft
Office Outlook and repeated the procedure several times. I have also
repeated
the entire procedure after restarting the computer. I have also
tried
repeating the procedure after closing all other programs on the
computer.
Computer has 512 MB RAM.

:

Really don't want to tell us anything do you?
That method works fine. We would have no way of knowing what you
did
wrong
without your telling us what you did and what happened.
This method will import into your Contacts. You cannot import
directly
into
a DL.
--
Russ Valentine
[MVP-Outlook]
I followed the directions titled "Import contacts from Excel to
Outlook"
http://office.microsoft.com/en-us/assistance/HA010964231033.aspx
Click to expand...
Click to expand...
Click to expand...
 
Back
Top