I have set up a system that processes Excel files which have been sent to me at an Outlook public folder (e.g. Public Folders / All Public Folders / My Division / My Department).
If the Excel file has been completed correctly, an Excel macro will process it. If not, it will be rejected.
I want to give feedback for each file letting the sender know whether their file has been processed or not. However, I don't want to send these confirmations from my personal e-mail address as I will be deluged with hundreds of queries. Can send an e-mail so that it will look as though it came from the public folder to avoid them contacting me personally?
(Just to reassure people, I plan to include a disclaimer message alerting people to the fact that the public folder is run as an automated process and that queries should be directed to the department in the usual way.)
Is it possible to send e-mails from the public folder? How can i do this?
If it is not possible, how can I avoid being swamped by replies to my personal account?

Have your administrator(s) set up an Outlook account specifically for this purpose. There will be a resultant InBox for that account, but you never have to read the emails in it. Plus, you can set up an Out of Office response for that InBox to tell users that the mailbox is not monitored, contact an administrator for assistance.

So, you'll have an account with a meaningful name (like [email protected]), an InBox that no one needs to monitor, and a response mechanism to get users to behave themselves.