I'm using SendObject to send e-mail but it always brings up a dialog box titled "Choose Profile" that has a pulldown with my e-mail name in it. The other thing in this pulldown is "Microsoft Exchange". It has an options that says "Set as Default profile". I checked this option but next time I test my SendObject, this dialog is displayed again. I'm working on nightly maintenance VBA routine that attempts to send notification e-mail (i. e., Your document needs to be reviewed, etc.) to my users. This is an unattended operations so I don't want it to display this dialog and stop running until I come in the next day. Here is my code:
DoCmd.SendObject acSendForm, strForm, acFormatHTML, strName, , , strSubject, strMessage, False
Is there any fix to prevent this dialog from coming up. At a minimum, I need this fix to work on my PC. Ideally, this fix could easily be put on all my user's PC as I use SendObject to send e-mail based on User input also.