Macro Date Issue

ipr1

Registered User.
Local time
Today, 18:26
Joined
Jun 13, 2003
Messages
31
Hi - I want to create a macro that will send an email report ("STATS") to a person ("JOE_BLOW@zzz.com") during the period from 8/13/07 to 8/17/07. For all other times I would like to send out the same email report ("STATS") to a different individual (CHARLES DOE@zzz.com").

I am currently using a macro condition as follows: "Date()>=#8/13/2007# And Date()<=#8/17/2007#" to trigger the send object command for JOE BLOW.

I am also using a macro condition as follows: "Date()<=#8/10/2007# And Date()>=#8/20/2007#" for Charles Doe's email.

Am I OK here or is there a better preferred method. Thanks folks for your help.

ipr1@comcast.net
 

Users who are viewing this thread

Back
Top Bottom