![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
I am trying to do something similar to this post:
http://www.microsoft.com/communities...9d2&sloc=en-us I have this code working: Sub CreateTask() Const olTaskItem = 3 Dim oOlookApp As Object Dim oOlookTask As Object Dim rng As Range Set oOlookApp = CreateObject("Outlook.Application") Set rng = Range("A1") While rng.Value "" Set oOlookTask = oOlookApp.CreateItem(olTaskItem) With oOlookTask .Subject = rng.Value .Save End With Set rng = rng.Offset(1) Wend End Sub This will create the tasks from a list in column A and assigns them to me. What I need is the tasks to be assigned to people who I have listed in column B. How can this code be modified to assign the tasks? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Creating a macro in tasks with text. | Mr. L | Outlook and VBA | 6 | September 24th 07 10:06 PM |
Deleteing Tasks in Outlook from Excel | J Streger | Outlook and VBA | 2 | July 10th 07 10:30 PM |
Automatically creating tasks/appointments from Excel workbooks | Nick | Outlook - Calandaring | 0 | May 17th 07 03:16 AM |
Outlook constantly creating Send/Receive Tasks | [email protected] | Outlook - General Queries | 3 | March 6th 07 04:50 PM |
Outlook 2k3 Script: Creating Borders in Excel | news.microsoft.com | Outlook and VBA | 1 | November 14th 06 05:19 PM |