Solved

Email list from Excel

Posted on 2010-08-19
6
360 Views
Last Modified: 2013-12-18
Hello Experts

I had a client throw me a curveball today.  They have a list of email addresses in a single column in Excel they are trying to import into Yahoo so they can send a mass mailing to clients.  We've tried just copying and pasting, but it doesn't put commas in between addresses, so we get an error telling me that there are addresses that are not in a valid format.

Does anyone have a way to get these addresses into Yahoo?

Thanks much
0
Comment
Question by:Ray Drummond
6 Comments
 
LVL 17

Accepted Solution

by:
calacuccia earned 100 total points
ID: 33477941
A simple solution which might work:

Put a formula in the column next to the email addresses column (image first cell of column is A1)

=A1 & ";"

(Use the right delimiter, for me it's point-comma)

Copy this formula down for the entire column.

Copy the column & paste it into the address bar for the Yahoo mail system

0
 
LVL 20

Assisted Solution

by:pari123
pari123 earned 50 total points
ID: 33477962
Hi Ray,
Try using this formula in your excel file and see if that helps? See attached file.

Take the last row value and paste it into Yahoo.

- Rgds,
Ardhendu
Formula.xls
0
 
LVL 13

Assisted Solution

by:MWGainesJR
MWGainesJR earned 50 total points
ID: 33478036
Why not just send the emails right there in excel?

Could actually be a great mass emailing tool to market to them.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 4

Assisted Solution

by:abitoun
abitoun earned 50 total points
ID: 33478086
If you want to copy and paste try:
First instance formula: =+a2&","
second and subsequent rows: =+b2&a3&","

copy the last row as it will have all the addresses separated by commas.
0
 

Author Comment

by:Ray Drummond
ID: 33486858
Thanks for the replies.  The user isn't available right now, but just wanted to acknowledge the answers.
0
 

Author Closing Comment

by:Ray Drummond
ID: 33661698
I gave everyone some points.  All the info was very helpful.  Thanks much guys.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now