SES (System Event Scheduler) is an app that lets you put your phone in silent mode or offline mode by time of day and day of the week.

Also, Mail for Exchange lets you set "Peak" and "Off-Peak" synchronization schedules with the server, and your "Off-Peak" schedule can include "sync manually only." I don't think that works for non-Exchange mail accounts though (webmail, POP accounts, etc).