ukdane
09-23-2009, 12:35 AM
Hi,
I've previously had success with generating an appointment in Outlook, via Excel (see thread here: http://www.vbaexpress.com/forum/showthread.php?t=25423&highlight=calendar)
However, my client now wants the details to be compiled as a TASK in outlook, instead of an appointment.
How do I change the code in order to be able to use it to generate a task?
What are the various OL item names (ie in Contacts, OLAppointment.Subject refers to the subject line)?
Thansk for your help.
I've previously had success with generating an appointment in Outlook, via Excel (see thread here: http://www.vbaexpress.com/forum/showthread.php?t=25423&highlight=calendar)
However, my client now wants the details to be compiled as a TASK in outlook, instead of an appointment.
How do I change the code in order to be able to use it to generate a task?
What are the various OL item names (ie in Contacts, OLAppointment.Subject refers to the subject line)?
Thansk for your help.