Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can you have RDBMS in Outlook using VBA
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00291142
Message ID:
00291736
Vues:
20
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....
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform