Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

EMAIL QUESTION

  Asked By: Bing    Date: Jan 27    Category: MS Office    Views: 600
  

I am an absolute newbie when it comes to using excel. My computer life
has been spent in graphics. Here is my question. I have been sent an
Excel file with about 500 names with email addresses. Is there a way to
create in either Outlook or Outlook Express an email group dreectly from
excel without copying and pasting every email address by hand?

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Pam Harrison     Answered On: Jan 27

You will notice in Outlook that you can export the current address book
to a text file. If you analyse this file, you will notice that it is in
a simple database format.

Once you have done this, you can then experiment with importing data
from an Excel file  into Outlook. Setting up your mailing group after
that should be quite easy.

Just before you import, though, perhaps you should consider in what
format your Excel data should be in to make it Outlook Import friendly.
Per haps, First name, Surname, Email Address would be an appropriate
structure.

 
Answer #2    Answered By: Shannon Hughes     Answered On: Jan 27

Also, on one of the import screens is a button labeled "Map Custom Fields"
that will allow you to specify what Excel column name goes with which
Outlook contact field. Outlook takes an initial guess and if you used the
same names created when exporting the Outlook addresses, there should be
nothing to do unless there is a special Excel column.

 
Didn't find what you were looking for? Find more on EMAIL QUESTION Or get search suggestion and latest updates.




Tagged: