You ought to look for an Outlook VBA group. this group is focused on Excel VBA. With all microsoft applications, VBA has sepecific capabilities for each application.
For instance, Outlook and Word have no use for a .Range object. at the same time, Excel has no use for a .Body object. your question really should be addressed by those with intense knowledge of VBA for Outlook. sorry, paul ________________________________ From: janet dickson <janetdicks...@gmail.com> To: excel-macros@googlegroups.com Sent: Tue, April 6, 2010 1:08:22 PM Subject: Re: $$Excel-Macros$$ Re: Help: OUTLOOK VBA Okay Am looking for codes to forward emails which am receiving in my OUTLOOK 2007 to my second mail/Account and if some emails contain attachment, then all email with attachment file >=3MB will be excluded automatically. I hope you understood Thanks for helping Jenie.. On Tue, Apr 6, 2010 at 8:28 AM, rf1234 rf1234 <rfhyd1...@gmail.com> wrote: Hello Dear, >I appriciate your prompt reply,it may be a missunderstanding,but please >let me know if any one has a outlook express in his or her PC,Then >what is need to write a macro for outlook("To Send The Mail") . > > > >It is useful when we are accessing outlook from another application. > > > >Your suggestion are welcome,so that i can improve my prompt reply. > > > > > > >Hope it Will Help >Happy to Help >:) >Shyam > > > > >On Tue, Apr 6, 2010 at 1:48 AM, paulwillekens > ><paul.johan.willek...@gmail.com> wrote: >> > >> Hi Shyam, >> >> I mean the following: I understand what Janet wrote in a different way >> than you. I had the impression that you assume that Janet wants >> something from Excel, but I think he/she wants VBA macros for Outlook >> (not for Excel)... >> >> regards >> >> Paul Willekens >> >> -- >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our Facebook Group @ >> http://www.facebook.com/group.php?gid=287779555678 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com/ >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com/ >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com/ >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,800 subscribers worldwide and receive many nice notes about >> the learning and support from the group.Let friends and co-workers know they >> can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> >> To unsubscribe, reply using "remove me" as the subject. >> > > > > >-- > >Thanks Regards >Shyam >Software Engineer >'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' >When one door of happiness closes, another opens; > but often we look so long at the closed door that we do not see the > one which has been opened for us. >- Helen Keller >'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' >Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, >aber oft schauen wir so lange auf die geschlossene Tür, > dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller >'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' > >-- >---------------------------------------------------------------------------------- > >Some important links for excel users: >1. Follow us on TWITTER for tips tricks and links : >http://twitter.com/exceldailytip >2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 >3. Excel tutorials at http://www.excel-macros.blogspot.com >4. Learn VBA Macros at http://www.quickvba.blogspot.com >5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > >To post to this group, send email to excel-macros@googlegroups.com > ><><><><><><><><><><><><><><><><><><><><><><> >HELP US GROW !! > >We reach over 6,800 subscribers worldwide and receive many nice notes about >the learning and support from the group.Let friends and co-workers know they >can subscribe to group at http://groups.google.com/group/excel-macros/subscribe > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe