Google Answers Logo
View Question
 
Q: Outlook 2003 Macro ( No Answer,   2 Comments )
Question  
Subject: Outlook 2003 Macro
Category: Computers > Programming
Asked by: johneg-ga
List Price: $30.00
Posted: 14 Sep 2004 23:04 PDT
Expires: 15 Sep 2004 14:07 PDT
Question ID: 401385
I am interested in a quick Outlook 2003 Macro that will accomplish the following:

* Clear the Follow-up flag from the currently highlighted message(s)
* Move the currently highlighted message(s) to a designated folder (the
folder "Idea" in the "Personal Folders" group).

The flow should be something like this:

* Button is clicked on toolbar activating the macro
* Macro makes sure at least one email item is highlighted
* Macro creates dialog asking "Are you sure you want to clear the flag
on this message and move it to _Folder_?" [OPTIONAL]
* Macro steps through all highlighted email items and clears the
follow-up flag for each and moves each to the appropriate folder

Pretty straightforward, I just haven't written any VB for too long :)
Answer  
There is no answer at this time.

Comments  
Subject: Re: Outlook 2003 Macro
From: dreamboat-ga on 15 Sep 2004 09:08 PDT
 
I'm not a researcher, so this is a freebie.
And I had someone else write your code; I did not test it.
I assume you know how to use it?

Option Explicit 
 
Sub MoveItems() 
    Dim Messages        As Selection 
    Dim Msg             As MailItem 
    Dim NamSpace        As NameSpace 
    Dim Proceed         As VbMsgBoxResult 
     
    Set NamSpace = Application.GetNamespace("MAPI") 
    Set Messages = ActiveExplorer.Selection 
     
    If Messages.Count = 0 Then 
        Exit Sub 
    End If 
    For Each Msg In Messages 
        If Msg.FlagStatus = 2 Then 
            Proceed = MsgBox("Are you sure you want to clear the flag
and move the message " _
            & """" & Msg & """" & " to the folder " & """" & "Idea" &
"""" & "?", _
            vbYesNo + vbQuestion, "Confirm Procedure") 
            If Proceed = vbYes Then 
                Msg.FlagStatus = olNoFlag 
                Msg.Move NamSpace.Folders("Personal Folders").Folders("Idea") 
            End If 
        End If 
    Next 
     
End Sub
Subject: Re: Outlook 2003 Macro
From: johneg-ga on 15 Sep 2004 14:07 PDT
 
Thanks dreamboat -- that may just work.  I'll test it out and let you
know.  Thanks for your help!

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy