Re: $$Excel-Macros$$ Notes : Help

2011-08-18 Thread Chandra Shekar
Hello Asish, Is there any way where we can make part of string to bold and color it? Thanks, Chandra Shekar B On Thu, Aug 18, 2011 at 9:13 AM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Thanks a lot Ashish. Its working fine. :-) > > > On Thu, Aug 18, 2011 at 2:01 AM, ashish koul w

Re: $$Excel-Macros$$ Notes : Help

2011-08-18 Thread Chandra Shekar
Thanks a lot Ashish. Its working fine. :-) On Thu, Aug 18, 2011 at 2:01 AM, ashish koul wrote: > try this one > > > On Wed, Aug 17, 2011 at 1:25 PM, Chandra Shekar < > chandrashekarb@gmail.com> wrote: > >> Hello Ashish, >> >> Could u pls help on this error. Thanks! >> >> On Tue, Aug 16, 20

Re: $$Excel-Macros$$ Notes : Help

2011-08-17 Thread Chandra Shekar
Hello Ashish, Could u pls help on this error. Thanks! On Tue, Aug 16, 2011 at 11:25 AM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hi Ashish, > > Thanks for the reply and patience. I have attached the excel file. I am > facing below errors when I run the macro. > > 1. I am getting e

Re: $$Excel-Macros$$ Notes : Help

2011-08-16 Thread ashish koul
hi chandar i tried it its working fine also ur code is password protected .can u unlock it and send it again On Tue, Aug 16, 2011 at 12:43 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hi Ashish, > > Please find attached file and kindly do the needful. Thanks in advance. > > On T

Re: $$Excel-Macros$$ Notes : Help

2011-08-15 Thread ashish koul
can you attach your file On Mon, Aug 15, 2011 at 5:35 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hi, > > I am getting attached error while running the macro. Please let me know > whats the error in the below code. > > *MailDoc.Save True, True, False* > > Regards, > > Chandra Sh

Re: $$Excel-Macros$$ Notes : Help

2011-08-15 Thread Chandra Shekar
Hi Asish, Thank u for the help again I am getting error in the below code. Please let me know whats the problem in the below code. Thanks in advance. ** *MailDoc.Save True, True, False * On Mon, Aug 15, 2011 at 9:53 AM, ashish koul wrote: > dont use .copy in set statement > > > On Fri, Aug 12,

Re: $$Excel-Macros$$ Notes : Help

2011-08-15 Thread ashish koul
dont use .copy in set statement On Fri, Aug 12, 2011 at 3:43 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hello Ashish, > > I got solution for this issue but I am getting one more error in code as > type mismatch > > > *Set rnbody1 = Sheets("Details").UsedRange.Copy > rnbody1.Copy

Re: $$Excel-Macros$$ Notes : Help

2011-08-14 Thread Chandra Shekar
Hi Ashish, Could u pls help one this code. Thanks On Fri, Aug 12, 2011 at 12:13 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hello Ashish, > > I got solution for this issue but I am getting one more error in code as > type mismatch > > > *Set rnbody1 = Sheets("Details").UsedRange.

Re: $$Excel-Macros$$ Notes : Help

2011-08-12 Thread Chandra Shekar
Hello Ashish, I got solution for this issue but I am getting one more error in code as type mismatch *Set rnbody1 = Sheets("Details").UsedRange.Copy rnbody1.Copy * On Fri, Aug 12, 2011 at 9:12 AM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hi Ashsh, > > I used ur code but getting

Re: $$Excel-Macros$$ Notes : Help

2011-08-12 Thread Chandra Shekar
Hi Ashsh, I used ur code but getting error in below lines. I think I need to enable some reference. Please let me know about this. *Set Data = New DataObject Data.GetFromClipboard * Thanks, Chandra Shekar B On Fri, Aug 12, 2011 at 8:21 AM, Chandra Shekar < chandrashekarb@gmail.com> wrote: >

Re: $$Excel-Macros$$ Notes : Help

2011-08-11 Thread Chandra Shekar
Thanks Ashish I will check it out. :-) On Fri, Aug 12, 2011 at 4:31 AM, ashish koul wrote: > try these > > > On Wed, Aug 10, 2011 at 6:10 PM, Chandra Shekar < > chandrashekarb@gmail.com> wrote: > >> Hi, >> >> In below code some times I could able to send attachments but some times >> its not

$$Excel-Macros$$ Notes : Help

2011-08-10 Thread Chandra Shekar
Hi, In below code some times I could able to send attachments but some times its not taking attachment at all. Please let me know whats is the problem in the below code. Sub sendmail() ' Dim UserName As String Dim MailDbName As String Dim Recipient As Variant Dim ccRecipient As String Dim Attachm