Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Email to list sat up in Excel
I have entered about 500 email addresses into Excel spread sheet, how do I
merge these into a email so I can send this out in groups of 50? I know they have to be separated with commas but I do not remember how to do this. Please give step by step I am very slow with a computer Thank you Linda |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Email to list sat up in Excel
Assuming that your first e-mail address is in cell B2, type the formula in
cell C2: = A2 & ", " Copy this formula down your range up to cell C501 or sos. Now, column C contains e-mail addresses followed by a comma, and you can "take" them 50 by 50 with a mouse selection, copy and paste in your e-mail address bar. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Email to list sat up in Excel
Stephane thank you very much for helping me with this question.
Linda "Stephane Quenson" wrote: Assuming that your first e-mail address is in cell B2, type the formula in cell C2: = A2 & ", " Copy this formula down your range up to cell C501 or sos. Now, column C contains e-mail addresses followed by a comma, and you can "take" them 50 by 50 with a mouse selection, copy and paste in your e-mail address bar. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Email to list sat up in Excel
Stephane, this worked perfectly when I used this formula in July. However I
am encountering problems using this same formula. please let me know if my email address is in e2, would the formula not be =e2 & "." I do not know why you said to use A2 in the formula listed below. Can you let meknow. "Stephane Quenson" wrote: Assuming that your first e-mail address is in cell B2, type the formula in cell C2: = A2 & ", " Copy this formula down your range up to cell C501 or sos. Now, column C contains e-mail addresses followed by a comma, and you can "take" them 50 by 50 with a mouse selection, copy and paste in your e-mail address bar. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to send email to a list of people in excel sheet? | Excel Discussion (Misc queries) | |||
Email worksheet from a list of names and email | Excel Discussion (Misc queries) | |||
how do you turn an email address list into an Excel csv or txt file? | Excel Worksheet Functions | |||
In XP how do I merge Word doc with Excel list and email? | New Users to Excel | |||
Need help cleaning up an email list in Excel | Excel Discussion (Misc queries) |