What I’m trying to do:
Determine the best way to manage email in email tables.
What I’ve tried and what’s not working:
It’s not that anything isn’t working but am seeking for other ways that folks have managed managing email functions, including composing, spam, etc. I’m receiving some spam at the moment and am wondering: are folks always redirecting email to another external email account like Gmail etc to better handle tracking, folders, replies, etc?
Or have folks built entire interfaces in Anvil just to manage email? Marking as read, composing, reply, reply-all, spam, etc. I would hate to reinvent the wheel and am wondering how far other folks have taken writing custom python to do this.
The reason I don’t forward everything right now is because, a few months ago, there was some glitch which looked like it was from Microsoft that automatically generated like over 1000 forwards and filled up the quota in the span of a few seconds (I’ve since upgraded to larger tier).
So I’m wondering if I have to build an entire email client from scratch or forward everything. Appreciate your thoughts on this!
Most of my apps send and receive emails only from internal users. For these apps I often use Outlook groups to send and receive emails in apps.
Apps send emails to an Outlook group. Employees can join or leave the group to receive emails from the app. This allows the app not to worry about who receives the email. The app has one or more group email addresses, often hardwired int the code. Set and forget.
Apps receive emails from an Outlook group that is setup to forward to the app the emails it receives.
Using Outlook groups allow me to use Outlook as mailbox, so I can see the email traffic to and from the app. The app worries abut composing and sending emails, or receiving them, checking if they should be used and use them.
For apps that send or receive emails from external users, I just add a row to a log table and keep no formal record about sent or received emails in the app.
1 Like
This might be good for managing email from internal users, but sounds like i need to build an email client for all of the normal functions. Wondering if anyone else has experience in this area
It depends on what you mean by “normal functions”.
I don’t like to reinvent the wheel. My company uses Outlook, so I delegate as much as I can to Outlook, and keep the emails in Anvil restricted to sending notifications (if possible from the app to an Outlook group, and sometimes from the app directly to the recipients) and receiving instructions (the app will process the received email, and, maybe, log somewhere about it).
That’s “normal functions” for me 
.
Anything more than that is “normal functions” for Outlook, not for my Anvil apps.
1 Like
Yeah, makes sense to use a robust tool like Outlook for all the ‘normal’ functions. My concern was forwarding. The new tier I’m on has a 100k emails per month I can forward to another tool, which should be enough for this small site. Thanks @stefano.menci