Creating a new TASK using VFP9.0

Status
Not open for further replies.
B

bbettsack

I know this is a VBA group but I can't seem to get an answer from the VFP

group on this subject. I need to create a new TASK and send it to the person

I pick from a drop-down menu. This has to be done in FOXPRO (VFP9.0-SP2). I

can get to Outlook and create/send an email, but I can not figure out how to

create/send a TASK. Any help/sample code will be great.

Thanks in advance

Lost in Tampa
 
I don't have a clue as to how you'd do it in VFP, but if you are using the

CreateItem() method with an olMailItem argument to create a mail item

substitute the olTaskItem enum member instead.

From there you need to add various properties before you call the Assign()

method of the task. See the VBA object browser help for TaskItem.Assign to

see how to set what you need using VBA code. You will need to translate that

into VFP code.

"bbettsack" <bbettsack> wrote in message

news:AB771A1D-21D1-4D4E-A1DB-3B140FD613A1@microsoft.com...
> I know this is a VBA group but I can't seem to get an answer from the VFP
> group on this subject. I need to create a new TASK and send it to the
> person
> I pick from a drop-down menu. This has to be done in FOXPRO (VFP9.0-SP2).
> I
> can get to Outlook and create/send an email, but I can not figure out how
> to
> create/send a TASK. Any help/sample code will be great.

> Thanks in advance
> > Lost in Tampa
 
I figured out the code and am posting it here in case anyone else needs it.

* This program will create a TASK in Outlook (Office 2007)

oOutlook = CreateObject('Outlook.Application')

oNameSpace = oOutlook.GetNameSpace('MAPI')

oNameSpace.Logon()

loItem = oOutlook.CreateItem(3)

#DEFINE CR CHR(13)

WITH loItem

> Subject = 'New Task - test'

> Body = 'Here is the newest TASK that has been assigned to you.'

> Recipients.Add('user@email_address.com')

> StartDate = '05/01/2010'

> DueDate = '05/15/2010'

> ReminderSet = 1

> ReminderTime = CTOT(SYS(10,reminder_date) + ' 09:00')

ENDWITH

loItem.Save()

loItem.Assign()

loItem.Send()

=MESSAGEBOX('TASK Sent.',64,'Status')

Lost in Tampa
wrote:


> I don't have a clue as to how you'd do it in VFP, but if you are using the
> CreateItem() method with an olMailItem argument to create a mail item
> substitute the olTaskItem enum member instead.

> From there you need to add various properties before you call the Assign()
> method of the task. See the VBA object browser help for TaskItem.Assign to
> see how to set what you need using VBA code. You will need to translate that
> into VFP code.

> >

>

> "bbettsack" <bbettsack> wrote in message
> news:AB771A1D-21D1-4D4E-A1DB-3B140FD613A1@microsoft.com...
> >I know this is a VBA group but I can't seem to get an answer from the VFP
> > group on this subject. I need to create a new TASK and send it to the
> > person
> > I pick from a drop-down menu. This has to be done in FOXPRO (VFP9.0-SP2).
> > I
> > can get to Outlook and create/send an email, but I can not figure out how
> > to
> > create/send a TASK. Any help/sample code will be great.
> > Thanks in advance
> > > > Lost in Tampa

> .
>
 
Status
Not open for further replies.
< bing map | Mark copy of sent email as read - VBA? >
Similar threads
Thread starter Title Forum Replies Date
G Event when creating task from mailitem Outlook VBA and Custom Forms 2
L Creating a Task from Email and Attaching Original Email Outlook VBA and Custom Forms 6
Wotme Creating a Outlook task in Excel Using Outlook 7
J Text color when creating a new Task is not consistent Using Outlook 1
T Creating Task Views Methodically Outlook VBA and Custom Forms 7
Y Creating a Task with VBScript Outlook VBA and Custom Forms 14
G Creating Macro to scrape emails from calendar invite body Outlook VBA and Custom Forms 6
S Custom Contact card - need help creating one Outlook VBA and Custom Forms 1
D Outlook 2016 Creating an outlook Macro to select and approve Outlook VBA and Custom Forms 0
N Help creating a VBA macro with conditional formatting to change the font color of all external emails to red Outlook VBA and Custom Forms 5
T Outlook creating unwanted tasks in Tasks and Todo from emails Using Outlook 1
Fozzie Bear Outlook 2016 Creating a shared local Contacts folder Using Outlook 2
R Creating a user defined function Outlook VBA and Custom Forms 3
M Creating an RSS Feed **FROM** Outlook 2013 Calendar. Using Outlook 5
O How to prevent CC from showing when creating a new mail? Using Outlook 1
N Creating a button or link to a form in the Organizational Forms Library Outlook VBA and Custom Forms 3
B Creating an email with the list of tasks Outlook VBA and Custom Forms 0
L Creating drafts when I thought I was sending Using Outlook 1
R Would creating a new profile cause Outlook to download all the old mails from the server? Using Outlook 1
A Creating Progress Bar or Status Bar Update Outlook VBA and Custom Forms 0
T Outlook creating a folder named: "Unwanted" Using Outlook 3
M Outlook 2007 Contacts Glitch: Creating a new email Using Outlook 1
Liza Creating a rule in outlook to filter messages Using Outlook 0
A Are categories still recommended for creating local distribution lists? Using Outlook 3
S Creating Email - Selecting Pre-Defined Text Using Outlook 2
D Creating an outlook session from Access vba but run silently. With A specific profile Outlook VBA and Custom Forms 1
M Creating Outlook Appointments from Excel Cells Outlook VBA and Custom Forms 1
N Creating New Profile Using Outlook 0
Y Creating custom appointment request form with multiple mail recipients Outlook VBA and Custom Forms 5
M creating email from contact file = 3 emails in To field Using Outlook 3
P Recover / Extract Rules from standalone PST file creating RWZ file Using Outlook 2
A Creating an outlook rule to forward an email with a specific message Using Outlook 1
I Creating meeting invite with disabled tentative button Outlook VBA and Custom Forms 5
E Creating email templates for organizational use Using Outlook 0
N Creating or changing the main new mail message template in Outlook 2010 Using Outlook 2
D Creating custom view with VBA Outlook VBA and Custom Forms 2
J Outlook creating unwanted rule on its own Using Outlook 1
R Creating a Room Mailbox with Exchange Online Outlook VBA and Custom Forms 0
A Creating a rule on “Deleted items” folder Using Outlook 1
CMG73 Creating templates with predefined subject and CC Using Outlook 1
G Creating Contact Sub Folders Using Outlook 2
Rupert Dragwater creating gmail account in Outlook 2013 Using Outlook 7
nathandavies Creating a Select Case for a directory of folders Outlook VBA and Custom Forms 1
2 creating custom stationery Using Outlook 2
A Help creating macro for conditional formatting settings Using Outlook 8
Fozzie Bear Creating Custom Meeting Form Outlook VBA and Custom Forms 6
U Creating a (This computer only) folder within an IMAP account directory Using Outlook 1
A Creating archive rule on the clients by script/ Outlook VBA and Custom Forms 3
J Creating a URL from a message body excerpt before forwarding Using Outlook 2
B Need Help Creating Email Based on Subject w Address in Body Outlook VBA and Custom Forms 1

Similar threads

Back
Top