Ok Sir, I am trying.
Regards
Ashu Kenith
--
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
in this attachment did you enabled this library in refrences go to vba
editior enalble these library and then go to sheet1 and click the button
send mails .
microsoft outlook 14.0 object library
ole auotmation
microsoft excel 14.0 object library
visual basic for applications
microsoft forms
Dear Mandeep Sir,
All are enabled.
PFA the attachment.
Please provide Support.
Regards
Ashu Kenith
--
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
Dear Mandeep Sir,
Query is still pending from last 2 months. Last time you said that,
you will send the answer shortly.
Revert awaited from your side.
Please help.
Regards
Ashu kenith.
On 1/15/15, Ashu k direct2as...@gmail.com wrote:
Dear Mandeep Sir,
Please Help on the same issue. Can i
PFA !!!
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/VBAEXCELSQL?ref=hl
https://www.linkedin.com/profile/view?id=312532939
On Wednesday, 17 December 2014 18:30:29 UTC+5:30, Ashu k wrote:
Dear Seniors,
I have data in sheet 1
Name Class Roll NO. Exam Date
remove option explicity statement which is in first line of your code, as
this code working perfecctly on my pc , Please send me the line number of
error.
On Wednesday, 17 December 2014 18:30:29 UTC+5:30, Ashu k wrote:
Dear Seniors,
I have data in sheet 1
Name Class Roll NO. Exam
Dear Mandeep Sir,
Please help.
kindly send the macro.
Regards
Ashu Kenith.
On Thu, Jan 15, 2015 at 6:41 PM, Ashu k direct2as...@gmail.com wrote:
Dear Mandeep Sir,
Please Help on the same issue. Can i explain again my query.
Please help sir.
Regards
Ashu Kenith
On Thu, Jan 15, 2015
https://m.facebook.com/VBAEXCELSQL?__tn__=C
This is my page i have posted your macro on this blog top post is yours,
Copy the same and run in your sheet.
Sorry i forgot to send you the sheet.will send the same as i will be in office.
Regards,
Mandeep
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT))
Dear Mandeep Sir,
Thanks a lot for your help.
I don't have an facebook account. So, request you to please share the macro
when you have time.
Thanks for your help and kind support.
Regards
Ashu Kenith
On Thu, Jan 15, 2015 at 9:33 PM, Mandeep Baluja rockerna...@gmail.com
wrote:
Dear Mandeep Sir,
Please Help on the same issue. Can i explain again my query.
Please help sir.
Regards
Ashu Kenith
On Thu, Jan 15, 2015 at 12:30 PM, Ashu k direct2as...@gmail.com wrote:
Dear Mandeep Sir,
Please help.
Regards
Ashu Kenith.
On Tue, Jan 13, 2015 at 6:37 PM, Ashu k
Dear Mandeep Sir,
Please help.
Regards
Ashu Kenith.
On Tue, Jan 13, 2015 at 6:37 PM, Ashu k direct2as...@gmail.com wrote:
Dear Mandeep Sir,
Thanks a lot for your help.
one more help required.
If the Merchant ID is same then paste the data (Order No., Item ID, Item
Name, RTO Date) on
Dear Mandeep Sir,
Please Help.
Regards
Ashu Kenith.
On Wed, Jan 7, 2015 at 4:18 PM, Ashu k direct2as...@gmail.com wrote:
Dear Mandeep Sir,
Solution was perfect. But i want Paste the data in Mail body.
Please check below sample Email :-
Dear Business Partner,
This is to inform you
Amazing Code Bro !!
On Wednesday, December 17, 2014 6:30:29 PM UTC+5:30, Ashu k wrote:
Dear Seniors,
I have data in sheet 1
Name Class Roll NO. Exam Date
and,
I have data in Sheet 2
Name Class Roll No. Exam Date
But some Names are not in Name Column and Some Class are not
Dear Anil Sir,
Thanks for your reply. But, i dont want to send mail with attachment. I
want send different mail to different customers according to the merchant
ID.
Subject and message body should be changed automatically with all the
details (order no., rto date, item name, item id) when i
Dear Mandeep Sir,
I don't want to send mail with attachment. I want send different mail to
different customers according to the merchant ID.
Subject and message body should be changed automatically with all the
details (order no., rto date, item name, item id) when i punch the merchant
id,order
Dear Mr. Ashu,
Pls find attached as per you requirement.
P.S pls change the address of the attachment as you req.
.Add (T:\Commercial\Common\Shailendra\Data Format(Now(),
mm-dd-yy) .xls)
Warm regards,
Gawli Anil.
On Wed, Jan 7, 2015 at 1:24 PM, Ashu k direct2as...@gmail.com wrote:
Dear
Done !!
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
--
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 @
Dear Mandeep Sir,
Solution was perfect. But i want Paste the data in Mail body.
Please check below sample Email :-
Dear Business Partner,
This is to inform you that as per our logistic partner report you have
received RTO shipments with details as follow:
*Order No*
*Item ID*
*Item
check this sheet.
Try to understand what I did For i = 2 To lr + 700 you can set 700 to any
number. Datarange is not set in your data that's why i running the loop to
lastrow+700 if your data will be greater just change 700 to 7 or to any
number it will give correct result to you.
Hey Ashu,
Check this sheet .* Note :- be careful to check this macro can only give
you error if the number are actually numbers not the Text values as your
sheet contain 1 value which was text that is the only reason it gives error
as paul has explained to you mostly people copy numbers
Dear Paul Sir,
Thanks for your help and explaining me..
Dear Mandeep Sir,
Thanks a lot for your help, Please check the attached sheet. Result was not
showing in Last cell.
Please help.
Thanks
Ashu Kenith.
On Wed, Jan 7, 2015 at 10:21 AM, Mandeep Baluja rockerna...@gmail.com
wrote:
Hey
Dear Mandeep Sir,
PLease help. I want send mail to the customers. Example is attached.
Thanks
Ashu Kenith
--
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
: Tuesday, January 6, 2015 11:38 AM
Subject: Fwd: $$Excel-Macros$$ Re: Help required for Match DATA
Dear Mandeep Sir,
Please help on this. The sheet is provided by you is providing NA#. Please
Help.
Thanks
Ashu Kenith
-- Forwarded message --
From: Ashu k direct2as
Dear Mandeep Sir,
Please help on this. The sheet is provided by you is providing NA#. Please
Help.
Thanks
Ashu Kenith
-- Forwarded message --
From: Ashu k direct2as...@gmail.com
Date: Wed, Dec 31, 2014 at 11:52 AM
Subject: Fwd: $$Excel-Macros$$ Re: Help required for Match DATA
...@gmail.com
Date: Tue, Dec 23, 2014 at 11:06 AM
Subject: Re: $$Excel-Macros$$ Re: Help required for Match DATA
To: excel-macros excel-macros@googlegroups.com
Dear Mandeep Sir,
It gives NA# again. Kindly run macro and See the result in Cell C1 and C12.
Sheet attached.
Thanks
Ashu Kenith
On Tue
Now this macro works for 3 lakh rows you can increase the range as per your
convenience.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Wednesday, December 17, 2014 6:30:29 PM UTC+5:30, Ashu k
Dear Mandeep Sir,
It gives NA# again. Kindly run macro and See the result in Cell C1 and C12.
Sheet attached.
Thanks
Ashu Kenith
On Tue, Dec 23, 2014 at 10:52 AM, Mandeep Baluja rockerna...@gmail.com
wrote:
Now this macro works for 3 lakh rows you can increase the range as per
your
Dear Mandeep Sir,
It's not working.
Thanks
Ashu Kenith.
On Thu, Dec 18, 2014 at 8:00 PM, Ashu k direct2as...@gmail.com wrote:
Dear Mandeep Sir,
The code which is provided by you is not working properly. It's giving NA#
in sheet 2.
Formula is working fine for me which is provided by
Dear Mandeep Sir,
The code which is provided by you is not working properly. It's giving NA#
in sheet 2.
Formula is working fine for me which is provided by Ashish Sir Vaibhav
Sir.
Kindly check the output and Please Help me.
Sheet attached.
Thanks
Ashu Kenith
On Thu, Dec 18, 2014 at 12:42
check this out.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Wednesday, December 17, 2014 6:30:29 PM UTC+5:30, Ashu k wrote:
Dear Seniors,
I have data in sheet 1
Name Class Roll NO. Exam
Dear Sir,
Thank you very much.
Thanks
Ashu Kenith
On Thu, Dec 18, 2014 at 10:56 AM, Mandeep Baluja rockerna...@gmail.com
wrote:
check this out.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On
31 matches
Mail list logo