Hi All I am sasikanth, i an in need of a macro which should send an report basing upon the date lets take on every month 31st i want to send an excel sheet to the recipients via outlook. and again on 5th i need to send another report and again on 10.Can you please advise me on this. As iam badly...
Hi All, I am sasi kanth. I have written a code for sending Excel sheet as an attachment with outlook, How ever i am able to send only E-mail but not the attachment.MY code is as follows
Sub mail()
Dim ouapp as object
dim outmail as object
set outapp=createobject("outlook.application")
set...
Hi Narayan & Patnaik, Thank you for the reply. I just want to copy a range of data with a certain criteria from one excel sheet to other excel sheet. And i have written the above code How ever its working now. I just wanted to know whether this will be possible if i want to extract data from...
Hi All, i am sasi kanth. I wanted to copy data of required criteria from one excel sheet to another excel sheet. I have written the Following VBA code how ever there's an error persisting as "1004" Run time error. i am using Excel 2007(the code written is for a command button)can any one please...
Hi All, I wanted to copy data of required criteria from one excel sheet to another excel sheet. I have written the Following VBA code how ever there's an error persisting as "1004" Run time error. i am using Excel 2007(the code written is for a command button)can any one please help me on this...