Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile
Hi Vaibhav, Reformatted version is great. Regards Ashish On 23 July 2014 11:32, Vaibhav Joshi wrote: > PFA > > Reformatted !! > > Cheers!! > > > On Wed, Jul 23, 2014 at 7:33 AM, Ashu k 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 wrote: >> > Hmn... chek this >> > >> > >> > Cheers!! >> > >> > >> > On Tue, Jul 22, 2014 at 7:25 PM, Ashu k 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 wrote: >> >> > Check this.. >> >> > >> >> > Cheers!! >> >> > >> >> > >> >> > On Tue, Jul 22, 2014 at 3:28 PM, Ashu k >> 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 wrote: >> >> >> > hi >> >> >> > >> >> >> > do you want to add additional attachment or replace existing ? >> >> >> > >> >> >> > >> >> >> > On Tue, Jul 22, 2014 at 3:12 PM, Ashu k >> >> 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 wrote: >> >> >> >> > Pl refer this, done minor changes! >> >> >> >> > >> >> >> >> > Cheers!! >> >> >> >> > >> >> >> >> > >> >> >> >> > On Mon, Jul 21, 2014 at 8:22 PM, Ashish Kumar >> >> >> >> > > >> >> >> > >> >> >> >> > wrote: >> >> >> >> > >> >> >> >> >> Hi Vaibhav Ji, >> >> >> >> >> >> >> >> >> >> This sheet is Working better than the first one. >> >> >> >> >> >> >> >> >> >> Tremendous..!!! >> >> >> >> >> >> >> >> >> >> >> >> >> &
Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile
n 7/22/14, Vaibhav Joshi wrote: >>> >> >> >> > hi >>> >> >> >> > >>> >> >> >> > do you want to add additional attachment or replace existing >>> >> >> >> > ? >>> >> >> >> > >>> >> >> >> > >>> >> >> >> > On Tue, Jul 22, 2014 at 3:12 PM, Ashu k >>> >> >> >> > >> > >>> >> >> 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 wrote: >>> >> >> >> >> > Pl refer this, done minor changes! >>> >> >> >> >> > >>> >> >> >> >> > Cheers!! >>> >> >> >> >> > >>> >> >> >> >> > >>> >> >> >> >> > On Mon, Jul 21, 2014 at 8:22 PM, Ashish Kumar >>> >> >> >> >> > >> >> >> >> >> > >>> >> >> >> >> > wrote: >>> >> >> >> >> > >>> >> >> >> >> >> Hi Vaibhav Ji, >>> >> >> >> >> >> >>> >> >> >> >> >> This sheet is Working better than the first one. >>> >> >> >> >> >> >>> >> >> >> >> >> Tremendous..!!! >>> >> >> >> >> >> >>> >> >> >> >> >> >>> >> >> >> >> >> Regards >>> >> >> >> >> >> Ashish >>> >> >> >> >> >> >>> >> >> >> >> >> >>> >> >> >> >> >> On 21 July 2014 20:03, Vaibhav Joshi 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 >>> >> >> >> >> >>> >>> >> >> >> >> wrote: >>> >> >> >> >> >>> >>> >> >> >> >> >>>> Dear Vaibhav Sir, >>> >> >> >> >> >>>> >>> >> >> >> >> >>>> Code is working great. But, I a
Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile
unction 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 wrote: >> >> >> >> >> > Pl refer this, done minor changes! >> >> >> >> >> > >> >> >> >> >> > Cheers!! >> >> >> >> >> > >> >> >> >> >> > >> >> >> >> >> > On Mon, Jul 21, 2014 at 8:22 PM, Ashish Kumar >> >> >> >> >> > > >> >> >> >> > >> >> >> >> >> > wrote: >> >> >> >> >> > >> >> >> >> >> >> Hi Vaibhav Ji, >> >> >> >> >> >> >> >> >> >> >> >> This sheet is Working better than the first one. >> >> >> >> >> >> >> >> >> >> >> >> Tremendous..!!! >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> Regards >> >> >> >> >> >> Ashish >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> On 21 July 2014 20:03, Vaibhav Joshi 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 >> >> >> >> >> >>> >> >> >> >> >> 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. >> >> >> >> >> >>>> >> >> >> >
Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile
;> >> >> >> >> >> >> >> >> 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 wrote: >> >> >> >> >> > Pl refer this, done minor changes! >> >> >> >> >> > >> >> >> >> >> > Cheers!! >> >> >> >> >> > >> >> >> >> >> > >> >> >> >> >> > On Mon, Jul 21, 2014 at 8:22 PM, Ashish Kumar >> >> >> >> >> > > >> >> >> >> > >> >> >> >> >> > wrote: >> >> >> >> >> > >> >> >> >> >> >> Hi Vaibhav Ji, >> >> >> >> >> >> >> >> >> >> >> >> This sheet is Working better than the first one. >> >> >> >> >> >> >> >> >> >> >> >> Tremendous..!!! >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> Regards >> >> >> >> >> >> Ashish >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> On 21 July 2014 20:03, Vaibhav Joshi 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 >> >> >> >> >> >>> >> >> >> >> >> 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. >> >> &
Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile
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 wrote: > PFA > > Reformatted !! > > Cheers!! > > > On Wed, Jul 23, 2014 at 7:33 AM, Ashu k 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 wrote: >> > Hmn... chek this >> > >> > >> > Cheers!! >> > >> > >> > On Tue, Jul 22, 2014 at 7:25 PM, Ashu k 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 wrote: >> >> > Check this.. >> >> > >> >> > Cheers!! >> >> > >> >> > >> >> > On Tue, Jul 22, 2014 at 3:28 PM, Ashu k >> 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 wrote: >> >> >> > hi >> >> >> > >> >> >> > do you want to add additional attachment or replace existing ? >> >> >> > >> >> >> > >> >> >> > On Tue, Jul 22, 2014 at 3:12 PM, Ashu k >> >> 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 wrote: >> >> >> >> > Pl refer this, done minor changes! >> >> >> >> > >> >> >> >> > Cheers!! >> >> >> >> > >> >> >> >> > >> >> >> >> > On Mon, Jul 21, 2014 at 8:22 PM, Ashish Kumar >> >> >> >> > > >> >> >> > >> >> >> >> > wrote: >> >> >> >> > >> >> >> >> >> Hi Vaibhav Ji, >> >> >> >> >> >> >> >> >> >> This sheet is Working better than the first one. >> >> >> >> >> >> >> &
Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile
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 wrote: > Hmn... chek this > > > Cheers!! > > > On Tue, Jul 22, 2014 at 7:25 PM, Ashu k 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 wrote: >> > Check this.. >> > >> > Cheers!! >> > >> > >> > On Tue, Jul 22, 2014 at 3:28 PM, Ashu k 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 wrote: >> >> > hi >> >> > >> >> > do you want to add additional attachment or replace existing ? >> >> > >> >> > >> >> > On Tue, Jul 22, 2014 at 3:12 PM, Ashu k >> 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 wrote: >> >> >> > Pl refer this, done minor changes! >> >> >> > >> >> >> > Cheers!! >> >> >> > >> >> >> > >> >> >> > On Mon, Jul 21, 2014 at 8:22 PM, Ashish Kumar >> >> >> > > >> >> > >> >> >> > wrote: >> >> >> > >> >> >> >> Hi Vaibhav Ji, >> >> >> >> >> >> >> >> This sheet is Working better than the first one. >> >> >> >> >> >> >> >> Tremendous..!!! >> >> >> >> >> >> >> >> >> >> >> >> Regards >> >> >> >> Ashish >> >> >> >> >> >> >> >> >> >> >> >> On 21 July 2014 20:03, Vaibhav Joshi 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 >> >> >> >>> >> >> >> wrote: >> >> >> >>> >> >> >> >>>> Dear Vaibhav Sir, >&
Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile
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 wrote: > Check this.. > > Cheers!! > > > On Tue, Jul 22, 2014 at 3:28 PM, Ashu k 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 wrote: >> > hi >> > >> > do you want to add additional attachment or replace existing ? >> > >> > >> > On Tue, Jul 22, 2014 at 3:12 PM, Ashu k 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 wrote: >> >> > Pl refer this, done minor changes! >> >> > >> >> > Cheers!! >> >> > >> >> > >> >> > On Mon, Jul 21, 2014 at 8:22 PM, Ashish Kumar >> >> > > >> > >> >> > wrote: >> >> > >> >> >> Hi Vaibhav Ji, >> >> >> >> >> >> This sheet is Working better than the first one. >> >> >> >> >> >> Tremendous..!!! >> >> >> >> >> >> >> >> >> Regards >> >> >> Ashish >> >> >> >> >> >> >> >> >> On 21 July 2014 20:03, Vaibhav Joshi 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 >> >> 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 >> >> >>>> > Date: 19 July 2014 22:02 >> >> >>>> > Subject: Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile >> >> >>>> > To: "excel-macros@googlegroups.com" >> >> >>>> > >> >> >>>> > >> >>
Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile
Hi Vaibhav, perfect solution. Great!! Regards Ashish On 22 July 2014 18:08, Vaibhav Joshi wrote: > Check this.. > > Cheers!! > > > On Tue, Jul 22, 2014 at 3:28 PM, Ashu k 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 wrote: >> > hi >> > >> > do you want to add additional attachment or replace existing ? >> > >> > >> > On Tue, Jul 22, 2014 at 3:12 PM, Ashu k 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 wrote: >> >> > Pl refer this, done minor changes! >> >> > >> >> > Cheers!! >> >> > >> >> > >> >> > On Mon, Jul 21, 2014 at 8:22 PM, Ashish Kumar >> >> > > >> > >> >> > wrote: >> >> > >> >> >> Hi Vaibhav Ji, >> >> >> >> >> >> This sheet is Working better than the first one. >> >> >> >> >> >> Tremendous..!!! >> >> >> >> >> >> >> >> >> Regards >> >> >> Ashish >> >> >> >> >> >> >> >> >> On 21 July 2014 20:03, Vaibhav Joshi 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 >> >> 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 >> >> >>>> > Date: 19 July 2014 22:02 >> >> >>>> > Subject: Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile >> >> >>>> > To: "excel-macros@googlegroups.com" >> >> >>>> > >> >> >>>> > >> >> >>>> > >> >> >>>> > Check this.. >> >> >>>> > >> >> >>>> > Cheers!! >> >> >>>> > >> >> >>>> > >>
Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile
Dear Vaibhav Sir, That's what I am looking for. I really appreciate your help and support. Thanks a lot sir. Thanks & Regards Ashu Kenith > On 7/22/14, Vaibhav Joshi wrote: >> Check this.. >> >> Cheers!! >> >> >> On Tue, Jul 22, 2014 at 3:28 PM, Ashu k 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 wrote: >>> > hi >>> > >>> > do you want to add additional attachment or replace existing ? >>> > >>> > >>> > On Tue, Jul 22, 2014 at 3:12 PM, Ashu k >>> > 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 wrote: >>> >> > Pl refer this, done minor changes! >>> >> > >>> >> > Cheers!! >>> >> > >>> >> > >>> >> > On Mon, Jul 21, 2014 at 8:22 PM, Ashish Kumar >>> >> > >> >> > >>> >> > wrote: >>> >> > >>> >> >> Hi Vaibhav Ji, >>> >> >> >>> >> >> This sheet is Working better than the first one. >>> >> >> >>> >> >> Tremendous..!!! >>> >> >> >>> >> >> >>> >> >> Regards >>> >> >> Ashish >>> >> >> >>> >> >> >>> >> >> On 21 July 2014 20:03, Vaibhav Joshi 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 >>> >> 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 -- &
Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile
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 wrote: > hi > > do you want to add additional attachment or replace existing ? > > > On Tue, Jul 22, 2014 at 3:12 PM, Ashu k 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 wrote: >> > Pl refer this, done minor changes! >> > >> > Cheers!! >> > >> > >> > On Mon, Jul 21, 2014 at 8:22 PM, Ashish Kumar >> > > > >> > wrote: >> > >> >> Hi Vaibhav Ji, >> >> >> >> This sheet is Working better than the first one. >> >> >> >> Tremendous..!!! >> >> >> >> >> >> Regards >> >> Ashish >> >> >> >> >> >> On 21 July 2014 20:03, Vaibhav Joshi 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 >> 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 >> >>>> > Date: 19 July 2014 22:02 >> >>>> > Subject: Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile >> >>>> > To: "excel-macros@googlegroups.com" >> >>>> > >> >>>> > >> >>>> > >> >>>> > Check this.. >> >>>> > >> >>>> > Cheers!! >> >>>> > >> >>>> > >> >>>> > On Sat, Jul 19, 2014 at 2:32 PM, Vijay >> >>>> 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 >> >>>> >>> >> >>>> >
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 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 wrote: > > Pl refer this, done minor changes! > > > > Cheers!! > > > > > > On Mon, Jul 21, 2014 at 8:22 PM, Ashish Kumar > > > wrote: > > > >> Hi Vaibhav Ji, > >> > >> This sheet is Working better than the first one. > >> > >> Tremendous..!!! > >> > >> > >> Regards > >> Ashish > >> > >> > >> On 21 July 2014 20:03, Vaibhav Joshi 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 > 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 > >>>> > Date: 19 July 2014 22:02 > >>>> > Subject: Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile > >>>> > To: "excel-macros@googlegroups.com" > >>>> > > >>>> > > >>>> > Check this.. > >>>> > > >>>> > Cheers!! > >>>> > > >>>> > > >>>> > On Sat, Jul 19, 2014 at 2:32 PM, Vijay > >>>> 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 thi
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 wrote: > Pl refer this, done minor changes! > > Cheers!! > > > On Mon, Jul 21, 2014 at 8:22 PM, Ashish Kumar > wrote: > >> Hi Vaibhav Ji, >> >> This sheet is Working better than the first one. >> >> Tremendous..!!! >> >> >> Regards >> Ashish >> >> >> On 21 July 2014 20:03, Vaibhav Joshi 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 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 >>>> > Date: 19 July 2014 22:02 >>>> > Subject: Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile >>>> > To: "excel-macros@googlegroups.com" >>>> > >>>> > >>>> > Check this.. >>>> > >>>> > Cheers!! >>>> > >>>> > >>>> > On Sat, Jul 19, 2014 at 2:32 PM, Vijay >>>> 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 >>>> >> &
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 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 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 >> > Date: 19 July 2014 22:02 >> > Subject: Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile >> > To: "excel-macros@googlegroups.com" >> > >> > >> > Check this.. >> > >> > Cheers!! >> > >> > >> > On Sat, Jul 19, 2014 at 2:32 PM, Vijay >> 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
Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile
Dear Vaibhav Sir, Working Fine. Thanks Ashu Kenith On 7/21/14, Vaibhav Joshi 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 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 >> > Date: 19 July 2014 22:02 >> > Subject: Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile >> > To: "excel-macros@googlegroups.com" >> > >> > >> > Check this.. >> > >> > Cheers!! >> > >> > >> > On Sat, Jul 19, 2014 at 2:32 PM, Vijay >> > 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
Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile
Cheers Ashish Kumar ji!! On Mon, Jul 21, 2014 at 10:21 AM, Ashish Kumar wrote: > Hi Vaibhav, > > Its Great buddy. > > > Regards > Ashish > > > On 19 July 2014 22:02, Vaibhav Joshi wrote: > >> Check this.. >> >> Cheers!! >> >> >> On Sat, Jul 19, 2014 at 2:32 PM, Vijay 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 exce
Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile
Hi Vaibhav, Its Great buddy. Regards Ashish On 19 July 2014 22:02, Vaibhav Joshi wrote: > Check this.. > > Cheers!! > > > On Sat, Jul 19, 2014 at 2:32 PM, Vijay 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.
$$Excel-Macros$$ Re: Send Atachment ExcelFile
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.
