Link to home
Create AccountLog in
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

SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
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!
Avatar of d_springer
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
Create a Distribution List with the contacts just imported.  Then send to the name of the distribution list.
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
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
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