PC Review


Reply
Thread Tools Rate Thread

Creating Outlook Task from Excel

 
 
Bugman
Guest
Posts: n/a
 
      17th Jan 2008
Building on this same principle... I would like to copy and paste a selection
of visible cells (meaning some columns could be hidden) into the Body of a
task. I would also like to keep the MS Office Excel Worksheet format. I have
the following code:

Sub ScheduleTask()
Dim OLF As Outlook.MAPIFolder
Dim olTaskItem As Outlook.TaskItem

Set OLF = GetObject("", "Outlook.Application").GetNamespace
"MAPI").GetDefaultFolder(olFolderTasks)
Set olTaskItem = OLF.Items.Add ' creates a new task
With olTaskItem
.Subject = ActiveCell.EntireRow.Cells(1, 1).Value
.DueDate = #2/1/2008#
.ReminderTime = #1/21/2008 1:00:00 PM#
.ReminderSet = True
.Body = ???

.Save
End With
Set olTaskItem = Nothing
Set OLF = Nothing

End Sub

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating task in outlook from a particular row in excel thecelebration@gmail.com Microsoft Excel Programming 1 28th Jan 2008 11:11 PM
Use custom task form in Outlook 2003 when creating task in ON 2007 Bobby C Microsoft Access 1 1st Jan 2008 05:39 PM
Creating a task in Outlook from a date in Excel =?Utf-8?B?SmFtaWVAV2lsZGNhcmQ=?= Microsoft Excel Misc 4 3rd Jul 2007 04:54 PM
Creating a task in outlook =?Utf-8?B?UGFzdHk=?= Microsoft Excel Programming 0 23rd Mar 2007 02:07 PM
Creating an Outlook Task Keith Microsoft Access Form Coding 1 21st Sep 2003 03:24 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:23 AM.