
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.