Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can you have RDBMS in Outlook using VBA
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00291142
Message ID:
00291736
Views:
19
Hi Fred...

Believe it or not, you are actually going to get a response you can use here...<bg>

What you are referring to is assigning tasks to clients. As John Koziol pointed out, it is a piece of cake. However, he did not provide you with the sample, or should I say, the cake in this case....<s>.

OK, here goes. The following code creates outlook, creates a task, assigns the task to a person in your contacts folder, and sends it off:


*/ Item Constants

#DEFINE olMailItem 0
#DEFINE olAppointmentItem 1
#DEFINE olContactItem 2
#DEFINE olTaskItem 3
#DEFINE olJournalItem 4
#DEFINE olNoteItem 5
#DEFINE olPostItem 6

*/ Folder Constants

#DEFINE olFolderCalendar 9
#DEFINE olFolderContacts 10
#DEFINE olFolderDeletedItems 3
#DEFINE olFolderInBox 6
#DEFINE olFolderJournal 11
#DEFINE olFolderNotes 12
#DEFINE olFolderOutBox 4
#DEFINE olFolderSentMail 5
#DEFINE olFolderTasks 13

oOutLookObject = CREATEOBJECT("Outlook.Application")
otaskItem = oOutlookObject.CreateItem(olTaskItem)
otaskItem.Assign
otaskitem.subject = "Cool!!!"
oTaskItem.Recipients.Add("Rod Paddock")
oTaskItem.Send


For every person you assign, you need to invoke the add method of the recipients collection of the task item object.

Let me know if you have any other ?'s. This should however, give you a good start....
Previous
Reply
Map
View

Click here to load this message in the networking platform