Re: $$Excel-Macros$$ Email Sheet with message

Hi Darwin, If you are not able to see mentioned reference " Microsoft Outlook 12.0 Object Library " in your machine, then probably you can get it by installing VB 6.0 edition in your computer. Mangesh. On Wed, Mar 28, 2012 at 3:49 PM, Jorge Marques wrote: > Talal, i´m also a beginner, i´m u

Re: $$Excel-Macros$$ Email Sheet with message

Talal, i´m also a beginner, i´m using some books, but i haven´t found any extensive one in VBA, i use recording methods to see what the code performs, and use other posts to see what it returns in the excel provided, it has helped me a lot improving my skills, i notice that i not still able to buil

Re: $$Excel-Macros$$ Email Sheet with message

Dear Talal, It's really simple but it takes some time. Spend 2-3 hours a day, every day, in these forums reading posts and trying the solutions provided. Experiment! Try to Create simple macro by help of record macro,Google,Books. Hope your Excel-VBA will surely improve. -- Thanks & regards, N

Re: $$Excel-Macros$$ Email Sheet with message

thanks buddy i'll give this a try On Wednesday, 14 March 2012 01:20:52 UTC-5, NOORAIN ANSARI wrote: > Please add Outlook library before run the code > > Tools-Reference-Microsoft Outlook 12.0 Object Library. > > -- > Thanks & regards, > Noorain Ansari > **

Re: $$Excel-Macros$$ Email Sheet with message

Hi Mr. Ansari how are you? My dear i need your help can u guide me; how can i improve my skills in excel and VBA regards, On Wed, Mar 14, 2012 at 11:20 AM, NOORAIN ANSARI wrote: > Please add Outlook library before run the code > > Tools-Reference-Microsoft Outlook 12.0 Object Library. > > > -

Re: $$Excel-Macros$$ Email Sheet with message

Please add Outlook library before run the code Tools-Reference-Microsoft Outlook 12.0 Object Library. -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Wed, Mar 1

Re: $$Excel-Macros$$ Email Sheet with message

Dear Selva, Please use below code to add message Sub Send_Email() Dim olApp As Outlook.Application Dim olMail As MailItem Dim mailbody As String Set olApp = New Outlook.Application Set olMail = olApp.CreateItem(olMailItem) With olMail .To = "noorain.ans...@gmail.com" .CC = "noorain.ans...@one97.n