Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need help writing macro

Status
Not open for further replies.
morrow314

morrow314

MIS
Apr 10, 2000
12
0
0
US
I have a macro that sends my e-mail, but I want it to run ONLY on Fridays. This is probably easier than I think but I'm at a loss. Any help is appreciated!
 
Sort by date Sort by votes
Add some code to the timer event of a form. Something like:

if weekday(date) = 5 then
sendmail
end if

(i think 5 is friday)

The only thing is the form has to be open.

Nick
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
Long-established database suddenly giving error Cannot open macro [Name] because it is not valid
Replies
6
Views
153
dhookom
dhookom
MikeRei
  • Locked
  • Question
Help taking horizontal data and displaying it vertically (continuously)
2
Replies
27
Views
334
dhookom
dhookom
atadbitslow
  • Locked
  • Question
need help with syntax for a date
Replies
3
Views
71
dhookom
dhookom
Moss100
  • Locked
  • Question
Using data macro to alert user when record is added to a table.
Replies
2
Views
54
Andrzejek
Andrzejek
TheresAlwaysAWay
  • Locked
  • Question
Need help finding where a number lies within a set of values 1
Replies
3
Views
67
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top