Re: $$Excel-Macros$$ EXCEL TO OUTLOOK

2014-08-22 Thread Ashish Kumar
Thanks Sir. On 22 August 2014 18:00, Vaibhav Joshi wrote: > Bros its Super!! > > Cheers!! > > > On Fri, Aug 22, 2014 at 5:37 PM, Ashish Kumar > wrote: > >> Hi Rajni, >> >> Pfa according to your requirement. >> >> >> Regards >> Ashish Kumar >> >> >> On 22 August 2014 17:29, Chintan Rajani >> w

Re: $$Excel-Macros$$ EXCEL TO OUTLOOK

2014-08-22 Thread Vaibhav Joshi
Bros its Super!! Cheers!! On Fri, Aug 22, 2014 at 5:37 PM, Ashish Kumar wrote: > Hi Rajni, > > Pfa according to your requirement. > > > Regards > Ashish Kumar > > > On 22 August 2014 17:29, Chintan Rajani > wrote: > >> Ok.. >> >> Thank you very much.. >> >> -- > Are you =EXP(E:RT) or =NOT(EX

Re: $$Excel-Macros$$ EXCEL TO OUTLOOK

2014-08-22 Thread Ashish Kumar
Hi Rajni, Pfa according to your requirement. Regards Ashish Kumar On 22 August 2014 17:29, Chintan Rajani wrote: > Ok.. > > Thank you very much.. > > -- 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 foru

Re: $$Excel-Macros$$ EXCEL TO OUTLOOK

2014-08-22 Thread Chintan Rajani
Ok.. Thank you very much.. On Fri, Aug 22, 2014 at 5:25 PM, Ashish Kumar wrote: > I have pasted your second table in sheet 1. If you want to send both 2 > tables in 1 mail then select both tables and hit the macro or if you want > to send only 1 table in 1 mail then select only 1 table which

Re: $$Excel-Macros$$ EXCEL TO OUTLOOK

2014-08-22 Thread Ashish Kumar
I have pasted your second table in sheet 1. If you want to send both 2 tables in 1 mail then select both tables and hit the macro or if you want to send only 1 table in 1 mail then select only 1 table which you want to send and hit the macro. Regards Ashish On 22 August 2014 17:17, Chintan Rajan

Re: $$Excel-Macros$$ EXCEL TO OUTLOOK

2014-08-22 Thread Chintan Rajani
Thank you very much code is working but when i have to paste 2nd table from sheet number 2 .. after that its not working.. sorry for trouble. On Fri, Aug 22, 2014 at 5:10 PM, Ashish Kumar wrote: > Hi Chintan, > > PFA..!!! > > > > Regards > Ashish > > > On 22 August 2014 16:42, Ashish Kuma

Re: $$Excel-Macros$$ EXCEL TO OUTLOOK

2014-08-22 Thread Chintan Rajani
*1.)**Aged Debtors as on 15/08/2014 – £50* Thanks.. On Fri, Aug 22, 2014 at 5:10 PM, Chintan Rajani wrote: > I have to write below text > > "Abc outstanding amount £50.00". > > > > > On Fri, Aug 22, 2014 at 4:42 PM, Ashish Kumar > wrote: > >> what subject you want to write. >> >> On 22 A

Re: $$Excel-Macros$$ EXCEL TO OUTLOOK

2014-08-22 Thread Ashish Kumar
Hi Chintan, PFA..!!! Regards Ashish On 22 August 2014 16:42, Ashish Kumar wrote: > what subject you want to write. > > On 22 August 2014 16:37, Chintan Rajani > wrote: > >> Yes, i have to paste 2 tables start from both sheets "1)" and "2)". >> >> >> and add one text line past in outlo

Re: $$Excel-Macros$$ EXCEL TO OUTLOOK

2014-08-22 Thread Chintan Rajani
I have to write below text "Abc outstanding amount £50.00". On Fri, Aug 22, 2014 at 4:42 PM, Ashish Kumar wrote: > what subject you want to write. > > On 22 August 2014 16:37, Chintan Rajani > wrote: > >> Yes, i have to paste 2 tables start from both sheets "1)" and "2)". >> >> >> and add

Re: $$Excel-Macros$$ EXCEL TO OUTLOOK

2014-08-22 Thread Ashish Kumar
what subject you want to write. On 22 August 2014 16:37, Chintan Rajani wrote: > Yes, i have to paste 2 tables start from both sheets "1)" and "2)". > > > and add one text line past in outlook. > > "Abc outstanding amount £50.00"with table one. > > Thank you Ashish for promptly reply. > > > > O

Re: $$Excel-Macros$$ EXCEL TO OUTLOOK

2014-08-22 Thread Chintan Rajani
Yes, i have to paste 2 tables start from both sheets "1)" and "2)". and add one text line past in outlook. "Abc outstanding amount £50.00"with table one. Thank you Ashish for promptly reply. On Fri, Aug 22, 2014 at 4:30 PM, Ashish Kumar wrote: > Hi Chintan, > > You want only paste table i

Re: $$Excel-Macros$$ EXCEL TO OUTLOOK

2014-08-22 Thread Ashish Kumar
Hi Chintan, You want only paste table in mail body which is in Sheet 2. Regards Ashish On 22 August 2014 16:21, chintz wrote: > Hello sir, > > Please could any one help me to resolve this problem. > > In Excel 2 sheets and there are two different table (with one or two text > line). > > I hav

$$Excel-Macros$$ EXCEL TO OUTLOOK

2014-08-22 Thread chintz
Hello sir, Please could any one help me to resolve this problem. In Excel 2 sheets and there are two different table (with one or two text line). I have to paste in outlook through vb code. thanks in advance. Regards. Rajani -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you