Sending an automatic Email

[Keith]

Is there a way that depending on the user that makes an entry into the mail
form an email is sent to their manager.

It's a holiday request database. What I want to do is when an individual
inputs a holiday request their manager is sent an Email telling them that
there is a holiday request needing approval.

I know how to identify the user I just need to know about the Email bit.

 

[Tony Toews [MVP]]

Is there a way that depending on the user that makes an entry into the mail
form an email is sent to their manager.

It's a holiday request database. What I want to do is when an individual
inputs a holiday request their manager is sent an Email telling them that
there is a holiday request needing approval.

I know how to identify the user I just need to know about the Email bit.

SendObject would be the simplest method. You'd need to use an event
such as AfterUpdate.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Keith]

HI Tony,

That worked great. I only have one small problem. When Access sends the
Email (I have it setup to not bring up the message first) I get a warning
message that allows the user to cancel the Email.

IS there a way to stop this? I've tried setwarnings but it made no
difference. Or is this a question I should post onto the Outlook Newsgroup?

 

[Douglas J. Steele]

Assuming you're using Outlook as your e-mail client, check out
http://www.slipstick.com/outlook/esecup.htm

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)