Excel

  • Thread starter Thread starter CBARSTOW
  • Start date Start date
C

CBARSTOW

I have set up a data base using excel. One of the fields
is email addresses. I would like to use those address and
send emails out of outlook. How do I get those email
addresses out of excel and into outlook? Or is that
possible? Should I have set up the data base in access or
should I have just listed the email addresses directly
into outlook?

Help and advice please for this and future data bases.
 
I have set up a data base using excel. One of the fields
is email addresses. I would like to use those address and
send emails out of outlook. How do I get those email
addresses out of excel and into outlook? Or is that
possible? Should I have set up the data base in access or
should I have just listed the email addresses directly
into outlook?
Click to expand...

Two steps:
1. Export the email addresses from Excel into a format that Outlook
recognizes.
2. Use Outlooks' import feature to import the list of email addresses.

However, you probably need to ask in the Outlook groups for how to do this.
 
First have the names and email addresses in Excel in two columns.

I set up also a third column with the names duplicated so when you Import to
Outlook you have a name for the Contact and a Display Name instead of the
email address in the To: box.

File>Save As>File Type CSV(comma delimited)(*.csv)

Now open Outlook and File>Import>Export>Import from another file>Comma
Separated Values(Windows)>Next>File to Import(you can browse to your saved
*.csv file). Next you will be asked where to import them to. I bring mine to
"Contacts".

NOTE: make sure you mark the checkbox with a check at "action to perform".

Follow the instructions and you will get a Map. Drag your names and addresses
to the appropriate spots on the Map

1. Name of Contact
2. Email address1
3. Display Name(if you have one by making the duplicate column mentioned
earlier). If not, the email address wil be displayed in the To: box.

Continue with the OK's until Outlook pulls all from the *.csv file(should take
only a few seconds).

Now they are in the Contacts folder, you can group them as you wish.

Gord Dibben Excel MVP
 
Back
Top