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 build code by myself, but know, I can read and understand what it means, so i can build macros but taking pieces from other macros and adapt to what i pretend, and when i have doubts this forum is 100% perfect. i hope someday i can be the one responding to solutions and not asking for them :), wish you the best in this Excel world.
2012/3/28 Darwin Chan <darwin.chankaw...@gmail.com> > Hi all, > > I found this thread which is really useful, however, I couldnt find the > Tools-Reference-Microsoft Outlook 12.0 Object Library as mentioned by > Noorain MS Excel 2000 version > How could I get access to the Library? > > 2012/3/20 NOORAIN ANSARI <noorain.ans...@gmail.com> > >> 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, >> Noorain Ansari >> *http://noorainansari.com/* >> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> >> >> On Wed, Mar 14, 2012 at 12:39 PM, Muhammad Talal Akbar < >> sh.talal.ak...@gmail.com> wrote: >> >>> 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 < >>> noorain.ans...@gmail.com> wrote: >>> >>>> Please add Outlook library before run the code >>>> >>>> Tools-Reference-Microsoft Outlook 12.0 Object Library. >>>> >>>> On Wed, Mar 14, 2012 at 11:13 AM, LearnExcel <sendse...@gmail.com>wrote: >>>> >>>>> i'm using the following code to send email how do i add something to >>>>> the body? >>>>> >>>>> >>>>> does anyone know if its possible to add a message to the email? >>>>> >>>>> ThisWorkbook.Sheets(1).Copy >>>>> >>>>> With ActiveWorkbook >>>>> >>>>> .SendMail Recipients:="emailaddr...@df.com", _ >>>>> >>>>> Subject:="Try Me") >>>>> >>>>> .Close SaveChanges:=False >>>>> >>>>> End With >>>>> >>>>> >>>>> *End Sub* >>>>> >>>>> -- >>>>> FORUM RULES (986+ members already BANNED for violation) >>>>> >>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>> Advice will not get quick attention or may not be answered. >>>>> >>>>> 2) Don't post a question in the thread of another member. >>>>> >>>>> 3) Don't post questions regarding breaking or bypassing any security >>>>> measure. >>>>> >>>>> 4) Acknowledge the responses you receive, good or bad. >>>>> >>>>> 5) Cross-promotion of, or links to, forums competitive to this forum >>>>> in signatures are prohibited. >>>>> >>>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>>> Forum owners and members are not responsible for any loss. >>>>> >>>>> >>>>> ------------------------------------------------------------------------------------------------------ >>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>> >>>> >>>> >>>> >>>> >>>> >>>> -- >>>> FORUM RULES (986+ members already BANNED for violation) >>>> >>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>>> will not get quick attention or may not be answered. >>>> >>>> 2) Don't post a question in the thread of another member. >>>> >>>> 3) Don't post questions regarding breaking or bypassing any security >>>> measure. >>>> >>>> 4) Acknowledge the responses you receive, good or bad. >>>> >>>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>>> signatures are prohibited. >>>> >>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>> Forum owners and members are not responsible for any loss. >>>> >>>> >>>> ------------------------------------------------------------------------------------------------------ >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> ------------------------------------------------------------------------------------------------------ >>> To post to this group, send email to excel-macros@googlegroups.com >>> >> >> >> >> -- >> Thanks & regards, >> Noorain Ansari >> ** <http://excelmacroworld.blogspot.com/>*http://noorainansari.com/* >> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> >> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> ------------------------------------------------------------------------------------------------------ >> To post to this group, send email to excel-macros@googlegroups.com >> > > > > -- > Best Regards, > Darwin Chan > darwin.chankaw...@gmail.com > kw42c...@yahoo.com.hk > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
