outlook.com Exchane Server corrupts data Since September 2019

Not open for further replies.


Outlook version
Outlook 2016 32 bit
Email Account
Exchange Server

Pay attention if you have Customized Forms and User-Defined field of "Currency" type.

Approx. since September 2019, after syncing to outlook.com, those fields will be corrupted/zeroed.

I have described it here
Upgraded Exchange server at Outlook.com corrupts data of "Currency" type

And I am frustrated because Level 1 support refuses to send it to Exchange team and wants me to "chat" with MS office team. Nonsense. Microsoft does not care.

I wait when some big company starts to lose their important data because of this error.
Their Exchange version looks to be 15.20.2284.7 .

When I moved data to PST or to other provider, this problem of course is not manifesting.
In PST it is clear since synchronization is eliminated at all.
Yes, this is painful. I had to convert my custom 'currency' fields to type 'number' to work around this new bug.
Just thinking - none of the standard Contact fields appear to be of type 'currency'. Mmmm.
I was today working on conversion VBA macro. I was just experimenting on a copy of data since I have thousands of items I do not want to corrupt any.
I am almost done with it but I had to find the painful way. Because when you use Item.UserProperties.Add("newName") this kills your Item, it jumps in a size and the form is one-offed in each item. NEVER use Item.UserProperties.Add("newName") !!!

To prevent this, you must first
1. Modify your existing Form, add the requested new User Defined Fields and publish it
2. Then the script can use Item.UserProperties("newname").Value=Item.UserProperties("oldname").Value surprisingly without any issue because the form knows the fields and manages the underlying value itself.

Also getting rid of the old field Item.UserProperties("oldField").Remove is pain in the as* because you have to use small batches because Outlook leaks memory when looping over more than 50 items and freezes. And also you must first determine the right index of it by looping the property Names. The freezing known problem. But after all it is one-purpose macro I have created that even creates a log file in TXT so I dont mind to run it more times when debugged.

I have to be fresh to watch whether there still are some more pitfalls to conversion so I finish for today.

Pay attention, if you have one-offed items, then it demonstrates e.g. by: You modify form, publish it, but the item still is opened with the "attached" own version of the form, so you see old one. And the size considerably increases so draw Size from Field Chooser into the view and watch it :)

As a checksum, I CTRL+A all items in a view with dragged Fileds, CTRL+C CTRL+V them into Excel. Then bulk Replace " Kč" currency by nothing and then bulk replace hard space by nothing. This allows to make a Sum of such created numbers. By comparing both sums of the numbers you can be sure all items were converted fine.
What can be the ideal solution in this case? Migrating emails to the other servers is it possible after recovery?
1. When I found this problem, quick and dirty Rescue solution was to move my solution to PST file.
This way you stop loosing the data by sync, but of course you loose you ability to sync between more computers and you have to remember which PST is the last one and carry the PST file with you to the other computers, which sucks.

2. Later I created a migration script that uses "Number" instead of "Currency" type of data. This, however is laborous, required lots of manual work and also I had then to change VBS scripts at forms that used the old Filed names, etc...
See Upgraded Exchange server at Outlook.com corrupts data of "Currency" type and my link to ulozto.cz server where I published my VBA migration script with all the warnings of how to use it.

3. Then it would be possible to return it back to Crippled Exchange - with all your data not in Currency but in Number format- , but look, we have December and Microsoft did not even admit there is a problem, neither started to work on fixing it.
So I prefered to pay a different provider with older Exchange to be sure I can be in more stable environment. I never use Currency again but I am scared of the fact that Microsoft abandoned this area of Outlook and seeems to never give a shit about it after 30 years of this wonderful technology exists.

You can consider paid Microsoft Exchange hosting, but I am afraid you have noone to ask about whether paid version will be better. There is noone who can tell you :) And noone can assure they won't upgrade to version that again starts crippling data.

So after migration of your data you can stay in free Outlook.com and pray to Bill Gates :) and backup, backup, backup to PST periodically. This backup by the way can be done via VBA elegantly with automatic naming of PST files according to date token for example. So you need not pull it via mouse and connecting PST to profile manually.

Can someone explain by the way why after 30 years it is not possible to doubleclick PST and connect it to mail profile automatically ? There must be some sado-masochistic reason for that. :)
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
A Outlook can't remember outlook.com, Exchange password. Using Outlook 3
Kika Melo How to mark as Junk any message not from Contacts (in Outlook.com) Using Outlook 3
S Outlook 2016 and Acrobat PDFMaker Office COM Addin Using Outlook 0
HarvMan Outlook 365 loses "outlook.com" exchange server settings Using Outlook 1
HarvMan Outlook.com Account Using Outlook 3
C Outlook FROM ADDRESS -Outlook.com and Android Using Outlook 1
Z Outlook.com OST Stopped working without explanation Using Outlook.com accounts in Outlook 3
A Reminder duplication Outlook and Outlook.com Using Outlook.com accounts in Outlook 5
D Outlook.com premium finally dying... what do I do with my domain? Using Outlook.com accounts in Outlook 3
G Retention Policy for Outlook.com Deleted Items folder Using Outlook 0
GregS Why is Outlook 2016 mail in Outlook.com? Using Outlook 1
T upgrade from outlook.com to Outlook Using Outlook 2
Commodore Outlook (2013) issues with icloud.com mail Using Outlook 0
H Upon opening Outlook, make my popmail inbox open instead of outlook.com inbox Using Outlook 1
T How do I upgrade from outlook.com to Outlook? Using Outlook 5
T Many problems with outlook.com - will upgrade to Outlook soon Using Outlook 1
T I'm thinking about moving from outlook.com to the Outlook I have in my Office 365 Using Outlook 1
GregS 2016 Contact List being managed by Outlook.com? Using Outlook 1
T Missing Folder in Outlook.com Using Outlook 3
M Outlook .com group does not show up in Outlook for office 365 home Using Outlook 3
dbjdbj Is it only me having a fun time with Outlook.com "beta" ? Using Outlook 3
T Need to backup outlook.com to cloud storage, without desktop software - Testing UpSafe. Are there any similar services? Using Outlook.com accounts in Outlook 8
I New Outlook.com Using Outlook 1
D Adding Enterprise Exchange Email Account to Outlook Prevents Sending via Outlook.com Account Using Outlook.com accounts in Outlook 10
F Delete/create/reset Exchange mailbox on Outlook.com Using Outlook.com accounts in Outlook 3
K Outlook.com is not showing, or finding via search, all my Contacts (People) Using Outlook 0
R PST->Outlook.com (Import vs Drag-n-Drop methods Using Outlook.com accounts in Outlook 2
D Sharing outlook.com calendars in Outlook 2016 Using Outlook 1
T outlook.com opens with "item not found" Using Outlook 1
M Can't send email in outlook.com Using Outlook 9
T BitDefender reporting outlook.com as 'insecure' Using Outlook 6
T Some of my folders in outlook.com appear to have vanished, thanks to v1803 Using Outlook 11
C Syncing on outlook.com Using Outlook 4
S Outlook.com birthdays show up 1 day late on iPhone contacts list Using Outlook.com accounts in Outlook 27
S Outlook.com cannot edit some contacts Using Outlook.com accounts in Outlook 5
B Outlook.com People Limits Using Outlook.com accounts in Outlook 11
Rupert Dragwater How to create a new email with @outlook.com Using Outlook.com accounts in Outlook 32
M Outlook.com autocomplete list invaded by strange items Using Outlook.com accounts in Outlook 7
J Outlook 2016 message content does not display - outlook.com; exchange Using Outlook.com accounts in Outlook 9
D Outlook 2016 IMAP Connection Returns All Email but outlook.com does NOT Using Outlook.com accounts in Outlook 2
M Mailbox Size Outlook.com or Outlook 2011 Using Outlook 1
A remove or turn off outlook.com contact folder from outlook 2016 Using Outlook 4
N Error 0x80090326 when trying to setup IMAP account on Outlook.com Using Outlook.com accounts in Outlook 1
C Long List Of Outlook 2016/Outlook.com Bugs // Where To Report? Using Outlook 10
M How many days are items in Recover Deleted at Outlook.com ? Using Outlook.com accounts in Outlook 4
P Outlook.com account overrules default account Using Outlook.com accounts in Outlook 8
Fozzie Bear Correct Method to set up Outlook.com accounts as Exchange Using Outlook.com accounts in Outlook 7
W Cant connect to outlook.com from outlook Using Outlook.com accounts in Outlook 2
J Outlook.com Contact Sync Issue Using Outlook.com accounts in Outlook 9

Similar threads