Tag Archives: microsoft
Auto click a hyperlink within Outlook
Name of link is all the time the same name: Verify Request. So, it is a better way to click on link name called ‘Verify Request’. It is only one name within email message, regardless of a link: https://sendtokindle.amazon.com/verification/confirm/
As it is reliable email sender from Amazon, it is not an issue with the malicious code. Code is just an example as I do not know if this is suitable for Outlook:
strUrl = “https://sendtokindle.amazon.com/verification/confirm/XXX ‘ obviously you will have to parse the
appropriate address out of your message body
set xmlhttp = CreateObject(“MSXML2.ServerXMLHTTP”)
xmlhttp.open “GET”, strurl, false
xmlhttp.send “”
strBody = xmlhttp.responseText
set xmlhttp = nothing
Name of link is all the time the same name: Verify Request. So, it is a better way to click on link name called ‘Verify Request’. It is only one name within email message, regardless of a link: https://sendtokindle.amazon.com/verification/confirm/ As it is reliable email sender from Amazon, it is not an issue with the malicious code. Code is just an example as I do not know if this is suitable for Outlook: strUrl = “https://sendtokindle.amazon.com/verification/confirm/XXX ‘ obviously you will have to parse the
appropriate address out of your message body
set xmlhttp = CreateObject(“MSXML2.ServerXMLHTTP”)
xmlhttp.open “GET”, strurl, false
xmlhttp.send “”
strBody = xmlhttp.responseText
set xmlhttp = nothing Read More
Excel file error
I have a problem in an excel file in format 97-2003. It worked and opened good, suddenly when trying to open it gives me message file error: data may have been lost, the text only in cells don’t appear. The file size approximately 39 Mb, the file was first established in excel 2010 and I save it as 97-2003 from about 4 years, and continue working on it on excel 2007, till this problem appears.
I have a problem in an excel file in format 97-2003. It worked and opened good, suddenly when trying to open it gives me message file error: data may have been lost, the text only in cells don’t appear. The file size approximately 39 Mb, the file was first established in excel 2010 and I save it as 97-2003 from about 4 years, and continue working on it on excel 2007, till this problem appears. Read More
Mail merge error (text is cutting off)
Dears, I would highly appreciate your support on following issue.
I am using mail merge function and taking fields with long texts to word. Some texts are merged in full but some of them are cutting off. What may be the problem? Thank you.
Dears, I would highly appreciate your support on following issue. I am using mail merge function and taking fields with long texts to word. Some texts are merged in full but some of them are cutting off. What may be the problem? Thank you. Read More
Downloading word file as PDF from SharePoint using graph api looses sensitivity-label
I have a word file in SharePoint Online document library, this file has Sensitivity label assigned to it. I am downloading this file using Graph SDK with query parameter ‘format=pdf’. The file is successfully downloaded and saved as pdf, however, the sensitivity labels are lost.
I opened the same file in browser (Open in browser) and clicked on File –> Save as –> Download as PDF; this step retain the sensitivity labels.
Why is the file when downloading from API loosing its labels?
Note:
I tried downloading directly using SharePoint URL and there too Label information is lost.The sensitivity labels does not carry any control mechanisms i.e., they are used for information classification.
I have a word file in SharePoint Online document library, this file has Sensitivity label assigned to it. I am downloading this file using Graph SDK with query parameter ‘format=pdf’. The file is successfully downloaded and saved as pdf, however, the sensitivity labels are lost.Graph url: Graph url: https://graph.microsoft.com:443/v1.0/drives/b!blTHg…nEk/root:/test03/document.docx:/content?format=pdfI opened the same file in browser (Open in browser) and clicked on File –> Save as –> Download as PDF; this step retain the sensitivity labels.Why is the file when downloading from API loosing its labels?Note:I tried downloading directly using SharePoint URL and there too Label information is lost.The sensitivity labels does not carry any control mechanisms i.e., they are used for information classification. Read More
To make a contact available in Teams for everyone in my tenant
Hello
Please i need your help on this issue.
If i add a contact in my Teams desktop client, this will only be available for me?
How can I make it available for everyone in my tenant when they login to Microsoft Teams.
Hello Please i need your help on this issue. If i add a contact in my Teams desktop client, this will only be available for me? How can I make it available for everyone in my tenant when they login to Microsoft Teams. Read More
Can I create folders automatically linking / containing all files with a certain tag / column info?
For example, could I create a folder that contains or links to all files in other folders that were created by me? Or filtering on any other meta info like file creation date or custom columns? So almost like a predefined search?
For example, could I create a folder that contains or links to all files in other folders that were created by me? Or filtering on any other meta info like file creation date or custom columns? So almost like a predefined search? Read More
Overview of pending/open transferrequests
Greetings,
Since the introduction of NCE subscription transfers, we, as an Indirect provider, have observed a surge in both incoming and outgoing transfers. However, despite my understanding, there appears to be no straightforward method to obtain a comprehensive list of ALL transfer requests across all our customers, even when utilizing the API.
Is there something I might be overlooking?
Greetings,Since the introduction of NCE subscription transfers, we, as an Indirect provider, have observed a surge in both incoming and outgoing transfers. However, despite my understanding, there appears to be no straightforward method to obtain a comprehensive list of ALL transfer requests across all our customers, even when utilizing the API.Is there something I might be overlooking? Read More
No way to continue after Employment Verification with no indication of issue or how to fix
We want to add our app to the Microsoft Store, the submission is ready however we cannot submit until the account has been verified.
In the Legal info section we have entered the company details and the process is stuck at Employment Verification. Under rejected there is a clickable “Things to take care” which I assume displays the issues we need to resolve but which on clicking just makes the page jump a bit. We have no way to know how to proceed. Has anyone else encountered this?
We have create a ticket for help+support but a message appears saying “Not available for this support request.” and a “There was a problem retrieving the support request details.” .
What can we do?
We want to add our app to the Microsoft Store, the submission is ready however we cannot submit until the account has been verified. In the Legal info section we have entered the company details and the process is stuck at Employment Verification. Under rejected there is a clickable “Things to take care” which I assume displays the issues we need to resolve but which on clicking just makes the page jump a bit. We have no way to know how to proceed. Has anyone else encountered this? We have create a ticket for help+support but a message appears saying “Not available for this support request.” and a “There was a problem retrieving the support request details.” . What can we do? Read More
Exclude Linux disk from monitoring
Hello,
I get this message in SCOM and I want to exclude the disk from monitoring:
The disk partitions breaching threshold are:
Drive Name – Free space MB
/ – 7.94MB
So, it’s root and it is not neccessary to monitor / for a particular server.
I have created an override for / but it doesn’t work. The override value is only /. On other machines I have this override: /etc/resolv.conf|/boot/* this works. Could somone help to understand, why the override for / doesn’t work?
Thanks,
Arne
Hello,I get this message in SCOM and I want to exclude the disk from monitoring:The disk partitions breaching threshold are:Drive Name – Free space MB/ – 7.94MBSo, it’s root and it is not neccessary to monitor / for a particular server. I have created an override for / but it doesn’t work. The override value is only /. On other machines I have this override: /etc/resolv.conf|/boot/* this works. Could somone help to understand, why the override for / doesn’t work?Thanks,Arne Read More
How Can Site Collection Admins Adapt to SharePoint Online Development?
I am a Site Collection Administrator currently managing a SharePoint 2016 environment. Over the years, I’ve honed my skills in using the Content Editor and Script Editor web parts to add custom HTML, CSS, and JavaScript to .aspx pages across our site collection and its subsites. These techniques have allowed me to develop tailored solutions for our business unit without needing to engage SharePoint farm admins or server-level developers.
However, with our impending migration to SharePoint Online, I am concerned about how these skills and methods will translate. From what I understand, the ability to use these web parts is either non-existent or extremely limited in the SharePoint Online environment. Additionally, I will not have access to PowerShell or higher-level roles such as Global Administrator or SharePoint Administrator.
Given these constraints, I am seeking advice on the following:
How can I continue to provide development services in SharePoint Online without the use of Content Editor and Script Editor web parts?What tools and techniques should I start learning now to prepare for this transition?Are there modern alternatives or best practices in SharePoint Online that I can leverage to achieve similar outcomes?How can I effectively develop and deploy solutions within the boundaries of the permissions I will have in SharePoint Online?
I want to ensure that I can still deliver value to my business unit by creating custom solutions and maintaining a high level of service. Any insights, resources, or experiences you can share would be greatly appreciated as we navigate this significant change.
Thank you for your support and guidance!
I am a Site Collection Administrator currently managing a SharePoint 2016 environment. Over the years, I’ve honed my skills in using the Content Editor and Script Editor web parts to add custom HTML, CSS, and JavaScript to .aspx pages across our site collection and its subsites. These techniques have allowed me to develop tailored solutions for our business unit without needing to engage SharePoint farm admins or server-level developers. However, with our impending migration to SharePoint Online, I am concerned about how these skills and methods will translate. From what I understand, the ability to use these web parts is either non-existent or extremely limited in the SharePoint Online environment. Additionally, I will not have access to PowerShell or higher-level roles such as Global Administrator or SharePoint Administrator. Given these constraints, I am seeking advice on the following:How can I continue to provide development services in SharePoint Online without the use of Content Editor and Script Editor web parts?What tools and techniques should I start learning now to prepare for this transition?Are there modern alternatives or best practices in SharePoint Online that I can leverage to achieve similar outcomes?How can I effectively develop and deploy solutions within the boundaries of the permissions I will have in SharePoint Online?I want to ensure that I can still deliver value to my business unit by creating custom solutions and maintaining a high level of service. Any insights, resources, or experiences you can share would be greatly appreciated as we navigate this significant change. Thank you for your support and guidance! Read More
Fixing Q.B. Pay roll Tax Updates Not Working After Windows Update
Following a recent Windows update, I’ve encountered problems with Q.B. where the pay roll tax updates aren’t functioning correctly. Despite attempting to update the pay roll tax rates, the changes aren’t being applied as expected in Q.B. Pay roll. What steps should I take to address this issue and ensure that the pay roll tax updates function properly after a Windows update?
Following a recent Windows update, I’ve encountered problems with Q.B. where the pay roll tax updates aren’t functioning correctly. Despite attempting to update the pay roll tax rates, the changes aren’t being applied as expected in Q.B. Pay roll. What steps should I take to address this issue and ensure that the pay roll tax updates function properly after a Windows update? Read More
Unable to open my excel file its corrupted. I tried open and repair method too but it doesn’t workin
Unable to open my excel file its corrupted. I tried open and repair method too but it doesn’t working. Can you please fix me.
Unable to open my excel file its corrupted. I tried open and repair method too but it doesn’t working. Can you please fix me. Read More
Query on the use of %text string%
Using the tutorial below I created a shortcut to my ‘Recent items’ and it stated “Enter text string ‘%AppData%MicrosoftWindowsRecent’ in the ‘Location’ box. After completing the shortcut I find it takes me to the longer address ‘C:UsersKenAppDataRoamingMicrosoftWindowsRecent’.
It seems that ‘%textstring% is a search instruction to look for what follows after the second % character and then go to that full address.
If this is correct then can someone explain what is happening here and maybe give a couple more useful examples please? Maybe there is a list of useful %textstring% examples?
Using the tutorial below I created a shortcut to my ‘Recent items’ and it stated “Enter text string ‘%AppData%MicrosoftWindowsRecent’ in the ‘Location’ box. After completing the shortcut I find it takes me to the longer address ‘C:UsersKenAppDataRoamingMicrosoftWindowsRecent’.It seems that ‘%textstring% is a search instruction to look for what follows after the second % character and then go to that full address. If this is correct then can someone explain what is happening here and maybe give a couple more useful examples please? Maybe there is a list of useful %textstring% examples? Read More
Major Bug in latest Windows update (Recycle Bin 14GB Limit)
Windows 11 Recycle Bin seems to now have a limit of only 14 GB!!!!!!!
Edition Windows 11 Pro
Version 23H2
OS build 22631.3880
Experience Windows Feature Experience Pack 1000.22700.1020.0
the latest updates to my system:
2024-07 Cumulative Update for .NET Framework 3.5 and 4.8.1 for Windows 11, version 23H2 for x64 (KB5039895)
2024-07 Cumulative Update for Windows 11 Version 23H2 for x64-based Systems (KB5040442)
installed on the 13/07/24
Since windows updated a few days ago (which I have no control over and have lost countless hours of work due to it) there is now either a Bug or an Utter Retarded feature turned on
If my recycle bin exceeds 14 GB of data it will delete the older files in there to bring it back to less than 14 GB, this is ridiculous,
I do a lot of video editing and often move files to the recycle bin when I have finished with that recording or render, then when my project has been completed and once I am happy with the final output I empty my recycle bin, this helps me as often I can have 50 to 200+ clips and or renders to work with on a single project I have to do this because of another great bug from an update 4+ months ago, where file listings order stops working randomly, so more recent file are not listed to the top but rather the bottom mixing the files up along with Windows Explorer.exe randomly crashing out and restarting it’s self. the utter joys of the most basic things within the MS windows environment.
But every now and then I spot something wrong with my project before clearing my recycle bin and I go and restore the part(s) that I need to re do again. But Now I can’t, I have just lost a very crucial recording because I deleted the final output which was a very large file and I lost about 5 files that before the latest update would have been there.
And No this is not Storage Sense as it says “We cleaned up 0 bytes of space in the past month, Last run: 19/04/24
Also my main OS drive which my video files are on, is a 1TB M.2 Drive which still has over 500GB of space available.
What the Hell Microsoft, why are you messing with the Recycle Bin, if it’s not broke don’t fix it.
Windows 11 has become the bane of my life recently and I’m now getting the the point of dumping Windows all together.
For the past 4+ months almost every update has change something that’s important to me and I’ve had to change the way I work, or it’s hindered me in some why.
What’s going on, are you letting your newbie ‘Special Needs’ interns do your updates or is it just you can’t be bothered in checking them before you release them.
And YES I am Very Very Annoyed as I now have to take my machine offline to take my M.2 drive to work and hopefully recover the file with a bit of software they have, meaning I’m unable to compile and render my current project for a full day as this tends to be done when I’m at work as it takes that long.
Windows 11 Recycle Bin seems to now have a limit of only 14 GB!!!!!!! Edition Windows 11 ProVersion 23H2OS build 22631.3880Experience Windows Feature Experience Pack 1000.22700.1020.0the latest updates to my system:2024-07 Cumulative Update for .NET Framework 3.5 and 4.8.1 for Windows 11, version 23H2 for x64 (KB5039895)2024-07 Cumulative Update for Windows 11 Version 23H2 for x64-based Systems (KB5040442)installed on the 13/07/24 Since windows updated a few days ago (which I have no control over and have lost countless hours of work due to it) there is now either a Bug or an Utter Retarded feature turned onIf my recycle bin exceeds 14 GB of data it will delete the older files in there to bring it back to less than 14 GB, this is ridiculous, I do a lot of video editing and often move files to the recycle bin when I have finished with that recording or render, then when my project has been completed and once I am happy with the final output I empty my recycle bin, this helps me as often I can have 50 to 200+ clips and or renders to work with on a single project I have to do this because of another great bug from an update 4+ months ago, where file listings order stops working randomly, so more recent file are not listed to the top but rather the bottom mixing the files up along with Windows Explorer.exe randomly crashing out and restarting it’s self. the utter joys of the most basic things within the MS windows environment. But every now and then I spot something wrong with my project before clearing my recycle bin and I go and restore the part(s) that I need to re do again. But Now I can’t, I have just lost a very crucial recording because I deleted the final output which was a very large file and I lost about 5 files that before the latest update would have been there. And No this is not Storage Sense as it says “We cleaned up 0 bytes of space in the past month, Last run: 19/04/24Also my main OS drive which my video files are on, is a 1TB M.2 Drive which still has over 500GB of space available. What the Hell Microsoft, why are you messing with the Recycle Bin, if it’s not broke don’t fix it.Windows 11 has become the bane of my life recently and I’m now getting the the point of dumping Windows all together. For the past 4+ months almost every update has change something that’s important to me and I’ve had to change the way I work, or it’s hindered me in some why. What’s going on, are you letting your newbie ‘Special Needs’ interns do your updates or is it just you can’t be bothered in checking them before you release them. And YES I am Very Very Annoyed as I now have to take my machine offline to take my M.2 drive to work and hopefully recover the file with a bit of software they have, meaning I’m unable to compile and render my current project for a full day as this tends to be done when I’m at work as it takes that long. Read More
Child Domain metadata cleanup
A forest with an orphaned child domain with 2 “orphaned” DC on that
the forest is as follow
RootDom – DomA
Child1 – DomB
Child2( orphaned ) DomC – 2 DC which have been deleted without demote.
Trying to use ntdsutil on DomA’s Domain Naming master DC.
steps tried.
– forcefully remove the Orphaned Child2 domain. Failed because there are the 2 orphaned DC.
– Forcefully remove the 2nd DC of the Child2 domain. Successfully.
– Forcefully remove the 1st DC of the Child 2 domain Failied with the following error
how can we Force to remove the orphaned 1st server and the orphaned child domain ?
A forest with an orphaned child domain with 2 “orphaned” DC on thatthe forest is as followRootDom – DomA Child1 – DomB Child2( orphaned ) DomC – 2 DC which have been deleted without demote. Trying to use ntdsutil on DomA’s Domain Naming master DC.steps tried.- forcefully remove the Orphaned Child2 domain. Failed because there are the 2 orphaned DC.- Forcefully remove the 2nd DC of the Child2 domain. Successfully.- Forcefully remove the 1st DC of the Child 2 domain Failied with the following error how can we Force to remove the orphaned 1st server and the orphaned child domain ? Read More
Sharing Links – People with Existing Access Defaults to View Access
Hi there,
I have noticed in SharePoint that when I set the default Sharing Link type to “People with Existing Access”, links default to View even when the policy specifies Edit links. There doesn’t seem to be anyway to create an Edit link by default.
Generates a View Link
The problem occurs in Office 365 Group based sites and Communication sites. I have confirmed the behavior in multiple Tenants.
For other Link types, the Edit option does work.
Am I missing something here?
Hi there,
I have noticed in SharePoint that when I set the default Sharing Link type to “People with Existing Access”, links default to View even when the policy specifies Edit links. There doesn’t seem to be anyway to create an Edit link by default.
Generates a View Link
The problem occurs in Office 365 Group based sites and Communication sites. I have confirmed the behavior in multiple Tenants.
For other Link types, the Edit option does work.
Am I missing something here?
Read More
Conditional Formatting Days since Date
I have a client spreadsheet and I am trying conditionally format the cells to highlight in different colours based on the number of days that have passed since the “Date of Last Contact”.
Green: 0-3 days
Yellow: 4-9 days
Red: 10 days+
The formatting needs to correspond with the date in column J and most online tutorials use the =TODAY() function which does not quite suit my needs.
Can anybody please help me?
I have a client spreadsheet and I am trying conditionally format the cells to highlight in different colours based on the number of days that have passed since the “Date of Last Contact”. Green: 0-3 daysYellow: 4-9 daysRed: 10 days+ The formatting needs to correspond with the date in column J and most online tutorials use the =TODAY() function which does not quite suit my needs. Can anybody please help me? Read More
