MrExcel.com - Your One Stop for Excel Tips & Solutions

E-mail for certain day

Posted by Jonathan on April 19, 2001 2:25 PM

I have written some code that e-mails a report automatically. On Wednesdays only, I need to include one additional person. How can I tell it for Wednesdays only, to add that persons e-mail?

Posted by Dave Hawley on April 19, 2001 7:38 PM


Hi Jonathan

Try this

If Weekday(Date) = vbWednesday Then MsgBox "Guess What"


Dave


OzGrid Business Applications