Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Outlook Command

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    Afternoon you crazy cats,

    I have some lovely VB code in a module to send an email, it contains such gems as:

    .subject "My friend fancies you"
    .body "Tick YES or NO"

    and other such crud. But can anyone tell me what the command line is to make the mail flagged for follow up?

    I've tried .followup but no **** good

    First person to help me gets my total admiration until 5:04pm GMT, when I expect to find another problem that needs solving

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try with

    .FlagStatus
    .FlagDueBy
    .FlagRequest


    -------------

    FlagDueBy Property
    See Also Applies To Example Specifics
    Returns or sets a Date specifying the date by which this mail message is due. This property is only valid if the FlagStatus property is also set for the message. This property corresponds to the MAPI property PR_REPLY_TIME. Read/write.

    expression.FlagDueBy

    expression Required. An expression that returns one of the objects in the Applies To list.

    ------------------------

    FlagRequest Property
    See Also Applies To Example Specifics
    Returns or sets a String indicating the requested action for the mail message. This is a free-form text field. This property is only valid if the FlagStatus property is also set for the message. Read/write.

    expression.FlagRequest

    expression Required. An expression that returns one of the objects in the Applies To list.

    ----------------------

    FlagStatus Property
    See Also Applies To Example Specifics
    Returns or sets an OlFlagStatus constant indicating the flag status for the mail message. Read/write.

    OlFlagStatus can be one of these OlFlagStatus constants.
    olFlagComplete
    olFlagMarked
    olNoFlag


    expression.FlagStatus

    expression Required. An expression that returns one of the items in the Applies To list.



    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    Thanks for the reply, I can't get it to work though. What single command should I be inserting that will put a follow up flag on the mail?

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    Has anyone got an idea about this? It's only a small thing but it's really bugging me?

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I believe it should work with

    .FlagStatus = olFlagMarked
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    THANK YOU!!!!!!!!

    Ah, sweet relief...

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •