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 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.comwrote: 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/*
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 leote.w...@gmail.com wrote: 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.comwrote: 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.
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, 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
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.net .Subject = Try it .Body = Dear Application.UserName , vbCrLf vbCrLf Please find the - below - vbCrLf vbCrLf Regards, vbCrLf vbCrLf Noorain Ansari .Attachments.Add ActiveWorkbook.FullName .Display '.Send End With mailbody = vbNullString End Sub -- Thanks regards, Noorain Ansari *http://noorainansari.com/* http://excelmacroworld.blogspot.com/ *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ 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
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/ *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ 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
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 noorain.ans...@gmail.comwrote: Please add Outlook library before run the code Tools-Reference-Microsoft Outlook 12.0 Object Library. -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ 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
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 ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ 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
$$Excel-Macros$$ Email Sheet with message
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