Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Email list from Excel

Posted on 2010-08-19
6
Medium Priority
?
369 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 17

Accepted Solution

by:
calacuccia earned 400 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:Ardhendu Sarangi
Ardhendu Sarangi earned 200 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 200 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 4

Assisted Solution

by:abitoun
abitoun earned 200 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

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
The main intent of this article is to make you aware of ‘Exchange fail to mount’ error, its effects, causes, and solution.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

670 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