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 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. >> >> >> > >> > -- >> > 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.
