asked on

Sending emails from Outlook using data from Excel

I have an Excel spreadsheet with first name, last name, company name, email address etc. of contacts that I have done business with over the past 5+ years.

Can someone give me instructions how I can use this Excel spreadsheet data to send an email to each of my customers?

Thanks in advance!

David

SOLUTION

Patrick Matthews

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

war1

Greetings, d_springer !

Save copy of the spreadsheet as a CSV file. Import it into Outlook Contacts list. Then send the emails to those contacts addresses.

Best wishes!

d_springer

ASKER

I tried to use Word to mail merge but I couldn't get that to work.

I successfully got the Excel file into my my Outlook Contacts list. I have been trying for 2 hours without any luck to merge my Contacts into an email. Could someone explain this to me step by step?

David

war1

Create a Distribution List with the contacts just imported. Then send to the name of the distribution list.

d_springer

ASKER

I wish that it was that easy for me.

I was able to create a distribution list but I have no clue how to access it.

Can some one go through the specific steps like:

Step 1) Go to ACTION then New Message to Contact
Step 2) .......

I know it is a pain but I am not very MS Office savvy if you haven't noticed :(

Thanks in advance.

David

SOLUTION

robjeeves

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

war1

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

war1

d_springer,

We have not heard from you in awhile. Did any comment help you solve your problem? Do you have any more question? If an Expert helped you, please accept his/her answer above with an excellent or good grade.

Thanks, war1