Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile
Dear Vaibhav Sir, Please suggest what kind of more features are adding to do it more attractive, innovative useful. Kindly suggest. Thanks Regards Ashu Kenith On 7/23/14, Vaibhav Joshi v...@vabs.in wrote: cheers!! Working on adding more features viz. managing attachments etc..will share once done, you can recommend additional features if you want that to be added. On Wed, Jul 23, 2014 at 5:26 PM, Ashu k direct2as...@gmail.com wrote: Dear Vaibhav Sir, Thanks a lot for your valuable support and help. my problem is resolved only b'coz of you. Thanks a ton sir. Thanks Regards Ashu Kenith On 7/23/14, Vaibhav Joshi v...@vabs.in wrote: PFA Reformatted !! Cheers!! On Wed, Jul 23, 2014 at 7:33 AM, Ashu k direct2as...@gmail.com wrote: Dear Vaibhav Sir, I am facing 2 problems know. First is - when I am trying to attach any file and send to someone, it will send 1 more file (0KB) automatically with the attachment. Second problem is - If i click on the attachment logo, the box window will appear and If I have select 2 or 3 or more files in one time, then it will be attached successfully but if i want to attach more files from diffrent locations, like I want to attach 1 file from C drive 1 file from D 1 from E than it will not attached. Kindly help in this regards. Thanks Regards Ashu Kenith On 7/22/14, Vaibhav Joshi v...@vabs.in wrote: Hmn... chek this Cheers!! On Tue, Jul 22, 2014 at 7:25 PM, Ashu k direct2as...@gmail.com wrote: Dear Vaibhav Sir, Sheet is working fine. But, more help required on this. If i attach 1 file than its working fine but If i want to attach more than 1 files than what should i do for it. Kindly help. Thanks Regards Ashu Kenith On 7/22/14, Vaibhav Joshi v...@vabs.in wrote: Check this.. Cheers!! On Tue, Jul 22, 2014 at 3:28 PM, Ashu k direct2as...@gmail.com wrote: Yes Sir, I want when i press button it will show only 1 user form for sending mails. and when i click on attachment logo or link it will open a new box window for choose files for attachment in mail, and the mail body is : Dear Sir, Kindly find attached file Thanks please help in this regards. Thanks Regards Ashu Kenith On 7/22/14, Vaibhav Joshi v...@vabs.in wrote: hi do you want to add additional attachment or replace existing ? On Tue, Jul 22, 2014 at 3:12 PM, Ashu k direct2as...@gmail.com wrote: Dear Vaibhav Sir, Need some more help from your side. Function for attachment is working like actual gmail. Like : when I click on attachment logo or link it will open a box window and ask me for where i want to attach file. Is it possible with the help of VBA. Please help. Thanks Regards Ashu Kenith On 7/21/14, Vaibhav Joshi v...@vabs.in wrote: Pl refer this, done minor changes! Cheers!! On Mon, Jul 21, 2014 at 8:22 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Vaibhav Ji, This sheet is Working better than the first one. Tremendous..!!! Regards Ashish On 21 July 2014 20:03, 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
Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile
Dear Vaibhav Sir, Added BCC funciton is possible in it. Please help. Thanks Regards Ashu Kenith On 7/23/14, Vaibhav Joshi v...@vabs.in wrote: cheers!! Working on adding more features viz. managing attachments etc..will share once done, you can recommend additional features if you want that to be added. On Wed, Jul 23, 2014 at 5:26 PM, Ashu k direct2as...@gmail.com wrote: Dear Vaibhav Sir, Thanks a lot for your valuable support and help. my problem is resolved only b'coz of you. Thanks a ton sir. Thanks Regards Ashu Kenith On 7/23/14, Vaibhav Joshi v...@vabs.in wrote: PFA Reformatted !! Cheers!! On Wed, Jul 23, 2014 at 7:33 AM, Ashu k direct2as...@gmail.com wrote: Dear Vaibhav Sir, I am facing 2 problems know. First is - when I am trying to attach any file and send to someone, it will send 1 more file (0KB) automatically with the attachment. Second problem is - If i click on the attachment logo, the box window will appear and If I have select 2 or 3 or more files in one time, then it will be attached successfully but if i want to attach more files from diffrent locations, like I want to attach 1 file from C drive 1 file from D 1 from E than it will not attached. Kindly help in this regards. Thanks Regards Ashu Kenith On 7/22/14, Vaibhav Joshi v...@vabs.in wrote: Hmn... chek this Cheers!! On Tue, Jul 22, 2014 at 7:25 PM, Ashu k direct2as...@gmail.com wrote: Dear Vaibhav Sir, Sheet is working fine. But, more help required on this. If i attach 1 file than its working fine but If i want to attach more than 1 files than what should i do for it. Kindly help. Thanks Regards Ashu Kenith On 7/22/14, Vaibhav Joshi v...@vabs.in wrote: Check this.. Cheers!! On Tue, Jul 22, 2014 at 3:28 PM, Ashu k direct2as...@gmail.com wrote: Yes Sir, I want when i press button it will show only 1 user form for sending mails. and when i click on attachment logo or link it will open a new box window for choose files for attachment in mail, and the mail body is : Dear Sir, Kindly find attached file Thanks please help in this regards. Thanks Regards Ashu Kenith On 7/22/14, Vaibhav Joshi v...@vabs.in wrote: hi do you want to add additional attachment or replace existing ? On Tue, Jul 22, 2014 at 3:12 PM, Ashu k direct2as...@gmail.com wrote: Dear Vaibhav Sir, Need some more help from your side. Function for attachment is working like actual gmail. Like : when I click on attachment logo or link it will open a box window and ask me for where i want to attach file. Is it possible with the help of VBA. Please help. Thanks Regards Ashu Kenith On 7/21/14, Vaibhav Joshi v...@vabs.in wrote: Pl refer this, done minor changes! Cheers!! On Mon, Jul 21, 2014 at 8:22 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Vaibhav Ji, This sheet is Working better than the first one. Tremendous..!!! Regards Ashish On 21 July 2014 20:03, 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
Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile
Dear Vaibhav Sir, If possible than please add BCC function, Text font function, Text colour function, Bold Italic, Underline etc. If these function are adding in it then it's looks more interactive and useful. Kindly help. Thanks Regards Ashu Kenith On 7/23/14, Ashu k direct2as...@gmail.com wrote: Dear Vaibhav Sir, Added BCC funciton is possible in it. Please help. Thanks Regards Ashu Kenith On 7/23/14, Vaibhav Joshi v...@vabs.in wrote: cheers!! Working on adding more features viz. managing attachments etc..will share once done, you can recommend additional features if you want that to be added. On Wed, Jul 23, 2014 at 5:26 PM, Ashu k direct2as...@gmail.com wrote: Dear Vaibhav Sir, Thanks a lot for your valuable support and help. my problem is resolved only b'coz of you. Thanks a ton sir. Thanks Regards Ashu Kenith On 7/23/14, Vaibhav Joshi v...@vabs.in wrote: PFA Reformatted !! Cheers!! On Wed, Jul 23, 2014 at 7:33 AM, Ashu k direct2as...@gmail.com wrote: Dear Vaibhav Sir, I am facing 2 problems know. First is - when I am trying to attach any file and send to someone, it will send 1 more file (0KB) automatically with the attachment. Second problem is - If i click on the attachment logo, the box window will appear and If I have select 2 or 3 or more files in one time, then it will be attached successfully but if i want to attach more files from diffrent locations, like I want to attach 1 file from C drive 1 file from D 1 from E than it will not attached. Kindly help in this regards. Thanks Regards Ashu Kenith On 7/22/14, Vaibhav Joshi v...@vabs.in wrote: Hmn... chek this Cheers!! On Tue, Jul 22, 2014 at 7:25 PM, Ashu k direct2as...@gmail.com wrote: Dear Vaibhav Sir, Sheet is working fine. But, more help required on this. If i attach 1 file than its working fine but If i want to attach more than 1 files than what should i do for it. Kindly help. Thanks Regards Ashu Kenith On 7/22/14, Vaibhav Joshi v...@vabs.in wrote: Check this.. Cheers!! On Tue, Jul 22, 2014 at 3:28 PM, Ashu k direct2as...@gmail.com wrote: Yes Sir, I want when i press button it will show only 1 user form for sending mails. and when i click on attachment logo or link it will open a new box window for choose files for attachment in mail, and the mail body is : Dear Sir, Kindly find attached file Thanks please help in this regards. Thanks Regards Ashu Kenith On 7/22/14, Vaibhav Joshi v...@vabs.in wrote: hi do you want to add additional attachment or replace existing ? On Tue, Jul 22, 2014 at 3:12 PM, Ashu k direct2as...@gmail.com wrote: Dear Vaibhav Sir, Need some more help from your side. Function for attachment is working like actual gmail. Like : when I click on attachment logo or link it will open a box window and ask me for where i want to attach file. Is it possible with the help of VBA. Please help. Thanks Regards Ashu Kenith On 7/21/14, Vaibhav Joshi v...@vabs.in wrote: Pl refer this, done minor changes! Cheers!! On Mon, Jul 21, 2014 at 8:22 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Vaibhav Ji, This sheet is Working better than the first one. Tremendous..!!! Regards Ashish On 21 July 2014 20:03, 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
Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile
Hi Vaibhav, Reformatted version is great. Regards Ashish On 23 July 2014 11:32, Vaibhav Joshi v...@vabs.in wrote: PFA Reformatted !! Cheers!! On Wed, Jul 23, 2014 at 7:33 AM, Ashu k direct2as...@gmail.com wrote: Dear Vaibhav Sir, I am facing 2 problems know. First is - when I am trying to attach any file and send to someone, it will send 1 more file (0KB) automatically with the attachment. Second problem is - If i click on the attachment logo, the box window will appear and If I have select 2 or 3 or more files in one time, then it will be attached successfully but if i want to attach more files from diffrent locations, like I want to attach 1 file from C drive 1 file from D 1 from E than it will not attached. Kindly help in this regards. Thanks Regards Ashu Kenith On 7/22/14, Vaibhav Joshi v...@vabs.in wrote: Hmn... chek this Cheers!! On Tue, Jul 22, 2014 at 7:25 PM, Ashu k direct2as...@gmail.com wrote: Dear Vaibhav Sir, Sheet is working fine. But, more help required on this. If i attach 1 file than its working fine but If i want to attach more than 1 files than what should i do for it. Kindly help. Thanks Regards Ashu Kenith On 7/22/14, Vaibhav Joshi v...@vabs.in wrote: Check this.. Cheers!! On Tue, Jul 22, 2014 at 3:28 PM, Ashu k direct2as...@gmail.com wrote: Yes Sir, I want when i press button it will show only 1 user form for sending mails. and when i click on attachment logo or link it will open a new box window for choose files for attachment in mail, and the mail body is : Dear Sir, Kindly find attached file Thanks please help in this regards. Thanks Regards Ashu Kenith On 7/22/14, Vaibhav Joshi v...@vabs.in wrote: hi do you want to add additional attachment or replace existing ? On Tue, Jul 22, 2014 at 3:12 PM, Ashu k direct2as...@gmail.com wrote: Dear Vaibhav Sir, Need some more help from your side. Function for attachment is working like actual gmail. Like : when I click on attachment logo or link it will open a box window and ask me for where i want to attach file. Is it possible with the help of VBA. Please help. Thanks Regards Ashu Kenith On 7/21/14, Vaibhav Joshi v...@vabs.in wrote: Pl refer this, done minor changes! Cheers!! On Mon, Jul 21, 2014 at 8:22 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Vaibhav Ji, This sheet is Working better than the first one. Tremendous..!!! Regards Ashish On 21 July 2014 20:03, 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
Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile
Dear Vaibhav Sir, Need some more help from your side. Function for attachment is working like actual gmail. Like : when I click on attachment logo or link it will open a box window and ask me for where i want to attach file. Is it possible with the help of VBA. Please help. Thanks Regards Ashu Kenith On 7/21/14, Vaibhav Joshi v...@vabs.in wrote: Pl refer this, done minor changes! Cheers!! On Mon, Jul 21, 2014 at 8:22 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Vaibhav Ji, This sheet is Working better than the first one. Tremendous..!!! Regards Ashish On 21 July 2014 20:03, 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
Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile
hi do you want to add additional attachment or replace existing ? On Tue, Jul 22, 2014 at 3:12 PM, Ashu k direct2as...@gmail.com wrote: Dear Vaibhav Sir, Need some more help from your side. Function for attachment is working like actual gmail. Like : when I click on attachment logo or link it will open a box window and ask me for where i want to attach file. Is it possible with the help of VBA. Please help. Thanks Regards Ashu Kenith On 7/21/14, Vaibhav Joshi v...@vabs.in wrote: Pl refer this, done minor changes! Cheers!! On Mon, Jul 21, 2014 at 8:22 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Vaibhav Ji, This sheet is Working better than the first one. Tremendous..!!! Regards Ashish On 21 July 2014 20:03, 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
Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile
Cheers Ashish Kumar ji!! On Mon, Jul 21, 2014 at 10:21 AM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Vaibhav, Its Great buddy. Regards Ashish On 19 July 2014 22:02, Vaibhav Joshi v...@vabs.in wrote: 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.
Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile
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
Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile
Hi Vaibhav Ji, This sheet is Working better than the first one. Tremendous..!!! Regards Ashish On 21 July 2014 20:03, 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
Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile
Hi Vaibhav, Its Great buddy. Regards Ashish On 19 July 2014 22:02, Vaibhav Joshi v...@vabs.in wrote: 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.