When I send an email from Access with SendObject, how does it determine the user name, the 'from' name. Is it just the user's Outlook name? Do I have any control over that?
SendObject uses the default email client. You can change the "from" using Outlook automation and SendOnBehalfOf (or something like that) or CDO, which bypasses Outlook and lets you specify the user.
