Getting error with DateDiff 1

[ktskiro]

I found a code on how to do a mass email from this site and it works great. But, now I am having problems with the DateDiff format. I have about 50 users that utilize the database daily. There are 3 versions of Outlook that are used here by the users. One User might have Outlook 2003, another might have Outlook 2000, and others have Outlook 97. Now when I created the code for Mass Emailing, I had to add the reference to Outlook. Now the reference is different for each version of Outlook. I have come to problem when a user has Outlook 97 on the computer they get an error when logging onto the DB, etc. The error is as follows:

DateDiff("yyyy",[start Date],Date())

Now, the only way I have figured out to fix this is to fix the reference every day. This is becoming a problem. Is there a way to fix it once and have no more problems with this. Any help is greatly appreciated.

 

[mik18]

Have them update to Outlook 2003.

 

[MichaelRed]

It is possible to locate and identify the specific version(s) of applications through a number of resources. Many of these are well documented herein (Tek-Tips fora). Some investigation (on your part) via the Search capability should reveal these. Once identified, the app reference(s) may be chacked aginst the installation and adjustments made as necessary. All can be implemented programatically, but it may require a bit of effort on your part. Consider this a "Learning experience".





MichaelRed

 

[PHV]

You may also consider late binding instead of early binding to avoid the need of referencing the Outlook library.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244