Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Say your email list is in column C starting in C1. In D1 enter "=C1"
without the quotes. In D2 enter =D1&","&C2. Drag this formula down as far as your email list goes. The last cell will show all the emails. HTH Otto "ILunacy" wrote in message ... I have a column of email addresses, and I want to combine them all into one cell seperated by commas. I want to make an group email list that I can just copy into an email without having to enter each individual emaill address. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating an email list from a data base | Excel Discussion (Misc queries) | |||
Creating a macro from an email attachment | Excel Discussion (Misc queries) | |||
Creating a hyperlink to email the worksheet | Excel Discussion (Misc queries) | |||
Email worksheet from a list of names and email | Excel Discussion (Misc queries) | |||
creating hyperlinks to email | Excel Discussion (Misc queries) |