Email

[Guest]

I am trying to automatically send emails from Access 97. I want the emails
to all have the same FROM name (a generic mail box that was setup for this
app). Do I need to Delegate Author permissions to all of the users of the
Access 97 app in order for them to be able to send the emails on Behalf of
the Generic Mailbox? Thanks for your help.

Weste

 

[Guest]

The easiest method is to create an Outlook profile that points to that
generic mailbox, and use Outlook's NameSpace.Logon method to choose that
profile. Then you can send e-mails using that account.

If you use the Access SendObject method for sending a database object in an
e-mail, you do not have the ability to specify a particular profile, as it
will use the default one.

Otherwise, see this thread for other options:

http://groups.google.com/groups?hl=...=group%3Dmicrosoft.public.outlook.program_vba