I have an Access 2K DB that contains certain fields I want to pull into
an Outlook 2K task.
Here is my code:
--------------------------------------------------------
Function AddOutLookTask()
Dim appOutLook As Outlook.Application
Dim taskOutLook As Outlook.TaskItem
Set appOutLook = CreateObject("Outlook.Application")
Set taskOutLook = appOutLook.CreateItem(olTaskItem)
With taskOutLook
..Display
..Subject = "" ' I'd like to have my Client ID field here
..ReminderSet = False
..DueDate = "" ' I'd like to have my Next Contact Date field here
..Save
End With
End Function
--------------------------------------------------------
Here's the question (don't laugh ;)), what do I type so I can pull my
data from the DB? I placed the field names but kept getting this
error: Compile error: Variable not defined. I know I'm missing
somehting simple.
Thank you in advance for your help!