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!

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

Sending E-Mails from Access automatically 1

Status
Not open for further replies.

mike1975

IS-IT--Management
Jun 26, 2001
38
GB
Hi,
I am trying to make Access automatically send a report via e-mail on a certain day of the week - I am stuck with this one! Can anybody help me?

mike1975
 
Access Contains a daysofweek function that returns a numeric value for the day. Use the function to retrieve the current dates day. If the day value is equal to your needed day of week execute a sendobject macro with the name of your report. Access will automatically call your particular mapi email prgram. The Sendobject function also includes parameters to allow for automatically addressing the email.

hope this helped.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top