If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
excell spreadsheet
I am attempting to take a spreadshhet of email address a1-a1350 and make them
one string of addresses in the same cell to send out a mass email. Is there a formula that I can enter to do this all at once or am I going to have to do them one at a time |
#2
|
|||
|
|||
excell spreadsheet
See Ron de Bruin's site for code to send an email to every valid email
address in a range. http://www.rondebruin.nl/mail/folder3/message.htm No need to put all the addresses in one cell. Gord Dibben MS Excel MVP On Wed, 11 Mar 2009 14:47:01 -0700, spenlc wrote: I am attempting to take a spreadshhet of email address a1-a1350 and make them one string of addresses in the same cell to send out a mass email. Is there a formula that I can enter to do this all at once or am I going to have to do them one at a time |
#3
|
|||
|
|||
excell spreadsheet
Hi,
My concern is trying to concatenate 1300 email addresses, it may just be too long. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "spenlc" wrote: I am attempting to take a spreadshhet of email address a1-a1350 and make them one string of addresses in the same cell to send out a mass email. Is there a formula that I can enter to do this all at once or am I going to have to do them one at a time |
#4
|
|||
|
|||
excell spreadsheet
Hi! Try this
Function ConcVertical(rng As Range, joinStr As String) As String ConcVertical = _ Join(Evaluate("transpose(" & rng.Address(, , , True) & ")"), joinStr) & "." End Function Put in B2 =concvertical(A1:a1350) "spenlc" wrote: I am attempting to take a spreadshhet of email address a1-a1350 and make them one string of addresses in the same cell to send out a mass email. Is there a formula that I can enter to do this all at once or am I going to have to do them one at a time |
Thread Tools | |
Display Modes | |
|
|