Need export emails from a worksheet

[fnmasood]

I have a worksheet in which one column is emails. I want to export that column into a word doc, but I need the emails to be separated by commas and I need them to be continuous (not in column). I just learned about macros so I can use them somewhat. Somebody please help!

 

[fnmasood]

Re: Need to export emails from a worksheet

Please can anybody tell me how to do this. I need to get all the emails form an excel worksheet, but some of them are duplicates. I need all the duplicated removed and I need the list (separated by commas) to be saved in a txt file. That way we can just copy and paste the list when we need to send an email out. Please help

 

[jakeman]

I have a worksheet in which one column is emails. I want to export that column into a word doc, but I need the emails to be separated by commas and I need them to be continuous (not in column). I just learned about macros so I can use them somewhat. Somebody please help!

I'm assuming you mean email addresses, right?

Let's also assume the email addresses start in column A, Row2. You could use the concatenate feature...although it could get messy if you have a lot of email addresses. Put a comma in a blank cell somewhere (cell D1 for example) and refer to it in your Concatenate formula, beginning in A2:

=concatenate(A2,D1,A3,D1,A4,D1,A5,D1)

Your bringing the contents of cell A2,A3,A4,A5 together with a comma separating each email address into one continuous string. It's not perfect, but it's something.

 

[fnmasood]

Thanks, but I have over 250 emails. And if we add more people to the worksheet, I will have to keep updating the formula. Can i make a macro where it will run the sequence every time I run the macro?

 

[jakeman]

Thanks, but I have over 250 emails. And if we add more people to the worksheet, I will have to keep updating the formula. Can i make a macro where it will run the sequence every time I run the macro?

Hmmm...can you tell me what it is your are trying to do with all of the email addresses once you get them into Word? Truthfully, your string would be very long with 250 or more emails and I just cannot see the usefulness of one long string of emails with a comma separating them. Just curious.

Yes, I think a macro could be created to accomplish your goal but I would need to spend a few minutes figuring that part out.

 

[shawnhet]

Just as a quick way to use the CONCATENATE formula-

You could use a helper row in the column next to it (using B for an example)

Then assuming A1 is your first email address B1 would have the formula =A1

Then in B2, you would type =CONCATENATE(B1,",",B2), then use the fill feature or copy the formula down the length of the range

The last cell in column B should have your list of emails as you've asked for them, assuming that you do not exceed the maximum number of characters in a cell.

If you add more emails at some point, you can just copy the formula down.

You can then paste the result into Word.

Cheers,

 

[fnmasood]

I am going to give the list of emails to anybody who needs to send an email to the list of people. So I would like to same them in a word doc or text file. Because right now they export all the email then delete the spaces and put the commas in between. Not fun. It is the registration list from my sons Sunday school, and I hardly get the emails, thus I am trying to help them.