Creating and Outllook Message In Access With Flag Properties On 
Author Message
 Creating and Outllook Message In Access With Flag Properties On

hello, hopefully you can help.  I am running an automated email from a form
I have in a database, it all works fine, but I want to set the flag
propeties for the message to On, and set the reminder date to 2 weeks from
current date.  How do I reference the Oulook objects FlagRequest and
FlagDueBy in my module an set them to what I want?

thanks

scott



Sun, 05 Jan 2003 03:00:00 GMT  
 Creating and Outllook Message In Access With Flag Properties On
Scott,
Go to Outlook, Press Alt F11 to open the VB editor.
Open a code module type "flagdueby" (no quotes) and press F1.
All will be revealed.
You have to set the FlagStatus property first.

--
Hope This Helps,
Jeff Davies


Quote:
> hello, hopefully you can help.  I am running an automated email from a
form
> I have in a database, it all works fine, but I want to set the flag
> propeties for the message to On, and set the reminder date to 2 weeks from
> current date.  How do I reference the Oulook objects FlagRequest and
> FlagDueBy in my module an set them to what I want?

> thanks

> scott



Mon, 06 Jan 2003 03:00:00 GMT  
 Creating and Outllook Message In Access With Flag Properties On
Mayby that code could Help You :
Create a module
Add A reference To be able to access Outlook object :
Microsoft outlook  ....(or something like this which start by Microsoft
Outlook but not the outlook express)

'Example of outlook object
'Create an email and send it

'All code for outlook must start like this
Dim objOutlook as new Outlook.Application
'now the program
dim objMail as mailitem
set objMail = objOutlook.createitem(olMailItem)
with objMail
  '... for All Option -> See the doc (I don t know the flag ones
  'but there are 3 options that start by .flag..

  '.FlagStatus = ??'So see the doc
  '.FlagDueBy  = ??
  '.FlagRequest = ??


  .subject = "Coucou"

  .send
end with
set objMail = Nothing

'To open a email in outlook from access
'See the exemple of doc : mailitem object

I hope that this code could help you !



Quote:

> hello, hopefully you can help.  I am running an automated email from
a form
> I have in a database, it all works fine, but I want to set the flag
> propeties for the message to On, and set the reminder date to 2 weeks
from
> current date.  How do I reference the Oulook objects FlagRequest and
> FlagDueBy in my module an set them to what I want?

> thanks

> scott

Sent via Deja.com http://www.deja.com/
Before you buy.


Mon, 06 Jan 2003 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. How to access/change message flags

2. How to create installation file (setup.exe) for my VBA code in outllook

3. Access with Outllook

4. Manipulate message flags

5. Save Sent Message flag?

6. enigma for Sue = message flags

7. Running a access Form from Outllook

8. help with Access/Outllook procedure

9. Moving embedded messages to folders / Unread Flag

10. Custom item and flag property

11. Flags Property (Open,Save As Dialogs)

12. Color Dialog Box Flags Property

 

 
Powered by phpBB® Forum Software