Skip to main content

Outlook Automation with VFP

An overview of how to automate Outlook with Visual FoxPro.

Comments

Anonymous said…
Hi. I've used the FIND command to find an email msg, task or appointment. What I have a pbm with is the very first time you initiate the find, it takes MINUTES. It acts like it's indexing or something. Then after that initial find, the next time you try to find anything, bam! it finds it (or not) in less than 1 second.

Ideas?
12:16 AM
Anonymous said…
Excellent article. Thank you for taking the time to write it. One other issue I'm having is I am (here we go again), finding a public folder and once I find it, I want to display it on screen. I have the object (ie oCalendarFolder) and when I call oCalendarFolder.Display it shows the window, but also returns an error "Display is not a member object".

Ideas?
12:18 AM
Anonymous said…
How can Outlook be configured so when my vfp app wants to use it to email a file it doesn't constanly ask if its ok?
2:24 PM
Anonymous said…
Forgive my ignorance. I'm new to this way of coding.
Can you tell me the difference in what you've outlined in your white paper where you write:
loApp = CREATEOBJECT("OUTLOOK.APPLICATION")
loSpace = loApp.GetNameSpace("MAPI")
loFolders = loSpace.Folders
loItems = loSpace.Folders.Items

and the follwing:

LOCAL loOutlook, loHandler
loOutlook=CREATEOBJECT( [Outlook.Application] )
loHandler=NEWOBJECT("OutlookHandler")
EVENTHANDLER( loOutlook, loHandler )
SUSPEND
DEFINE CLASS OutlookHandler AS session OLEPUBLIC
IMPLEMENTS ApplicationEvents_10 IN {00062FFF-0000-0000-C000-000000000046}#9.1
PROCEDURE ApplicationEvents_10_ItemSend(Item AS VARIANT, Cancel AS LOGICAL) AS VOID
* add user code here
ENDPROC
1:36 PM
Andrew MacNeill said…
Dan,

Great question. The main difference is one of how you react to items. The first approach is useful for actively looking for items without worrying about what the user is doing. You aren't told if there are new emails or new items added - it's more if you are adding items automatically or reviewing existing items.

Using the IMPLEMENT approach, you are able to interact with what the user is doing. For example, when a new message comes in, your Outlook handler can react to it automatically. When a user clicks a button, you can react to it further. There's more code required but more available actions to work from.

For example, if your application, wants to react to new messages as they come in, you would need to use the IMPLEMENTS approach.

Make sense?
9:59 AM
Post a Comment

Popular posts from this blog

Using VFPX : A Walkthrough features in CodePlex

This white paper is from a session originally given at Southwest Fox 2008, introducing many developers to how CodePlex works and how they can get involved with the VFPX Project. You can also hear the audio of this session here . So you want to help out in VFPX? This session goes through how to get started with the VFPX Project and dealing with issues like source control, the Wiki-style attitude of Codeplex and more. What Is VFPX? VFPX is the future of the Visual FoxPro IDE and developer tools we currently know today. It is based on the VFP 9 SP2 core but realistically, it is more like taking all of the tools that have grown up around the VFP engine and making them ours to grow and enhance. Microsoft is no longer doing active development on Visual FoxPro; the product is officially supported until 2015 but then many developers still have VFP 6 applications running and VFP6 support ended in 2004. Visual FoxPro has a long running tradition of community enhancements. Back in 1990, the
Post a Comment
Read more

Prototyping Applications with Sketchflow

How many times have you needed to present visual concepts behind your application to a client? Over the years, I've had several times where I had to build a quick mock-up in Visual FoxPro to show how an application or function might run. Designing the screens themselves weren't the challenge - the challenge was showing the user how the application would flow between different areas. Short of putting fake code into buttons or saying "and now we go here", there really hasn't been an easy way to do this. Now, sometimes, a client has gone so far as to hire someone to build "wireframes" to depict this. I found this process an entire waste of time. People building wireframes tend to be "business analysts", in short; people who have stopped learning how to develop code but still want to show their value by being the translator between the client and the developer. As far as I'm concerned, if you want to be a senior developer, you need to be able
Post a Comment
Read more