SendObject - Controlling "From" Field

[Joel]

All,

We have an Access XP database that e-mails query output to assorted
recipients using the SendObject command in an Access macro.

We need to modify the process so that certain e-mails are sent from
one Outlook mailbox (Joel) and other e-mails are from another Outlook
mailbox(departmental mailbox called "Holdings"). I have Outlook
rights to send e-mails from both mailboxes. Currently, by default
Access sends all e-mails from my mailbox.

Does anyone know how to accomplish this? Any ideas would be
appreciated.

Regards,
Joel

 

[Steve Schapel]

Joel,

As far as I know, this is not possible with a SendObject macro. The
only way this could really be done is to run the macro for those emails
that are supposed to go from 'Joel', then manually change the default
account within Outlook, then run the macro again for those that are
supposed to go from 'Holdings'.

Other options would include using a third party utility such as Total
Access Emailer from www.fmsinc.com, or send your emails using Outlook
automation vba procedure for which
http://support.microsoft.com/?kbid=209948 may point you in the right
direction.