I've got an Access 97 database that I have created an automation object through Outlook in order to have an automatic email system to the people in the database.

My problem is the following: I want to specify an alias "from" field. I don't want to show it coming from the user's email, but instead I want it to look like it came from a general box at my company (info@....) That way when the recipient clicks reply, any responses will get routed to the general box rather than the user.

BTW: I have to use an outside email source (not Access's email function) because I need to attach outside files... not just reports etc from within Access.

I know Access's function allows you to put in an alias. Is there a way to do this with Outlook as well?

Thanks!