Month: July 2024
System.InvalidCastException: The COM object of the type “Outlook.ApplicationClass” cannot be convert
Hello everyone,
We have an Outlook addon that communicates with our application. Our application used to be 32 bit. However, we changed it to 64 bit.
We use the Microsoft.Office.Interop.Outlook DLL to create emails, appointments and so on.
Recently we have been having problems with creating objects and unfortunately we do not know what exactly the problem is.
We always get an exception like this:
System.InvalidCastException: Das COM-Objekt des Typs “Outlook.ApplicationClass” kann nicht in den Schnittstellentyp “Outlook._Application” umgewandelt werden.
Dieser Vorgang konnte nicht durchgeführt werden, da der QueryInterface-Aufruf an die COM-Komponente für die Schnittstelle mit der IID “{00063001-0000-0000-C000-000000000046}” aufgrund des folgenden Fehlers nicht durchgeführt werden konnte:
Element nicht gefunden. (Ausnahme von HRESULT: 0x8002802B (TYPE_E_ELEMENTNOTFOUND)).
bei System.StubHelpers.StubHelpers.GetCOMIPFromRCW(Object objSrc, IntPtr pCPCMD, IntPtr& ppTarget, Boolean& pfNeedsRelease)
bei Outlook.ApplicationClass.GetNamespace(String Type)
or
System.InvalidCastException: Das COM-Objekt des Typs “Microsoft.Office.Interop.Outlook.ApplicationClass” kann nicht in den Schnittstellentyp “Microsoft.Office.Interop.Outlook._Application”
umgewandelt werden. Dieser Vorgang konnte nicht durchgeführt werden, da der QueryInterface-Aufruf an die COM-Komponente für die Schnittstelle mit der
IID “{00063001-0000-0000-C000-000000000046}” aufgrund des folgenden Fehlers nicht durchgeführt werden konnte: Fehler beim Laden der Typbibliothek/DLL.
(Ausnahme von HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).
bei System.StubHelpers.StubHelpers.GetCOMIPFromRCW(Object objSrc, IntPtr pCPCMD, IntPtr& ppTarget, Boolean& pfNeedsRelease)
bei Microsoft.Office.Interop.Outlook.ApplicationClass.get_Session()
The only solutions we found online were to repair Office, which we and our customers did. Unfortunately, it only works for a few days or weeks and then the problem reappears.
We tried to reproduce the problem with a powershell script and we could. This is the script:
$Outlook = New-Object -ComObject Outlook.Application
$Mail = $Outlook.CreateItem(0) # 0 steht für MailItem
$Mail.Subject = “Test E-Mail von PowerShell”
$Mail.Body = “Dies ist eine Test-E-Mail, die mit PowerShell erstellt wurde.”
$Mail.Display()
Write-Host “Das E-Mail-Fenster wurde angezeigt.”
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($Mail) | Out-Null
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($Outlook) | Out-Null
What is the problem? Could the problem be related to Windows group policies? If so, which ones?
We have a lot of customers that have this problem so we need help asp.
Thanks and best regards
Hello everyone, We have an Outlook addon that communicates with our application. Our application used to be 32 bit. However, we changed it to 64 bit.We use the Microsoft.Office.Interop.Outlook DLL to create emails, appointments and so on.Recently we have been having problems with creating objects and unfortunately we do not know what exactly the problem is.We always get an exception like this:System.InvalidCastException: Das COM-Objekt des Typs “Outlook.ApplicationClass” kann nicht in den Schnittstellentyp “Outlook._Application” umgewandelt werden.Dieser Vorgang konnte nicht durchgeführt werden, da der QueryInterface-Aufruf an die COM-Komponente für die Schnittstelle mit der IID “{00063001-0000-0000-C000-000000000046}” aufgrund des folgenden Fehlers nicht durchgeführt werden konnte:Element nicht gefunden. (Ausnahme von HRESULT: 0x8002802B (TYPE_E_ELEMENTNOTFOUND)).bei System.StubHelpers.StubHelpers.GetCOMIPFromRCW(Object objSrc, IntPtr pCPCMD, IntPtr& ppTarget, Boolean& pfNeedsRelease)bei Outlook.ApplicationClass.GetNamespace(String Type)or System.InvalidCastException: Das COM-Objekt des Typs “Microsoft.Office.Interop.Outlook.ApplicationClass” kann nicht in den Schnittstellentyp “Microsoft.Office.Interop.Outlook._Application”umgewandelt werden. Dieser Vorgang konnte nicht durchgeführt werden, da der QueryInterface-Aufruf an die COM-Komponente für die Schnittstelle mit derIID “{00063001-0000-0000-C000-000000000046}” aufgrund des folgenden Fehlers nicht durchgeführt werden konnte: Fehler beim Laden der Typbibliothek/DLL.(Ausnahme von HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).bei System.StubHelpers.StubHelpers.GetCOMIPFromRCW(Object objSrc, IntPtr pCPCMD, IntPtr& ppTarget, Boolean& pfNeedsRelease)bei Microsoft.Office.Interop.Outlook.ApplicationClass.get_Session() The only solutions we found online were to repair Office, which we and our customers did. Unfortunately, it only works for a few days or weeks and then the problem reappears. We tried to reproduce the problem with a powershell script and we could. This is the script:$Outlook = New-Object -ComObject Outlook.Application$Mail = $Outlook.CreateItem(0) # 0 steht für MailItem$Mail.Subject = “Test E-Mail von PowerShell”$Mail.Body = “Dies ist eine Test-E-Mail, die mit PowerShell erstellt wurde.”$Mail.Display()Write-Host “Das E-Mail-Fenster wurde angezeigt.”[System.Runtime.Interopservices.Marshal]::ReleaseComObject($Mail) | Out-Null[System.Runtime.Interopservices.Marshal]::ReleaseComObject($Outlook) | Out-Null What is the problem? Could the problem be related to Windows group policies? If so, which ones? We have a lot of customers that have this problem so we need help asp. Thanks and best regards Read More
64-bit Excel Power Pivot stuck on “reading data” for a small one-to-many relationship
Hi,
Can anyone please tell me why the Excel Power Pivot for this simple one-to-many data model never finishes “Reading data…”?
Masters has 6000 rows
Sub Accounts has 63,000 rows
The same model works as expected in Power BI desktop!
Hi, Can anyone please tell me why the Excel Power Pivot for this simple one-to-many data model never finishes “Reading data…”? Masters has 6000 rowsSub Accounts has 63,000 rows The same model works as expected in Power BI desktop! Read More
How to Send a High Importance email through PowerShell Script
I am login through exchange server ‘Web Outlook App’ to send email out. The send email is working fine, but I want to know how to send a ‘Priority’ email. I’ve tried everything and the email send is not sending as ‘Priority’. Please let me know the syntax for Power Shell script. These are the one that try so far and none of them are working.
I am login through exchange server ‘Web Outlook App’ to send email out. The send email is working fine, but I want to know how to send a ‘Priority’ email. I’ve tried everything and the email send is not sending as ‘Priority’. Please let me know the syntax for Power Shell script. These are the one that try so far and none of them are working. # Send High Performance Email#[System.Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12#$emailPriority = [System.Net.Mail.MailPriority]::High#$emailPriority = “2”#$email.Priority = [System.Net.Mail.MailPriority]::High#$emailHighPriority =”High”#$emailMessage.Priority = [System.Net.Mail.MailPriority]::High#$mailMessage.Priority = [System.Net.Mail.MailPriority]::High#`$emailMessage.Priority = [System.Net.Mail.MailPriority]::High`#$emailMessage = New-Object System.Net.Mail.MailMessage#$emailMessage.Priority = 2#$email = New-Object System.Net.Mail.MailMessage#$email.Priority = [System.Net.Mail.MailPriority]::High Read More
Microsoft Remote Desktop crashes when trying to connect to virtual desktop
I have one person who is trying to connect to an azure virtual machine via MSRD. When she clicks on the remote icon nothing happens. I went into event viewer and found this.
Faulting application name: msrdc.exe, version 1.2.5559.0, time stamp: 0x669718bf
Faulting module name: ntdll.dll, version: 10.0.19041.4522, time stamp: 0x8a1bb6f3
Exception code 0xc0000409
Fault Offset: 0x00000000000a1a91
Faulting process id: 0x4990
Faulting application path C:Program FilesRemote Desktopmsrdc.exe
Faulting module path: C:WindowsSYSTEM32ntdll.dll
This is on a Windows 10 machine. I have tried uninstalling and reinstalling MSRDT, I tried using a different profile on the same computer. With no luck. I tried older versions of MSRDT as well. I already tried chkdsk and scannow. Any ideas would be great!
I have one person who is trying to connect to an azure virtual machine via MSRD. When she clicks on the remote icon nothing happens. I went into event viewer and found this. Faulting application name: msrdc.exe, version 1.2.5559.0, time stamp: 0x669718bfFaulting module name: ntdll.dll, version: 10.0.19041.4522, time stamp: 0x8a1bb6f3Exception code 0xc0000409Fault Offset: 0x00000000000a1a91Faulting process id: 0x4990Faulting application path C:Program FilesRemote Desktopmsrdc.exeFaulting module path: C:WindowsSYSTEM32ntdll.dll This is on a Windows 10 machine. I have tried uninstalling and reinstalling MSRDT, I tried using a different profile on the same computer. With no luck. I tried older versions of MSRDT as well. I already tried chkdsk and scannow. Any ideas would be great! Read More
M365 Developers Update | July 2024 Edition
In this monthly blog series focused on M365, we will be sharing product updates, notable reads, and other new resources that can be leveraged by developers who are building apps for the commercial marketplace.
Spotlight
Discover how extensibility for Copilot for Microsoft 365 works. Read More.
Copilot extensions: Learn how to extend, customize, and amplify Copilot capabilities. Get started.
Build your own highly specialized copilot using Microsoft Copilot Studio or Visual Studio Code Learn how.
See how you can build your custom copilot for Teams with the Teams AI library Watch now.
Build Copilot extensions with our samples collection. Go now.
Learn
Learn how Dev Proxy can help you achieve more with APIs in your organization. Try it now.
Discover how you can build AI-powered apps that run on Microsoft Teams with help from Azure Communication Services. Watch the tutorial.
Develop your Office add-ins with a collection of prompt examples to use with GitHub Copilot. Start now.
Explore the latest Teams Toolkit for Visual Studio Code updates to discover a faster way to debug your Teams apps. Get the updates.
Online Training
See what you missed at Microsoft Build 2024 Watch all breakout sessions on demand. Catch up now.
Collection of free Microsoft Copilot prompts Transform your workflow with a new community-led repository set. Learn more.
Copilot extensibility learning module Get started with Microsoft Copilot for Microsoft 365 extensibility. Begin today.
Community calls Learn from our experts on a variety of Microsoft 365 platform topics. Join a call.
Microsoft Tech Community – Latest Blogs –Read More
What’s new in Viva Connections mid-year update
We’re excited to announce a range of new capabilities for Viva Connections designed to bring your Viva Connections experiences into the flow of work, add customization to the Spotlight feature, understand how users are engaging with the app and bring new integrations into dashboard cards. Here’s what’s new:
New ways to stay connected
Viva Connections is all about connecting you to the things you need, and now, you can get Desktop Notifications to ensure you don’t miss the latest news and announcements. And updated notification settings and performance improvements give you additional control on what you see, faster loading, tablet personalization, and helpful tools like inline authoring.
To better connect your employees to the resources they need most, we’ve recently rolled out the ability to import global navigation items into the Viva Connections Resources tab.
We’ve also released Viva Connections on the web that brings a dynamic, beautiful app experience directly into the browser.
Communicating through the employee app
The new customizable Spotlight offers communicators a sleek, above-the-fold section to highlight key news. Up to eleven pieces of news can be added to the Spotlight carousel for announcements and campaigns that need extra emphasis and durability.
Highlight key news and campaigns with Spotlight
Highlight key news and campaigns with Spotlight
New communication features also enable Regional Announcements, which provides additional attribute-based targeting based on job, title, and location. This is specifically geared for reaching Frontline Workers (FLWs) working in different regions, branches, stores, or departments by using filtering.
Filter your audience based on FLW attributes like location, department, and job title.
Learn more about how to set up regional filtering and using FLW announcements. Note this feature requires Frontline licensing.
Analytics
Admins can now understand how and when users engage with components of the Viva Connections experience. You can see data on overall traffic, usage, and engagement across each of your organization’s Connections experiences. Learn more about how to access usage data here.
A view of analytics in Viva Connections
Cards
Dashboard cards in Viva Connections are the building blocks to a modern employee experience. A few months ago, we previewed a few cards for frontline workers which are now available.
Pulse Card – The Viva Pulse card in Viva Connections allows you to create Pulse survey (s) via the dashboard, giving employees a quick and targeted way to share feedback and participate in workplace surveys. Once the survey is complete, the owner can view the response rate right on the card.
Assigned Tasks Card
The Assigned Tasks card automatically displays information to users about their assigned tasks to. This information is retrieved from the Tasks app in Teams and enables users to quickly take action and accomplish tasks right from their dashboard.
OneDrive Card update
This new card allows organizations to add a OneDrive Files Card to the Viva Connections dashboard, showing recently accessed, shared, or favorite files. This card is now generally available and requires no action for setup.
Learn more about our Viva Connections dashboard cards in this blog.
We’re excited about the future of Viva Connections as more and more enterprises and frontline workers have built this app into their daily and weekly habits. We’ll have more updates to share soon — stay tuned!
Microsoft Tech Community – Latest Blogs –Read More
Announcing public preview of new Mbv3 Virtual Machines
As we launched memory-optimized Mv3 Medium Memory in Nov ’23, the demand for further storage optimization has been high. Today, we are excited to announce that the new Mbv3 series (Mbsv3 and Mbdsv3), featuring both storage-optimized and memory-optimized, are now available in public preview.
Key features on the new Mbv3 VMs
The memory-optimized and storage-optimized Mbv3 VM (Mbsv3 and Mbdsv3) series are based on the 4th generation Intel® Xeon® Scalable processors, scale for workloads up to 4TB, and deliver higher remote disk storage performance
These new VM sizes offer up to 650,000 IOPS, providing a 5x improvement in network throughput over the previous M-series families.
These new VM sizes also offer up to 10GBps of remote disk storage bandwidth, providing a 2.5x improvement in remote storage bandwidth over the previous M-series families.
The increased remote storage performance of these VMs is ideal for storage throughput-intensive workloads such as relational databases and data analytics applications.
Designed from the ground up for increased resilience against failures in memory, disks, and networking based on intelligence from past generations.
Available in both disk and diskless offerings, allowing customers the flexibility to choose the option that best meets their workload needs.
Mbsv3 series
Size
vCPU
Memory: GiB
Max data disks
Max uncached Premium SSD throughput: IOPS/MBps
Max uncached Ultra Disk and Premium SSD V2 disk throughput: IOPS/MBps
Max NICs
Max network bandwidth (Mbps)
Standard_M16bs_v3
16
128
64
44,000/1,000
64,000/1,000
8
8,000
Standard_M32bs_v3
32
256
64
88,000/2,000
88,000/2,000
8
16,000
Standard_M48bs_v3
48
384
64
88,000/2,000
120,000/2,000
8
16,000
Standard_M64bs_v3
64
512
64
88,000/2, 000
160,000/2, 000
8
16,000
Standard_M96bs_v3
96
768
64
260,000/4,000
260,000/4,000
8
25,000
Standard_M128bs_v3
128
1024
64
260,000/4,000
400,000/4,000
8
40,000
Standard_M176bs_v3
176
1536
64
260,000/6,000
650,000/6,000
8
50,000
Standard_M176bs_3_v3
176
2796
64
260,000/8,000
650,000/10,000
8
40,000
Mbdsv3 series
Size
vCPU
Memory: GiB
Temp storage (SSD) GiB
Max data disks
Max temp storage throughput: IOPS/MBps*
Max uncached Premium SSD throughput: IOPS/MBps
Max uncached Ultra Disk and Premium SSD V2 disk throughput: IOPS/MBps
Max NICs
Max network bandwidth (Mbps)
Standard_M16bds_v3
16
128
400
64
10,000/100
44,000/1,000
64,000/1,000
8
8,000
Standard_M32bds_v3
32
256
400
64
20,000/200
88,000/2,000
88,000/2,000
8
16,000
Standard_M48bds_v3
48
384
400
64
40,000/400
88,000/2,000
120,000/2,000
8
16,000
Standard_M64bds_v3
64
512
400
64
40,000/400
88,000/2,000
160,000/2,000
8
16,000
Standard_M96bds_v3
96
768
400
64
40,000/400
260,000/4,000
260,000/4,000
8
25,000
Standard_M128bds_v3
128
1,024
400
64
160,000/1600
260,000/4,000
400,000/4,000
8
40,000
Standard_M176bds_v3
176
1,536
400
64
160,000/1600
260,000/6,000
650,000/6,000
8
50,000
Standard_M176bds_3_v3
176
2796
400
64
160,000/1600
260,000/8,000
650,000/10,000
8
40,000
Standard_M64bds_1_v3
64
1397
3000
64
40,000/400
130,000/6,000
160, 000/6,000
8
20,000
Standard_M96bds_2_v3
96
1946
4500
64
40,000/400
130,000/8,000
260,000/8,000
8
20,000
Standard_M128bds_3_v3
128
2794
6000
64
160,000/1600
260,000/8,000
400,000/10,000
8
40,000
Standard_M176bds_4_v3
176
3892
8000
64
160,000/1600
260,000/8,000
650,000/10,000
8
40,000
Regional Availability
The preview is available in West Europe, North Europe, and East US, South Central US .
Join the Preview
You can try out the preview by filling out this form.
Microsoft Tech Community – Latest Blogs –Read More
Can I download previous releases of MATLAB?
Can I download previous releases of MATLAB?Can I download previous releases of MATLAB? Can I download previous releases of MATLAB? MATLAB Answers — New Questions
Formatting input data for linear regression model in leave-out-one validation testing
Hello there I have data from 10 trials stored in a 10×1 cell (Predictors) and the corespoding respose vairables stored in a 10×1 cell (Response). I am trying to trian a simple linear regression model and make predictions by leaving one trial out and using the other 9 trials to train the linear regression model and the one to predict/test the model by producing RMSE values. I am unsure of how to format my input within the "fitlm" function as I keep getting the follwing error:
% Train the network
for i = 1:length(Predictors) %iterate over all data points
validationdataX = Predictors(i);
validationdataY = Response(i);
%Exclude the current index (i) for training
trainingIndices = setdiff(1:length(Predictors),i);
traningdataX = Predictors(trainingIndices)
trainingdataY = Response(trainingIndices)
net = fitlm(traningdataX,trainingdataY)
ypred = predict(net,validationdataX);
TrueVal = validationdataY;
TrueValue = cell2mat(TrueVal);
Predvalue = {Predval};
PredictedValue = cell2mat(Predvalue);
RMSE = rmse(PredictedValue,TrueValue)
end
Error using classreg.regr.TermsRegression/handleDataArgs (line 589)
Predictor variables must be numeric vectors, numeric matrices, or categorical vectors.
Error in LinearModel.fit (line 1000)
[X,y,haveDataset,otherArgs] = LinearModel.handleDataArgs(X,paramNames,varargin{:});
Error in fitlm (line 134)
model = LinearModel.fit(X,varargin{:});
Any suggestions on how to fix this and to get the model to work correcly and make predictions using leave out one validation approach would be greatly appreciated!Hello there I have data from 10 trials stored in a 10×1 cell (Predictors) and the corespoding respose vairables stored in a 10×1 cell (Response). I am trying to trian a simple linear regression model and make predictions by leaving one trial out and using the other 9 trials to train the linear regression model and the one to predict/test the model by producing RMSE values. I am unsure of how to format my input within the "fitlm" function as I keep getting the follwing error:
% Train the network
for i = 1:length(Predictors) %iterate over all data points
validationdataX = Predictors(i);
validationdataY = Response(i);
%Exclude the current index (i) for training
trainingIndices = setdiff(1:length(Predictors),i);
traningdataX = Predictors(trainingIndices)
trainingdataY = Response(trainingIndices)
net = fitlm(traningdataX,trainingdataY)
ypred = predict(net,validationdataX);
TrueVal = validationdataY;
TrueValue = cell2mat(TrueVal);
Predvalue = {Predval};
PredictedValue = cell2mat(Predvalue);
RMSE = rmse(PredictedValue,TrueValue)
end
Error using classreg.regr.TermsRegression/handleDataArgs (line 589)
Predictor variables must be numeric vectors, numeric matrices, or categorical vectors.
Error in LinearModel.fit (line 1000)
[X,y,haveDataset,otherArgs] = LinearModel.handleDataArgs(X,paramNames,varargin{:});
Error in fitlm (line 134)
model = LinearModel.fit(X,varargin{:});
Any suggestions on how to fix this and to get the model to work correcly and make predictions using leave out one validation approach would be greatly appreciated! Hello there I have data from 10 trials stored in a 10×1 cell (Predictors) and the corespoding respose vairables stored in a 10×1 cell (Response). I am trying to trian a simple linear regression model and make predictions by leaving one trial out and using the other 9 trials to train the linear regression model and the one to predict/test the model by producing RMSE values. I am unsure of how to format my input within the "fitlm" function as I keep getting the follwing error:
% Train the network
for i = 1:length(Predictors) %iterate over all data points
validationdataX = Predictors(i);
validationdataY = Response(i);
%Exclude the current index (i) for training
trainingIndices = setdiff(1:length(Predictors),i);
traningdataX = Predictors(trainingIndices)
trainingdataY = Response(trainingIndices)
net = fitlm(traningdataX,trainingdataY)
ypred = predict(net,validationdataX);
TrueVal = validationdataY;
TrueValue = cell2mat(TrueVal);
Predvalue = {Predval};
PredictedValue = cell2mat(Predvalue);
RMSE = rmse(PredictedValue,TrueValue)
end
Error using classreg.regr.TermsRegression/handleDataArgs (line 589)
Predictor variables must be numeric vectors, numeric matrices, or categorical vectors.
Error in LinearModel.fit (line 1000)
[X,y,haveDataset,otherArgs] = LinearModel.handleDataArgs(X,paramNames,varargin{:});
Error in fitlm (line 134)
model = LinearModel.fit(X,varargin{:});
Any suggestions on how to fix this and to get the model to work correcly and make predictions using leave out one validation approach would be greatly appreciated! linear regression, input data formatting, validation MATLAB Answers — New Questions
How can I clear an error “The expression to the left of the equals sign is not a valid target for an assignment?”
I tried to solve a problem (see the attachments). But I gor an error "The expression to the left of the equals sign is not a valid target for an assignment". How to solve this issue.I tried to solve a problem (see the attachments). But I gor an error "The expression to the left of the equals sign is not a valid target for an assignment". How to solve this issue. I tried to solve a problem (see the attachments). But I gor an error "The expression to the left of the equals sign is not a valid target for an assignment". How to solve this issue. bvp4c MATLAB Answers — New Questions
how can i complaint on cred
क्रेड की ग्राहक सेवा टीम या तो फोन, 096648-47919. ईमेल, या उनकी वेबसाइट के ग्राहक सहायता पोर्टल के माध्यम से। 080164–56551., लिखित शिकायत दर्ज करें: अपनी मौखिक शिकायत के बाद लिखित शिकायत दर्ज करें।
क्रेड की ग्राहक सेवा टीम या तो फोन, 096648-47919. ईमेल, या उनकी वेबसाइट के ग्राहक सहायता पोर्टल के माध्यम से। 080164–56551., लिखित शिकायत दर्ज करें: अपनी मौखिक शिकायत के बाद लिखित शिकायत दर्ज करें। Read More
ISBLANK used with TODAY() but text in cell gives a #VALUE! error
Hi there, I have formula to give a blank if there is not an entry in the cell I am calculating the date on, but my added secondary level is that if the cell contains text rather than a date in it, then it returns #VALUE!
So I have =IF(ISBLANK(E5),” “,E5-TODAY()) which gives a result of 37 – as in number of days left as E5 contains a date 37 days from today
But then I have =IF(ISBLANK(F5),” “,F5-TODAY()) which gives a result of #VALUE! and this is because cell F5 contains text
I assume it needs to be something like either AND OR ISERROR ISNUMBER combined with the IF ISBLANK above, but my brain cannot compute what it needs and neither can searching for an answer as I probably am not asking for the correct thing!
Thanks in advance
Hi there, I have formula to give a blank if there is not an entry in the cell I am calculating the date on, but my added secondary level is that if the cell contains text rather than a date in it, then it returns #VALUE! So I have =IF(ISBLANK(E5),” “,E5-TODAY()) which gives a result of 37 – as in number of days left as E5 contains a date 37 days from today But then I have =IF(ISBLANK(F5),” “,F5-TODAY()) which gives a result of #VALUE! and this is because cell F5 contains text I assume it needs to be something like either AND OR ISERROR ISNUMBER combined with the IF ISBLANK above, but my brain cannot compute what it needs and neither can searching for an answer as I probably am not asking for the correct thing! Thanks in advance Read More
What is Microsoft doing do battle the decline of Windows Server in the cloud?
What is Microsoft doing do battle the decline of Windows Server in the cloud?
This is based on the news coming from the cma battle in the UK:
https://www.theregister.com/2024/07/24/microsoft_cloud_cma/
This coming from someone that has invested 15+ years in learning and using Windows Server.
Are there any hints as to how Microsoft might look at fixing this?
What is Microsoft doing do battle the decline of Windows Server in the cloud? This is based on the news coming from the cma battle in the UK:https://www.theregister.com/2024/07/24/microsoft_cloud_cma/ This coming from someone that has invested 15+ years in learning and using Windows Server. Are there any hints as to how Microsoft might look at fixing this? Read More
Connector Exchange Server with Exchange Online
I made Send Connector on the Exchange Server (SmartHost) and Inbound Connector on the M365 IP Public Exchange Server.
I also made an outbound connector on M365 which led to on Premise using an IP Public Exchange Server.
Some users are in M365 and some are on on Premise, and MX Pointing to M365.
Some of my email delivery scenarios do:
1. Delivery of emails from User M365 to User on Premise runs well, as well as contrary.
2. Delivery of email from external user to user on premise runs well.
3. Delivery of email from user on premise to external user runs well.
4. Delivery of emails from user on premise to other users on premise then forward to the user M365 runs well.
5. Delivery of email from external user to user on premise then forward to user m365 runs well, log below:
6. Delivery of emails from external user to user on premise then forward to external user “failed” with information such as the log below:
please advice,
I made Send Connector on the Exchange Server (SmartHost) and Inbound Connector on the M365 IP Public Exchange Server.I also made an outbound connector on M365 which led to on Premise using an IP Public Exchange Server.Some users are in M365 and some are on on Premise, and MX Pointing to M365. Some of my email delivery scenarios do:1. Delivery of emails from User M365 to User on Premise runs well, as well as contrary.2. Delivery of email from external user to user on premise runs well.3. Delivery of email from user on premise to external user runs well.4. Delivery of emails from user on premise to other users on premise then forward to the user M365 runs well.5. Delivery of email from external user to user on premise then forward to user m365 runs well, log below:6. Delivery of emails from external user to user on premise then forward to external user “failed” with information such as the log below:please advice, Read More
Word Export to Kindle feature and DLP.
Just wondering if anyone has found a way to control exports to Kindle, other than disabling the feature via a cloud policy.
I don’t want to disable the feature, I’m sure it will serve a purpose for some users, but I would like to prevent the export of certain information.
Thanks,
Neil.
Just wondering if anyone has found a way to control exports to Kindle, other than disabling the feature via a cloud policy.I don’t want to disable the feature, I’m sure it will serve a purpose for some users, but I would like to prevent the export of certain information. Thanks, Neil. Read More
Problems with current week views and next weeks views in list
Hello all.
I have a sharepoint list of “changes” made at my workplace. Currently, I made a view which displays the changes for the current week, as well as a view displaying changes for the next week. This is based on the week number of the changes, not within a set 7 day time frame as this would maybe miss out changes of the coming monday if you were to look at the view on Friday.
I calculated the week number of each change by using the “FROM” field of the change i;e “Date_Start”. I then compared this to another varible called week current which calculates the week number we are presently in so it changes by itself, ie doesnt use a static value; if they are equal this the change is displayed in the view. I did the same thing basically for the nex week view except I added 1 as it would be the week number + 1.
The problem arises now that each time we enter a new week, the changes from the previous week are carried through and the list doesn’t update unless I make a manual change/ edit to refresh things. I found out its because “FROM” is static so never auto updates, or calculated values don’t auto update that is. Does anyone know how I can achieve what i did below using JSON, so that I dont need to manually refresh?
Hello all. I have a sharepoint list of “changes” made at my workplace. Currently, I made a view which displays the changes for the current week, as well as a view displaying changes for the next week. This is based on the week number of the changes, not within a set 7 day time frame as this would maybe miss out changes of the coming monday if you were to look at the view on Friday. I calculated the week number of each change by using the “FROM” field of the change i;e “Date_Start”. I then compared this to another varible called week current which calculates the week number we are presently in so it changes by itself, ie doesnt use a static value; if they are equal this the change is displayed in the view. I did the same thing basically for the nex week view except I added 1 as it would be the week number + 1. The problem arises now that each time we enter a new week, the changes from the previous week are carried through and the list doesn’t update unless I make a manual change/ edit to refresh things. I found out its because “FROM” is static so never auto updates, or calculated values don’t auto update that is. Does anyone know how I can achieve what i did below using JSON, so that I dont need to manually refresh? Read More
Announcing Deploy To Teams from Azure OpenAI Studio
Microsoft is excited to announce the public preview of a new feature, Deploy to a Teams app, in Azure OpenAI Studio allowing developers to seamlessly create custom engine copilots connected to their enterprise data and available to over 320+ million users on Teams.
Start by using Add your data in the Azure OpenAI Studio Playground to create personalized copilots tailored to your data, improving user understanding, expediting task completion, and facilitating decision-making. Enterprise data from Azure AI Search, Azure Blob Storage (preview), URL/web address (preview), local files (preview), Azure Cosmos DB for MongoDB vCore, and Elasticsearch (preview) all can be used to ground responses from your custom copilot with your data.
After adding your data, selecting Deploy to a Teams app creates a project source code integrated with your configuration and data from Azure OpenAI Studio. The source code is powered by Teams AI Library, which helps developers build custom engine copilots designed to harness the powerful capabilities of Large Language Models (LLMs) for seamless user interaction on Teams. Once you are ready, you can publish your Teams app to your end users!
Get started and learn more about this feature here.
Resources:
Apply for access to Azure OpenAI Service
Check out Build announcement
Learn more about how to get started in Teams AI Library
Microsoft Tech Community – Latest Blogs –Read More
Kubernetes History: How It Conquered Cloud Native Orchestration
Did you know that Kubernetes originally had no built-in features for managing user permissions, or that support for storing data persistently didn’t appear until Kubernetes was four years old?
Did you know that Kubernetes originally had no built-in features for managing user permissions, or that support for storing data persistently didn’t appear until Kubernetes was four years old?Read More
How can i fit the inscribed circle with different diameter in an image ??
I have an image which has the close shape. I need to fill the the close loop with different diameter in the image. Can anyone give the suggestion for that ??I have an image which has the close shape. I need to fill the the close loop with different diameter in the image. Can anyone give the suggestion for that ?? I have an image which has the close shape. I need to fill the the close loop with different diameter in the image. Can anyone give the suggestion for that ?? fill, prescribed circle, image processing MATLAB Answers — New Questions
How to run the batch file in Test node from Azure pipelines.
I have batch file in test node shared folder and wanted to execute through the pipeline.
I have batch file in test node shared folder and wanted to execute through the pipeline. Read More
