Avatar of d_springer
d_springer
 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

Outlook

Avatar of undefined
Last Comment
war1

8/22/2022 - Mon
SOLUTION
Patrick Matthews

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
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.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
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

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER CERTIFIED SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
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