Hi Neel
You can set up multiple email aliases pointing to a single mailbox, so all your inbound messages are delivered to the same place. You then have the address it was sent to in the To: address, so you can use workflow to set row level access etc. based on that value. For outgoing mails, again you can use a single outgoing account, but set the From: and Reply-to: addresses through workflow. The only way to manage the size taken up by your attachments (they are already compressed) is to delete old records. HTH David Sanders Remedy Solution Architect Enterprise Service Suite @ Work ========================== ARS List Award Winner 2005 Best 3rd party Remedy Application See the <http://www.westoverconsulting.co.uk/downloads/ESS_Concepts_Guide.pdf> ESS Concepts Guide tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk <http://www.westoverconsulting.co.uk/> _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of SUBSCRIBE arslist Neel Sent: Tuesday, May 01, 2007 5:04 PM To: [email protected] Subject: How to reduce Inbound/Outbound mailboxes & attachment space. Importance: High Hello fellow-listers, The application we are developing support multiple BPOs, each BPO has multiple companies and each company has multiple support-groups. Now, we have an staging form with table fields to show emails from 'AR System Email Messages' form and we have multi-tenancy defined on this staging form (on the table field) so users can see only emails sent to any of the support-groups they have access to. Because of this design, we have mailbox set-up for each support-group and now we have about 150 incoming and 150 outgoing mailboxes and it's increasing exponentially as new bpo/company comes on-board. I think this seems like a common problem many people might have faced already. If so, is there any strategy or an approach to reduce number of mailboxes (at the same time I need multi-tenancy on email records as well)? Also, along the same lines, any efficient ways to store attachments for emails? Attachments are quickly filling out the db server space. Any ideas/suggestions are welcome. Thank you, Neel Gautam This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
