E-mailing an access for on close

[FSUFan4]

I want to be able to e-mail a record from Access using my Default Microsoft Exchange Outlook server when I close the form in access. Upon clicking the X, I want it to send the e-mail.

When I try it it comes up asking for my POP and SMTP info, but we are on an exchang server.

Someone please help!

 

[rjoubert]

It might help if you post the code you're using to send the email.

 

[FSUFan4]

I don't know what the code is nor how to check. I am an Access Novice.

 

[FSUFan4]

Basically I have a mcro setup named M_EMAIL, conditions are where ms_job=1, then it has SetWarnings, SendObject, OpenQuery, SetWarnings.

I go to VB editor but the option to view code is grayed out.

 

[rjoubert]

I'm not sure you're going to be able to accomplish what you want without some VBA code. Check out #12 in the list of SendObject's Twenty limitations here...

http://www.granite.ab.ca/access/email/sendobject.htm

 

[FSUFan4]

Thanks for the link.

Unfortunately I am too rusty on VB to even attempt, so I guess this feature will have to be left out.

 

[FSUFan4]

Would the layout be like this?

OnClose
'close form'
'mail message to certain recipients'

?

Seems like it'd be easy but who knows.