Access 97 & MSOutlook Automation

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!

[rockies1]

I'm not sure if you can do that...Or how to do it if you can.

My approach for this was just to have my company set up a dummy e-mail account and have it opened as the sender...

I like it, and it keeps me from getting all the nasty e-mails back!!