Dear Vaibhav Sir, Working Fine.
Thanks Ashu Kenith On 7/21/14, Vaibhav Joshi <v...@vabs.in> wrote: > Hi > > Check this, i have added Ok button in First form, only after pressing Ok > now form 2 will appear & also added check box in front of cc button to keep > & remove cc. > > Thanks > > > On Mon, Jul 21, 2014 at 5:45 PM, Ashu k <direct2as...@gmail.com> wrote: > >> Dear Vaibhav Sir, >> >> Code is working great. But, I am facing 2 problems with that. >> >> First is - that's not working when i don't place email id in CC. If >> i don't want to send carbon copy to someone than what to do. >> >> Second is - when i select the city name from the drop box, it will >> capture and send all the data. >> >> Ex. - If i select chennai than only capture the chennai data in excel >> sheet and send it. >> >> please help in this regards. >> >> Thanks >> Ashu Kenith >> >> >> > ---------- Forwarded message ---------- >> > From: Vaibhav Joshi <v...@vabs.in> >> > Date: 19 July 2014 22:02 >> > Subject: Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile >> > To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> >> > >> > >> > Check this.. >> > >> > Cheers!! >> > >> > >> > On Sat, Jul 19, 2014 at 2:32 PM, Vijay <vijaymailsi...@gmail.com> >> > wrote: >> > >> >> Dear Team, >> >> >> >> >> >> Please Help on this to Solve this Problem !!! >> >> >> >> >> >> Regards, >> >> >> >> Vijayakumar R >> >> >> >> On Monday, July 14, 2014 3:46:45 PM UTC+5:30, Vijay wrote: >> >> >> >>> Dear Team, >> >>> >> >>> need your help to solve this problem !!! >> >>> >> >>> >> >>> 1) PFA, attached File already done by this Team, but require some >> >>> more >> >>> query to be rectify >> >>> >> >>> >> >>> 2) This file Start Button having in ( Br ) Column, require once press >> >>> the >> >>> start button, branch name based File should >> >>> >> >>> be Split only the same Branch like ( If i select Chennai means >> >>> splited >> >>> file branch name should be available only >> >>> >> >>> Chennai branch pertains to data ) and file also attached based on the >> >>> Branch name pertains to Branch Email ID. >> >>> >> >>> 3) No need the start button to press the file, Run through only in >> Macro >> >>> and Splited file this start button wont >> >>> >> >>> appear. >> >>> >> >>> Thanks in Advance. >> >>> >> >>> Regard, >> >>> >> >>> Vijay >> >>> >> >>> >> >>> >> >> -- >> >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >> It's >> >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> >> https://www.facebook.com/discussexcel >> >> >> >> FORUM RULES >> >> >> >> 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) Jobs posting is not allowed. >> >> 6) Sharing copyrighted material and their links is not allowed. >> >> >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners >> >> and >> >> members are not responsible for any loss. >> >> --- >> >> You received this message because you are subscribed to the Google >> Groups >> >> "MS EXCEL AND VBA MACROS" group. >> >> To unsubscribe from this group and stop receiving emails from it, send >> an >> >> email to excel-macros+unsubscr...@googlegroups.com. >> >> To post to this group, send email to excel-macros@googlegroups.com. >> >> Visit this group at http://groups.google.com/group/excel-macros. >> >> For more options, visit https://groups.google.com/d/optout. >> >> >> > >> > -- >> > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >> > It's >> > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> > https://www.facebook.com/discussexcel >> > >> > FORUM RULES >> > >> > 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) Jobs posting is not allowed. >> > 6) Sharing copyrighted material and their links is not allowed. >> > >> > NOTE : Don't ever post confidential data in a workbook. Forum owners >> > and >> > members are not responsible for any loss. >> > --- >> > You received this message because you are subscribed to the Google >> > Groups >> > "MS EXCEL AND VBA MACROS" group. >> > To unsubscribe from this group and stop receiving emails from it, send >> > an >> > email to excel-macros+unsubscr...@googlegroups.com. >> > To post to this group, send email to excel-macros@googlegroups.com. >> > Visit this group at http://groups.google.com/group/excel-macros. >> > For more options, visit https://groups.google.com/d/optout. >> > >> > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 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) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.