Send Email from Various addresses?

[G]

Does anyone know of a way to send an email from various email addresses? I
have a server set up to periodically check an Access 2002 database for emails
that need to be delivered from various senders.

Gary

 

[John Nurick]

See Tony Toews's email FAQ at www.granite.ab.ca for emailing techniques.

Maybe it will suffice to send the messages _from_ the service account
with the "senders'" addresses in the Reply To field. Otherwise, you'll
need to ensure that the NT/AD account under which Access is running has
the relevant permissions on all the email accounts involved.