Auto Email

[derek7467]

Is it possible to have an email function built inside of my save button?



Once my user saves the form, I am auto emailed from access that a form has been filled out?

[ItsMe]

Yes CDO or emailing a report as an attachment using DoCmd.SendObject are probably the least intrusive approaches.

[derek7467]

Thanks, got it working, is there a way to bypass outlook opening and prompting the user to send? Can we silent send?

[ItsMe]

It sounds as though you are using SendObject

The false at the end will hide UI and send report
DoCmd.SendObject acSendReport, strReport, acFormatTXT, strTo, strCc, strBcc, strSubject, strBody, False

[June7]

Are you using SendObject? I don't think so.

Outlook has a setting to allow programmatic access but posters have said this fails. And each user would have to set this in their Outlook.

I use VBA that opens an Outlook object and manipulates it by addressing properties of the object. Does not use SendObject. I don't get the Outlook warning.

[derek7467]

June7, would you be kind enough to share your VBA with me? I would be eternally grateful!

[June7]

Common topic. Here is one thread https://www.accessforums.net/program...ook-21903.html

[ItsMe]

... I don't get the Outlook warning.

Interresting. I have been getting mixed results. I did some testing and got warning for both, sendobject and manipulating an Outlook object.

June,

do you use .Send and or .Save ?

[June7]

.DeleteAfterSubmit = True
.Send

I seem to remember getting the warning when I first built code but that was a couple of computers ago and haven't done anything special with current Outlook install. I don't even have the Allow Programmatic Access set.

Sorry, can't solve the mystery.

Maybe CDO gets around the warning?

[ItsMe]

I am taking a note of .DeleteAfterSubmit = True

CDO will definately avoid the warning. It does not consider Outlook, let alone depend on it. So if OP still needs another option....