Main Page 
PC Review
Forums
Newsgroups
Microsoft Outlook
Microsoft Outlook VBA Programming
Message Rules
Forums
Newsgroups
Microsoft Outlook
Microsoft Outlook VBA Programming
Message Rules
 |
Message Rules |
|
|
Thread Tools | Rate Thread |
14-12-2006, 09:16 AM
|
#1 |
|
Guest
Posts: n/a
|
Message Rules
I work for a large organisation and have reached the limit of my message
rules, I therefore want to try and use VBA to move messages from certain people or with certain subjects to various sub-folders of my inbox (also consider exceptions e.g. 'Out of Office replies'). We use Outlook 2000 on a 2000 exchange server, I am completely new to VB in Outlook, can anyone give me the basics and I can build from them? Thank you in advance Keith |
|
|
14-12-2006, 12:33 PM
|
#2 |
|
Guest
Posts: n/a
|
Re: Message Rules
You might start with these pages:
http://www.outlookcode.com/d/vbabasics.htm http://www.outlookcode.com/d/vb.htm http://www.outlookcode.com/d/zaphtml.htm -- various ways to process incoming messages -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Keith" <me@here.com> wrote in message news:er77RC2HHHA.2232@TK2MSFTNGP02.phx.gbl... >I work for a large organisation and have reached the limit of my message > rules, I therefore want to try and use VBA to move messages from certain > people or with certain subjects to various sub-folders of my inbox (also > consider exceptions e.g. 'Out of Office replies'). We use Outlook 2000 on a > 2000 exchange server, I am completely new to VB in Outlook, can anyone give > me the basics and I can build from them? > > Thank you in advance > > Keith > > |
|
|
|
14-12-2006, 09:21 PM
|
#3 |
|
Guest
Posts: n/a
|
Re: Message Rules
Thanks Sue, but the 3rd link will not work for me, is there a problem with
it? "Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message news:%23SN8T33HHHA.3676@TK2MSFTNGP03.phx.gbl... You might start with these pages: http://www.outlookcode.com/d/vbabasics.htm http://www.outlookcode.com/d/vb.htm http://www.outlookcode.com/d/zaphtml.htm -- various ways to process incoming messages -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Keith" <me@here.com> wrote in message news:er77RC2HHHA.2232@TK2MSFTNGP02.phx.gbl... >I work for a large organisation and have reached the limit of my message > rules, I therefore want to try and use VBA to move messages from certain > people or with certain subjects to various sub-folders of my inbox (also > consider exceptions e.g. 'Out of Office replies'). We use Outlook 2000 on > a > 2000 exchange server, I am completely new to VB in Outlook, can anyone > give > me the basics and I can build from them? > > Thank you in advance > > Keith > > |
|
|
|
14-12-2006, 09:29 PM
|
#4 |
|
Guest
Posts: n/a
|
Re: Message Rules
Some days I just can't type. Try http://www.outlookcode.com/d/code/zaphtml.htm
-- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Keith" <me@here.com> wrote in message news:udt6UX8HHHA.3616@TK2MSFTNGP06.phx.gbl... > Thanks Sue, but the 3rd link will not work for me, is there a problem with > it? > > > "Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message > news:%23SN8T33HHHA.3676@TK2MSFTNGP03.phx.gbl... > You might start with these pages: > > http://www.outlookcode.com/d/vbabasics.htm > http://www.outlookcode.com/d/vb.htm > http://www.outlookcode.com/d/zaphtml.htm -- various ways to process incoming > messages > > "Keith" <me@here.com> wrote in message > news:er77RC2HHHA.2232@TK2MSFTNGP02.phx.gbl... >>I work for a large organisation and have reached the limit of my message >> rules, I therefore want to try and use VBA to move messages from certain >> people or with certain subjects to various sub-folders of my inbox (also >> consider exceptions e.g. 'Out of Office replies'). We use Outlook 2000 on >> a >> 2000 exchange server, I am completely new to VB in Outlook, can anyone >> give >> me the basics and I can build from them? >> >> Thank you in advance >> >> Keith >> >> > > |
|
|
|
29-12-2006, 09:09 PM
|
#5 |
|
Guest
Posts: n/a
|
Re: Message Rules
Thanks Sue,
I have been reading the links and playing about with things but am still no further forward, can you give me a basic script so I can see how it works then I can expand from there? Thanks again "Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message news:eG1g2c8HHHA.4688@TK2MSFTNGP04.phx.gbl... Some days I just can't type. Try http://www.outlookcode.com/d/code/zaphtml.htm -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Keith" <me@here.com> wrote in message news:udt6UX8HHHA.3616@TK2MSFTNGP06.phx.gbl... > Thanks Sue, but the 3rd link will not work for me, is there a problem with > it? > > > "Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message > news:%23SN8T33HHHA.3676@TK2MSFTNGP03.phx.gbl... > You might start with these pages: > > http://www.outlookcode.com/d/vbabasics.htm > http://www.outlookcode.com/d/vb.htm > http://www.outlookcode.com/d/zaphtml.htm -- various ways to process > incoming > messages > > "Keith" <me@here.com> wrote in message > news:er77RC2HHHA.2232@TK2MSFTNGP02.phx.gbl... >>I work for a large organisation and have reached the limit of my message >> rules, I therefore want to try and use VBA to move messages from certain >> people or with certain subjects to various sub-folders of my inbox (also >> consider exceptions e.g. 'Out of Office replies'). We use Outlook 2000 on >> a >> 2000 exchange server, I am completely new to VB in Outlook, can anyone >> give >> me the basics and I can build from them? >> >> Thank you in advance >> >> Keith >> >> > > |
|
|
|
29-12-2006, 09:11 PM
|
#6 |
|
Guest
Posts: n/a
|
Re: Message Rules
Thanks Sue,
I have been reading the links and playing about with things but am still no further forward, can you give me a basic script so I can see how it works then I can expand from there? Thanks again "Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message news:eG1g2c8HHHA.4688@TK2MSFTNGP04.phx.gbl... Some days I just can't type. Try http://www.outlookcode.com/d/code/zaphtml.htm -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Keith" <me@here.com> wrote in message news:udt6UX8HHHA.3616@TK2MSFTNGP06.phx.gbl... > Thanks Sue, but the 3rd link will not work for me, is there a problem with > it? > > > "Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message > news:%23SN8T33HHHA.3676@TK2MSFTNGP03.phx.gbl... > You might start with these pages: > > http://www.outlookcode.com/d/vbabasics.htm > http://www.outlookcode.com/d/vb.htm > http://www.outlookcode.com/d/zaphtml.htm -- various ways to process > incoming > messages > > "Keith" <me@here.com> wrote in message > news:er77RC2HHHA.2232@TK2MSFTNGP02.phx.gbl... >>I work for a large organisation and have reached the limit of my message >> rules, I therefore want to try and use VBA to move messages from certain >> people or with certain subjects to various sub-folders of my inbox (also >> consider exceptions e.g. 'Out of Office replies'). We use Outlook 2000 on >> a >> 2000 exchange server, I am completely new to VB in Outlook, can anyone >> give >> me the basics and I can build from them? >> >> Thank you in advance >> >> Keith >> >> > > |
|
|
|
29-12-2006, 09:53 PM
|
#7 |
|
Guest
Posts: n/a
|
Re: Message Rules
I don't know how to get any more basic than the samples on that page. You can also look at the one at http://www.outlookcode.com/d/code/quarexe.htm, which moves messages.
Maybe you should ask specific questions about the pieces you think you're missing. -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Keith" <me@here.com> wrote in message news:Ox1g534KHHA.1240@TK2MSFTNGP03.phx.gbl... > > I have been reading the links and playing about with things but am still no > further forward, can you give me a basic script so I can see how it works > then I can expand from there? > > "Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message > news:eG1g2c8HHHA.4688@TK2MSFTNGP04.phx.gbl... > Some days I just can't type. Try > http://www.outlookcode.com/d/code/zaphtml.htm > > > "Keith" <me@here.com> wrote in message > news:udt6UX8HHHA.3616@TK2MSFTNGP06.phx.gbl... >> Thanks Sue, but the 3rd link will not work for me, is there a problem with >> it? >> >> >> "Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message >> news:%23SN8T33HHHA.3676@TK2MSFTNGP03.phx.gbl... >> You might start with these pages: >> >> http://www.outlookcode.com/d/vbabasics.htm >> http://www.outlookcode.com/d/vb.htm >> http://www.outlookcode.com/d/zaphtml.htm -- various ways to process >> incoming >> messages > >> >> "Keith" <me@here.com> wrote in message >> news:er77RC2HHHA.2232@TK2MSFTNGP02.phx.gbl... >>>I work for a large organisation and have reached the limit of my message >>> rules, I therefore want to try and use VBA to move messages from certain >>> people or with certain subjects to various sub-folders of my inbox (also >>> consider exceptions e.g. 'Out of Office replies'). We use Outlook 2000 on >>> a >>> 2000 exchange server, I am completely new to VB in Outlook, can anyone >>> give >>> me the basics and I can build from them? |
|
|
|
01-01-2007, 06:40 PM
|
#8 |
|
Guest
Posts: n/a
|
Re: Message Rules
Hi Sue,
Thanks for the direction, I have got my code working ok with 2 small exceptions, the first is nothing to do with Outlook but McAfee which always tries to block the script from running saying that it looks suspicious, the 2nd however is a pop up box within Outlook which states:- A program is trying to access e-mail addresses you have stored in Outlook. Do you want to allow this? It then gives me an option to allow access for up to 10 minutes, is there any code that I can use to by-pass this notification or to automatically allow access for an unlimited time? Thanks Again for your help Keith "Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message news:eOJWnP5KHHA.4928@TK2MSFTNGP06.phx.gbl... I don't know how to get any more basic than the samples on that page. You can also look at the one at http://www.outlookcode.com/d/code/quarexe.htm, which moves messages. Maybe you should ask specific questions about the pieces you think you're missing. -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Keith" <me@here.com> wrote in message news:Ox1g534KHHA.1240@TK2MSFTNGP03.phx.gbl... > > I have been reading the links and playing about with things but am still > no > further forward, can you give me a basic script so I can see how it works > then I can expand from there? > > "Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message > news:eG1g2c8HHHA.4688@TK2MSFTNGP04.phx.gbl... > Some days I just can't type. Try > http://www.outlookcode.com/d/code/zaphtml.htm > > > "Keith" <me@here.com> wrote in message > news:udt6UX8HHHA.3616@TK2MSFTNGP06.phx.gbl... >> Thanks Sue, but the 3rd link will not work for me, is there a problem >> with >> it? >> >> >> "Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message >> news:%23SN8T33HHHA.3676@TK2MSFTNGP03.phx.gbl... >> You might start with these pages: >> >> http://www.outlookcode.com/d/vbabasics.htm >> http://www.outlookcode.com/d/vb.htm >> http://www.outlookcode.com/d/zaphtml.htm -- various ways to process >> incoming >> messages > >> >> "Keith" <me@here.com> wrote in message >> news:er77RC2HHHA.2232@TK2MSFTNGP02.phx.gbl... >>>I work for a large organisation and have reached the limit of my message >>> rules, I therefore want to try and use VBA to move messages from certain >>> people or with certain subjects to various sub-folders of my inbox (also >>> consider exceptions e.g. 'Out of Office replies'). We use Outlook 2000 >>> on >>> a >>> 2000 exchange server, I am completely new to VB in Outlook, can anyone >>> give >>> me the basics and I can build from them? |
|
|
|
01-01-2007, 06:56 PM
|
#9 |
|
Guest
Posts: n/a
|
Re: Message Rules
See http://www.outlookcode.com/d/sec.htm for your options with regard to the "object model guard" security in Outlook 2000 SP2 and later versions.
-- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Keith" <me@here.com> wrote in message news:%23JiXORdLHHA.3560@TK2MSFTNGP02.phx.gbl... > Hi Sue, > > Thanks for the direction, I have got my code working ok with 2 small > exceptions, the first is nothing to do with Outlook but McAfee which always > tries to block the script from running saying that it looks suspicious, the > 2nd however is a pop up box within Outlook which states:- > > A program is trying to access e-mail addresses you have stored in Outlook. > Do you want to allow this? > > It then gives me an option to allow access for up to 10 minutes, is there > any code that I can use to by-pass this notification or to automatically > allow access for an unlimited time? > > Thanks Again for your help > > Keith > > > > "Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message > news:eOJWnP5KHHA.4928@TK2MSFTNGP06.phx.gbl... > I don't know how to get any more basic than the samples on that page. You > can also look at the one at http://www.outlookcode.com/d/code/quarexe.htm, > which moves messages. > > Maybe you should ask specific questions about the pieces you think you're > missing. > > "Keith" <me@here.com> wrote in message > news:Ox1g534KHHA.1240@TK2MSFTNGP03.phx.gbl... >> >> I have been reading the links and playing about with things but am still >> no >> further forward, can you give me a basic script so I can see how it works >> then I can expand from there? >> >> "Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message >> news:eG1g2c8HHHA.4688@TK2MSFTNGP04.phx.gbl... > >> Some days I just can't type. Try >> http://www.outlookcode.com/d/code/zaphtml.htm >> >> >> "Keith" <me@here.com> wrote in message >> news:udt6UX8HHHA.3616@TK2MSFTNGP06.phx.gbl... >>> Thanks Sue, but the 3rd link will not work for me, is there a problem >>> with >>> it? >>> >>> >>> "Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message >>> news:%23SN8T33HHHA.3676@TK2MSFTNGP03.phx.gbl... >>> You might start with these pages: >>> >>> http://www.outlookcode.com/d/vbabasics.htm >>> http://www.outlookcode.com/d/vb.htm >>> http://www.outlookcode.com/d/zaphtml.htm -- various ways to process >>> incoming >>> messages >> >>> >>> "Keith" <me@here.com> wrote in message >>> news:er77RC2HHHA.2232@TK2MSFTNGP02.phx.gbl... >>>>I work for a large organisation and have reached the limit of my message >>>> rules, I therefore want to try and use VBA to move messages from certain >>>> people or with certain subjects to various sub-folders of my inbox (also >>>> consider exceptions e.g. 'Out of Office replies'). We use Outlook 2000 >>>> on >>>> a >>>> 2000 exchange server, I am completely new to VB in Outlook, can anyone >>>> give >>>> me the basics and I can build from them? > > |
|
|
|
|
| Thread Tools | |
| Rate This Thread | |
|
|
