Hello everyone,
I work for a company in Belgium as the systems and network administrator.
A couple of years ago we've replaced our archiving software by some rubbish program that didn’t do what it was supposed to do.
After struggling with troubleshooting the application, I wrote a custom program to read the barcodes on the scanned documents and save the data to a MySQL database.
Long story short: link the order numbers to the correct documents based on the barcode.
As there is A LOT of mailing going on with the customer and internal departments, we’d like to archive mails in the same manner.
Now I was thinking of modifying our Exchange Online setup and adding a custom connector.
All mails that are being sent to DOESNTMATTER@archive.COMPANYNAME.com should be sent to a custom SMTP server (which runs on one of our servers).
This application then checks if DOESNTMATTER is an actual order number in our system.
If so ==> Convert the mail to a PDF (and also it’s attachments) and save the documents + write the document name and order number into the MySQL database.
If not ==> park the mail in some folder, where I can then manually control and correct.
Do you guys think this could be achieved with a c-sharp application?
My biggest struggle is the actual SMTP server. Creating the Exchange connector and handling the actual mails that are coming isn’t a problem.
Thanks for your reply!
What I have tried:
Nothing much really, been looking to find similar projects to help me on my way, but nobody seems to have the same needs :-(