![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
Board Regular
Join Date: Feb 2002
Location: Where the wild roses grow
Posts: 285
|
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 damn 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 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Bogota, Colombia
Posts: 11,927
|
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. |
|
|
|
|
|
#3 |
|
Board Regular
Join Date: Feb 2002
Location: Where the wild roses grow
Posts: 285
|
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 |
|
Board Regular
Join Date: Feb 2002
Location: Where the wild roses grow
Posts: 285
|
Has anyone got an idea about this? It's only a small thing but it's really bugging me? |
|
|
|
|
|
#5 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Bogota, Colombia
Posts: 11,927
|
I believe it should work with
.FlagStatus = olFlagMarked |
|
|
|
|
|
#6 |
|
Board Regular
Join Date: Feb 2002
Location: Where the wild roses grow
Posts: 285
|
THANK YOU!!!!!!!!
Ah, sweet relief... |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|