Hi, Can anybody help me with macros for mass mailing from given list of email id's with select data from data sheet.
Rgds Sanju Kanery On Mon, Nov 14, 2011 at 5:12 AM, <excel-macros@googlegroups.com> wrote: > Today's Topic Summary > > Group: http://groups.google.com/group/excel-macros/topics > > - Listing name of worksheet & renaming > them<#1339f4f3fa0b83ff_group_thread_0>[7 Updates] > - PDF to Excel <#1339f4f3fa0b83ff_group_thread_1> [2 Updates] > - To Set Dropdownlist in Chart <#1339f4f3fa0b83ff_group_thread_2> [5 > Updates] > - Macro-coding required <#1339f4f3fa0b83ff_group_thread_3> [2 Updates] > - Import PDF into Excel <#1339f4f3fa0b83ff_group_thread_4> [2 Updates] > - MS-Excel Hanging <#1339f4f3fa0b83ff_group_thread_5> [1 Update] > - SUM Reg. <#1339f4f3fa0b83ff_group_thread_6> [1 Update] > > Listing name of worksheet & renaming > them<http://groups.google.com/group/excel-macros/t/356e93b2423c28> > > "Amit Desai (MERU)" <amit.de...@merucabs.com> Nov 13 01:36PM +0530 > > Dear Master, > > I have an excel file with sheet names ranging from A to V. However I > want to change its sequence post changing its name. > > Do we have any shortcut? > > Regards, > Amit Desai ...more > > > Aindril De <aind...@gmail.com> Nov 13 02:03PM +0530 > > Pl chk this, > > http://support.microsoft.com/kb/812386 > > Cheers, > Andy > > On Sun, Nov 13, 2011 at 1:36 PM, Amit Desai (MERU) > > -- > ...more > > > "Amit Desai (MERU)" <amit.de...@merucabs.com> Nov 13 02:20PM +0530 > > Thanks.. this helped me in arranging it..but how to list & rename it.. > say..Sheet A to become C, R to become S etc... > > Regards, > Amit Desai > AM - MIS Corporate > Meru Cabs Company Pvt.Ltd > Mumbai ...more > > > Sam Mathai Chacko <samde...@gmail.com> Nov 13 06:28PM +0530 > > Here's how you can do it > > Sub RenameSheetTo() > > Dim lng As Long > For lng = 1 To ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row > ThisWorkbook.Worksheets(Cells(lng, 1).Value).Name = ...more > > > "Amit Desai (MERU)" <amit.de...@merucabs.com> Nov 13 09:34PM +0530 > > Thanks...this helps changing the name of sheet all at once...but..I > need 3 things, > > > 1) List the names of work sheet in one black sheet of the file, > > 2) Change the name of worksheet all ...more > > > Sam Mathai Chacko <samde...@gmail.com> Nov 13 11:01PM +0530 > > Would it be OK if you had to click 3 buttons for that? > > Macro used > > Option Explicit > > Sub GetListOfSheets() > > Dim lng As Long > For lng = 1 To Sheets.Count > If lng <> ...more > > > "Amit Desai (MERU)" <amit.de...@merucabs.com> Nov 14 12:21AM +0530 > > Thanks.. but I am getting some error.. > > While renaming, I am getting an error "500" & some time "out of range". > > > Where should I paste the data for newssheet name? > ...more > > PDF to Excel<http://groups.google.com/group/excel-macros/t/d3cd076d849e3bac> > > sharad jain <jainshar...@gmail.com> Nov 13 09:14PM +0530 > > Hi All, > > I have PDF containing record of more 200 companies and running into 35 > pages into the form of table. > > I am using the free version of PDF. > > Is there any way that I can import the table ...more > > > Sam Mathai Chacko <samde...@gmail.com> Nov 13 09:25PM +0530 > > If it is not for very many pdf files, a converter could be used like > the > one here > > http://www.pdftoexcelonline.com/ > > Regards, > > Sam > > > -- > Sam Mathai Chacko > ...more > > To Set Dropdownlist in > Chart<http://groups.google.com/group/excel-macros/t/2a963bc2c731c963> > > kurikkal padinjarappalla <padinjarappa...@gmail.com> Nov 13 01:07PM > +0300 > > Dear All, > > Could somebody help me by setting a drop down list for creating chart, > as > if I select a particular client name in drop down list it should > appear the > chart of that particular client. > ...more > > > Sam Mathai Chacko <samde...@gmail.com> Nov 13 07:30PM +0530 > > Can be done using named ranges. Hit CTRL+F3 to find out how I named two > dynamic ranges for your data. > > The ClientData for example was made like so.. > ...more > > > "dguillett1" <dguille...@gmail.com> Nov 13 08:35AM -0600 > > See attached > > Don Guillett > SalesAid Software > dguille...@gmail.com > > From: kurikkal padinjarappalla > Sent: Sunday, November 13, 2011 4:07 AM > To: excel-macros@googlegroups.com ...more > > > Sam Mathai Chacko <samde...@gmail.com> Nov 13 08:43PM +0530 > > I'd recommend keeping the method safe by relying only on the source > data. > From that echelon, I'd suggest using COUNTA to pass the column index > in the > VLOOKUP argument, instead of referring to ...more > > > kurikkal padinjarappalla <padinjarappa...@gmail.com> Nov 13 06:30PM > +0300 > > Excellent, > > Thanks you so much both of you, > > I am little confused about Mr.Sam's first solution due to its named > ranges, > its a new knowledge to me, I will try to understand. > > ...more > > Macro-coding > required<http://groups.google.com/group/excel-macros/t/b018c2a5f4992d36> > > santosh subudhi <santoshkumar.subu...@gmail.com> Nov 13 01:36PM +0530 > > Hi Group, > > Please help me with the coding in the attached excel sheet. > > -- > Regards > Santosh > santoshkumar.subu...@gmail.com > ...more > > > Sam Mathai Chacko <samde...@gmail.com> Nov 13 08:04PM +0530 > > Private Sub OptionButton1_Click() > > With ComboBox1 > .List = Sheet1.Range("D9:D11").Value > .ListIndex = 0 > End With > > End Sub > > Private Sub OptionButton2_Click() > ...more > > Import PDF into > Excel<http://groups.google.com/group/excel-macros/t/681fa7caaba12a6e> > > Cab Boose <swch...@gmail.com> Nov 13 08:25PM +1300 > > Hi > > I would like to use the 'File-Open' command in Excel to bring in a pdf > file and have it finish up in .xls format. Is there an add-in to do > this > automatically or a vba way to have it ...more > > > zuhair Abdulhameed <zuhair.abdulham...@gmail.com> Nov 13 01:57AM -0800 > > > Well done > > ...more > > MS-Excel > Hanging<http://groups.google.com/group/excel-macros/t/ac12387944609ece> > > zuhair Abdulhameed <zuhair.abdulham...@gmail.com> Nov 13 01:58AM -0800 > > > My Excel 2011 is stopped always > ...more > > SUM Reg.<http://groups.google.com/group/excel-macros/t/34feee3b69b4e1fb> > > jmothilal <gjmothi...@gmail.com> Nov 13 10:55AM +0530 > > Dear Sam & Don Guillett > > > Thanks for more supports , i learn and understand that commands . > > Thanks with > > Mothilal.J > > > -- > > *J.Mothilal : **Universal Computer Systems : # 16, Brindavan ...more > > You received this message because you are subscribed to the Google Group > excel-macros. > You can post via email <excel-macros@googlegroups.com>. > To unsubscribe from this group, > send<excel-macros+unsubscr...@googlegroups.com>an empty message. > For more options, > visit<http://groups.google.com/group/excel-macros/topics>this group. > > -- > FORUM RULES (934+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > -- Warm Regards Sanju Kanery +91 9871115789 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
