suppose you have email id in A column starting from A2 in B2 type =B2 and in B3 type = B2 & ", " & A3
Then drag it till the cell where you have email addresses. in the last cell you will get emailid1, emailid2.... and so on. copy text in last cell and paste in notepad or use copy paste value option in MS Excel Regards, MS Excel help <http://findsarfaraz.blogspot.com/> On Tue, Feb 24, 2009 at 6:23 PM, amit arora <amit.aur...@gmail.com> wrote: > Dear All > > I have excel file with 10,000 email id in one column. I want to send mail > to all of these. i have to put , or ; at every email id so that it could be > send to all. How can i do it > > pl tell help me -. > > regards > > > > -- > Amit Arora > > > > -- Thanks with regards, Sarfaraz Ahmed --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
