Solved

"Formula Error" when opening notes mail file

Posted on 2014-02-18
10
841 Views
Last Modified: 2014-02-18
Hello,

We are having an issue with some of our emails. For some users we are unable to open the .nsf file. There seems to be an issue with the inbox folder because I am able to open the file
in designer and can browse through all the object minus the inbox.

Has anyone experienced this issue?
0
Comment
Question by:wishd
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
10 Comments
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 39868599
It can happen that there are multiple Inbox folders. Open the database in the Designer, remove the Inbox folders, then do a Replace design. Oh, and make a backup before doing any modifications.

Multiple users, you say? Do you use a modified mail template by any chance?
0
 

Author Comment

by:wishd
ID: 39868637
I did not define the template so I can't confirm nor deny if the template was modified. However, I followed your suggestion and when I delete the $inbox field I am able to open the file yet when I refreshed the template design the $inbox field was placed back in and I can no longer access the file.
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 39868676
You might find an Inbox under both Views and Folders. You need to remove them both. I assume it's not under Fields...
0
More Than Just A Video Library

Train for your certification. Learn the latest DevOps tools. Grow your skillset to do better work.

At Linux Academy, we release new training modules every week so you'll always be up to date on the latest tech.

 

Author Comment

by:wishd
ID: 39868705
I only see inbox under folder. The ones you see in the picture are the ones i deleted. When I delete them I am able to open the file but once I rebuild it using our default mail template I get the Formula error message.
zzzz.png
0
 
LVL 46

Accepted Solution

by:
Sjef Bosman earned 500 total points
ID: 39868778
So maybe the default mail template is corrupt, or it contains two Inbox folders. Inspecting it won't do any harm.

Maybe you need to get the original template from the distribution media.
0
 

Author Comment

by:wishd
ID: 39868808
Very helpful tip, I created a template from a working mail file and reassigned it to the broken file and VOILA! I am now able to open the file and navigate all the folders with no problems.

Do you know where the templates are stored? I agree with you, I think the default template has issues and I would like to recover it before my back up retention deletes my good copy.
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 39868821
It's probably called mail8.ntf. You can easily find it using the Admin client, Files, and select to display Templates only.
0
 

Author Closing Comment

by:wishd
ID: 39868839
You saved the day!
0
 

Author Comment

by:wishd
ID: 39868840
Got it. Thank you very much for all your help.
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 39868847
Welcome! And thanks.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Nearly six years ago I was hired by a company to be their senior server engineer. One of my first projects was to implement Exchange Server 2007 on a Windows Server 2008 Single Copy Cluster for high availability. That was the easy part; read on to l…
Marketers need statistics and metrics like everybody else needs oxygen. In this article we explain how to enable marketing campaign statistics for Microsoft Exchange mail.
In this video we show how to create a Shared Mailbox in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Recipients >> Sha…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question