>>>>>>>Has anyone had Fox exchange info w/Outlook's Calendar? I see that there's an import/export facility, but I wanted to make it real-time, if possible, with a program I wrote for a Physical Rehabilitation firm and its patients.
>>>>>>>
>>>>>>>I would prefer using Outlook for its other contact management abilities, but if anyone has a suggestion for a different database (Act! looked way too strange, with no import/export ability to the Calendar, even though it's a DBF), even something from a 3rd-party like Hallogram, pls let me know.
>>>>>>>
>>>>>>>JR
>>>>>>
>>>>>>
>>>>>>As others have told you, DDE is not the way to go. It is old technology. There are a couple of knowledebase articles at www.microsoft.com/msdn on interfacing VFP and Outlook.
>>>>>
>>>>>Meant to say OLE, not DDE. My mistake. Re VFP & Outlook, so far, so good. I've gotten it (the calendar) to fire from VFP using a KB article from the MSDN CD. I can't seem to find how to add a contact record directly from VFP into Outlook (I'm new to this OLE stuff). I looked at the Vbaoutl.hlp file and it seems like a lot hinges on these item indexes, which I can't find the table for. VFP has numbers representing these indexes, and VB has words. If anyone has any more clues, I'd appreciate it.
>>>>>
>>>>>I would want to purchase the book that Erik suggested, if I knew that it gave those numeric values as well.
>>>>>
>>>>>Thanks for all your help so far! I've gotten further than I expected in such a short time. This seems easier than I thought it would be.
>>>>>
>>>>>JR
>>>>
>>>>
>>>>One thing to keep in mind. Outlook uses VB Script, not VBA. I don't know if that makes a difference.
>>>
>>>Makes no difference to me, since I don't know what you're talking about! Hahaha! Something tells me I'll know before this whole learning experience is through. . .
>>>
>>>JR
>>
>>
>>Each is a slightly different variant of VB. VBA is Visual Basic for Applications. This is used by Office 97 products and is licensed to several other vendors. VBScript was designed for Internet use.
>
>Are you (Bill & Craig) saying that I need to get VB Script to have my VFP program be able to add a contact record in Outlook? Or is it that the commands use Script's variance, and not VBA? (FYI, I've ordered the book Erik mentioned straight from MS Press--should get it in a few days.) In my admittedly sophomoric viewpoint, it seems to me that there should be some command structure that allows one to add a record (I've gotten that part) and replace the data in the record with variables without too much trouble. I just need to change the value of, say, the First Name field to say "John," or "Mary," or whatever. I've gotten the rest of it. There's nothing straightforward in the help file that addresses this, though I used it and other Universal Thread messages to build the code I have so far.
>
>JR

Hi Joy,

So far I have been reading and writing VFP tables from Outlook using VB script and ODBC. But it would seem you should be able to automate Outlook from VFP and call the necessary Outlook VB script functions from VFP to do what you need to. A full install of Office 97 is necessary to use Outlook VB Script. The Office 97 install with the appropriate options installs the VB Script engine.

Bill