Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I have an excel sheet which has approximately 2000 Rows. The columns are First Name ,Second Name, email 1, email 2

I want to be able to use all these contacts in one go in gmail in following format

<First Person>email@gmail.com,<Second Person>email@gmail.com,<Third Person>email@gmail.com,..... and so on

I use web based gmail and outlook etc email clients are not allowed so I would be doing a bcc in above format.I downloaded all my contacts but I am not sure as how to convert them in above kind of format i.e. including <> by combining first name,second name and email then , with the contact and organizing them into above format.What application can help me or what exactly should I be doing to ease my work? I am using Libre office and Ubuntu 11.10

share|improve this question
add comment

3 Answers

The way you've stated it, that this is not a FORMATTING problem: you need to use a FORMULA to combine the data you have into a new data-value, in a new cell.

The nice thing about using a spreadsheet for this is that it's dynamic: if your source data changes, your derived data changes at the same time.

However as others have stated, the gmail anti-spam limits mean that your proposed solution (gmail) won't work if you try to email all 2000 addresses on the same day.

share|improve this answer
    
+1 for the daily limit –  mhoran_psprep Mar 1 '12 at 13:46
add comment

You don't have to create in one go the whole string because some clients have limitations regarding the number of recipients. You can simply create the desired format for each row and then select the ones that you want and paste them in client's field for BCC. You don't have to worry about the fact that you're copying cells instead of the string, because when you're going to paste it the only thing that will be pasted is the text from all of them.

For each row add something like that:

 =CONCATENATE(A2, " ", B2, " <", C2, ">, ")

You could also use the JOIN or CONCATENATE function to specify predefined groups to have the final string in a separate cell.

 =CONCATENATE(D2:D100)

In that example I assume that you're using the shown format, with the trailing comma and space for easier copy directly from the cells.

share|improve this answer
    
I also changed to format a bit, I have the email within the <>, because that's usually how they are being formatted –  Lipis Mar 1 '12 at 11:25
1  
+1 for the last comma in the CONCATENATE part, it is need to string them all together when you paste them. –  mhoran_psprep Mar 1 '12 at 13:47
add comment

You could do this with a formula in LibreOffice with some concatenation, something like:

="<" & A1 & " " & A2 & "> " & A3 & "," & "<" & A1 & " " & A2 & "> " & A4

Yet, it wouldn't work because you have a daily 500 recipients limit in Gmail - see Gmail Help for more information.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.