----------------------------------------------------------------------------------------------------------- -----------------------------------------------------------------------------------------------------------
Hi, However, Gmail, Yahoo and Hotmail automatically does this task. So Solution 1 is: 1. Copy upto 500(Gmail), 100(Yahoo) and 50(Hotmail) rows of column depending on desired application. 2. Paste it in To,CC or BCC section of email application. 3. Go to Body area of mail application. It would have automatically done that. But if you're using old versions of these mail application or some other mail application, you need to manually do the task. So Solution 2 is: Assumption: Your 10,000 email id are in this range - A1 to A10000. 1. Go to cell B2 and type the formula = B1 & "," & A2 & "," 2. Select The Range B2 to B10001. 3. Press Ctrl + D. (Use to fill series with formula) 4. Select the Range B2 to B10001. Right click on it and select Copy. 5. Right click on Cell B2 or C2. Select Paste Special. 6. Select Values. Click Ok. 7. You're done. P.S. - Sending mail to this much amount of users using these mail client applications can tag you as spammer. For more tips, tricks, downloads and problem solutions: visit --> http://www.excelitems.com ------------------------------------------------------------------------ Regards Ashish Jain Analyst and Demand-Co-ordinator, CSC Australia Microsoft Certified Application (Excel) Specialist Technical Trainer - Excel and VBA Author -> www.excelitems.com 09999-40-48-43 ----------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------- On Feb 24, 5:53 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 --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
