printmedia
asked on
Save emails sent from iPhone into our database
Hi all.
Our current Outlook (via Office365) asks the end user the following question everytime the end user clicks the "Send" button. If the end user clicks YES then it imports the email body, subject etc. into our database: "Do you want to add this email to our system?"
This has worked great for us for a while because our end users are doing this from their desktops here in the office. Some of our sales people are beginning to travel more often and so any emails they send out from their mobile phones are not asked the same question and therefore not imported into our database.
Is there a way to do this using the Outlook for iOS iphone app? We would send the email to a web server and then we would download it from the web server to our in house server.
Or is there another solution out there that might work?
Thank you in advance!
Our current Outlook (via Office365) asks the end user the following question everytime the end user clicks the "Send" button. If the end user clicks YES then it imports the email body, subject etc. into our database: "Do you want to add this email to our system?"
This has worked great for us for a while because our end users are doing this from their desktops here in the office. Some of our sales people are beginning to travel more often and so any emails they send out from their mobile phones are not asked the same question and therefore not imported into our database.
Is there a way to do this using the Outlook for iOS iphone app? We would send the email to a web server and then we would download it from the web server to our in house server.
Or is there another solution out there that might work?
Thank you in advance!
ASKER
Thank you for your reply.
But I want to be able to have a pop up appear in the Outlook for iOS app where it asks the end user if they want to import that email to our custom database (as it does with Outlook on our desktops). Does the iOS app allow for this type of customization like the desktop version of Outlook?
Otherwise, my mobile end users need to open their desktop Outlook and manually drag and drop the email into our custom application instead of the email directly going into our custom database if they click "YES" in the pop up message that appears when they click the Send button on the desktop version of Outlook.
But I want to be able to have a pop up appear in the Outlook for iOS app where it asks the end user if they want to import that email to our custom database (as it does with Outlook on our desktops). Does the iOS app allow for this type of customization like the desktop version of Outlook?
Otherwise, my mobile end users need to open their desktop Outlook and manually drag and drop the email into our custom application instead of the email directly going into our custom database if they click "YES" in the pop up message that appears when they click the Send button on the desktop version of Outlook.
Oh, I misunderstood, sorry.
How is that customization added to the desktop?
One of the issues with iOS (or any Apple OS for that matter) is that they isolate so much now by sanboxing everything, that often those kinds of addons are just not available on iOS.
How is that customization added to the desktop?
One of the issues with iOS (or any Apple OS for that matter) is that they isolate so much now by sanboxing everything, that often those kinds of addons are just not available on iOS.
ASKER
I added the VBA code to the ItemSend event in Outlook.
I see what you're saying, just wanted to know if it was even remotely possible. I'm leaning towards having the mobile user move the sent email to a "Sync" folder that our system would import from on an hourly basis.
I see what you're saying, just wanted to know if it was even remotely possible. I'm leaning towards having the mobile user move the sent email to a "Sync" folder that our system would import from on an hourly basis.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Also, read this forum for some discussion on VBA and Applescript for Apple. It might shed some ideas on what is possible.
https://forums.macrumors.com/threads/vba-applescript.2046255/
https://forums.macrumors.com/threads/vba-applescript.2046255/
I have one other question: Are they using Apple mail to read their mail on iOS or a Microsoft Outlook app?
Since Microsoft supports VBA (to a point) in their iOS apps, using their app to read the mail might work.
Just curious.
Since Microsoft supports VBA (to a point) in their iOS apps, using their app to read the mail might work.
Just curious.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you both for all your help! It looks like we're going to work on the SYNC folder and see how that goes.
ASKER
Hi Eoin OSullivan. We have Office 365 if my end users cc a generic email how would we download into our sql server 2008?
The generic email can have a forwarding rule on it I would expect. You should ideally be using bcc or the intended To recipient will see it and end up replying to the same mailbox
The iOS device would need to be set up such that the SMTP send address for that account was that of your Office365 server and not some other outgoing email service. Emails sent via, say, iCloud, would be most likely lost to you. You should look at the account setting for Outlook and see what server they are using for outgoing SMTP mail. I would also look at the Outbox on an iOS device to see if the emails are indeed in a SENT mailbox and are not syncing to the server for some reason. On the left side of iOS mail, scroll below the incoming mail and mailboxes, and find the Outlook account. Expend that if necessary and click on Sent. It should contain all the sent emails on that account on that device. If not, the account is set up on that device to use another outgoing email service, or the security settings on the SENT mailbox are preventing them from being saved.
You might look at the headers of a test message sent from such a device to see the path the message took to see if it is using another SMTP service.
Under settings for Office365 (Outlook) I only see Use SSL, where to move deleted mail (Deleted Mailbox or Archive Mailbox), IF to store Drafts on the server, and S/MIME on or off. No setting there on what to do with SENT messages, so by default, they should go into the SENT folder of the account they wer esent from.
I just configured a test Office365 account, and sent a message from an iPad. I did not receive any popup asking me to save the sent message, and it was saved successfully in the SENT mailbox on the Office365 server. The only worry I would have is if the user purged their SENT mail, it might delete those from the server.
One other option here would be to TURN ON "always BCC myself" in the iOS email options setting (Settings -> Mail -> Composing section -> Always Bcc Myself set to on. Then the sent message would end up in the senders inbox and can be saved that way.