Hello Marketplace community,

Trust this message finds you. I tried to create a service offer. Just a quick one. Is that statement correct: “Professional services must be sold using a US, UK, or Canadian seller ID. To understand which market your seller ID is configured in”? 

If not could you please support as I can create a “professional service” as new offer, I do not have the option available actually located in the EU.

Thanks and best 

​Hello Marketplace community, Trust this message finds you. I tried to create a service offer. Just a quick one. Is that statement correct: “Professional services must be sold using a US, UK, or Canadian seller ID. To understand which market your seller ID is configured in”? If not could you please support as I can create a “professional service” as new offer, I do not have the option available actually located in the EU. Thanks and best   Read More

​

Can any one suggest me how should i improve c# advanced topics and sql advanced topics?

​Can any one suggest me how should i improve c# advanced topics and sql advanced topics?   Read More

​

I use Outlook to receive encrypted emails that are protected by a certificate stored on my smartcard. When opening these emails, a Windows Security prompt appears, asking me to enter the PIN for my smartcard to decrypt the message. Once the PIN is entered, I can access the email contents.

I’m looking for a way to automatically trigger the PIN entry dialog via code so that the user is prompted to enter the PIN without manually clicking on the encrypted email. The user will still need to insert their smartcard and manually enter the PIN, but I want the dialog itself to be initiated programmatically.

I would prefer to implement this solution in PowerShell, an Outlook macro (VBA), or Delphi. However, I encountered an issue: when attempting to display the email using MailItem.Display(True), the PIN dialog does not appear. Instead, the following error message is shown: “The name of your digital ID could not be found by the underlying security system.”

Has anyone experienced this or have suggestions on how to automate the process while keeping the PIN entry manual and secure?

Thank you in advance for your help!

​I use Outlook to receive encrypted emails that are protected by a certificate stored on my smartcard. When opening these emails, a Windows Security prompt appears, asking me to enter the PIN for my smartcard to decrypt the message. Once the PIN is entered, I can access the email contents. I’m looking for a way to automatically trigger the PIN entry dialog via code so that the user is prompted to enter the PIN without manually clicking on the encrypted email. The user will still need to insert their smartcard and manually enter the PIN, but I want the dialog itself to be initiated programmatically. I would prefer to implement this solution in PowerShell, an Outlook macro (VBA), or Delphi. However, I encountered an issue: when attempting to display the email using MailItem.Display(True), the PIN dialog does not appear. Instead, the following error message is shown: “The name of your digital ID could not be found by the underlying security system.” Has anyone experienced this or have suggestions on how to automate the process while keeping the PIN entry manual and secure? Thank you in advance for your help!   Read More

​

Symptoms: 

For your master database you might find different configuration such as Backup Storage Redundancy configured to be Local or Geo

As this is not configurable property you might ask why is my database configured with this value. 

Resolution: 

For master database on Azure SQL Database Server, Microsoft is managing this database as part of the server entity. 

as you cannot change the SLO level (which might be system or system2) for the master database there are other properties that cannot be configured from customer end. 

Note that master database is part of the server entity and should not store user data, therefore the only use of master database is to operate the server object. 

Backup redundancy is displayed as this is one of the properties shown for database object, however this is irrelevant for master database.

in any case, Microsoft implement mechanisms to keep this database highly available and secure for your database server. 

​Microsoft Tech Community – Latest Blogs –Read More 

I have a table with two columns (A:B), column A cells contain the names of PDF files that are in a folder directory “C:UsersTaylorDesktopFolder” and in the image I have in column B the file path of the values (1000, 1001, 1002, 1003) How can I loop through a folder and match the names of pdf files with cells in column A values and extract their path URL, and you see in the picture that number 1004 and 1005 in col B are black and don’t have hyperlink because they don’t exist in the folder.

In this folder path I have pdf files 1000.pdf, 1001.pdf, 1002.pdf, 1003.pdf

IMAGE: https://ibb.co/5rN4xdg

The code works well, I’m getting error in this line:

Sheet1.Hyperlinks.Add Anchor:=cel.Offset(, 1).Value, Address:=fso.GetFile(strFilepath), TextToDisplay:=cel.Value

MISMATCH ERROR

Code:

‘ GO TO TOOLS THEN REFERENCES THEN ADD MICROSOFT SCRIPTING RUNTIME

Sub SearchFiles()
Dim ws As Worksheet
Dim tbl As ListObject
Dim cel As Range
Dim rootFolder As String
Dim strNameNewSubFolder As String
Dim fso As FileSystemObject
Dim newFolder As Folder
Dim fil As File
Dim strFilepath As String
Dim newFilePath As String

Set fso = New FileSystemObject
Set ws = Worksheets(“Data”)
Set tbl = ws.ListObjects(1)

‘Path of the Source folder with files
rootFolder = “C:UsersTaylorDesktopNew folder”

If Not fso.FolderExists(rootFolder) Then
MsgBox rootFolder & ” doesn’t exist.”, vbExclamation, “Source Folder Not Found!”
Exit Sub
End If

‘files that are found in the Source Folder would be copied to this New Sub-Folder
‘Change the name of the Sub-Folder as per your requirement
strNameNewSubFolder = “Found Files”

If Right(rootFolder, 1) <> “/” Then rootFolder = rootFolder & “/”

If Not fso.FolderExists(rootFolder & strNameNewSubFolder) Then
fso.CreateFolder rootFolder & strNameNewSubFolder
End If

Set newFolder = fso.GetFolder(rootFolder & strNameNewSubFolder)

tbl.DataBodyRange.Columns(1).Interior.ColorIndex = xlNone

For Each cel In tbl.DataBodyRange.Columns(1).Cells
strFilepath = rootFolder & cel.Value & “.pdf”
newFilePath = newFolder.Path & “” & cel.Value
If fso.FileExists(strFilepath) Then
cel.Interior.Color = vbYellow
Sheet1.Hyperlinks.Add Anchor:=cel.Offset(, 1).Value, Address:=fso.GetFile(strFilepath), TextToDisplay:=cel.Value
Set fil = fso.GetFile(strFilepath)
‘The following line will copy the file found to the newly created Sub-Folder
fil.Copy newFilePath
End If
Next cel
Set fso = Nothing
End Sub 

​I have a table with two columns (A:B), column A cells contain the names of PDF files that are in a folder directory “C:UsersTaylorDesktopFolder” and in the image I have in column B the file path of the values (1000, 1001, 1002, 1003) How can I loop through a folder and match the names of pdf files with cells in column A values and extract their path URL, and you see in the picture that number 1004 and 1005 in col B are black and don’t have hyperlink because they don’t exist in the folder.In this folder path I have pdf files 1000.pdf, 1001.pdf, 1002.pdf, 1003.pdfIMAGE: https://ibb.co/5rN4xdgThe code works well, I’m getting error in this line: Sheet1.Hyperlinks.Add Anchor:=cel.Offset(, 1).Value, Address:=fso.GetFile(strFilepath), TextToDisplay:=cel.Value MISMATCH ERROR Code:’ GO TO TOOLS THEN REFERENCES THEN ADD MICROSOFT SCRIPTING RUNTIME

Sub SearchFiles()
Dim ws As Worksheet
Dim tbl As ListObject
Dim cel As Range
Dim rootFolder As String
Dim strNameNewSubFolder As String
Dim fso As FileSystemObject
Dim newFolder As Folder
Dim fil As File
Dim strFilepath As String
Dim newFilePath As String

Set fso = New FileSystemObject
Set ws = Worksheets(“Data”)
Set tbl = ws.ListObjects(1)

‘Path of the Source folder with files
rootFolder = “C:UsersTaylorDesktopNew folder”

If Not fso.FolderExists(rootFolder) Then
MsgBox rootFolder & ” doesn’t exist.”, vbExclamation, “Source Folder Not Found!”
Exit Sub
End If

‘files that are found in the Source Folder would be copied to this New Sub-Folder
‘Change the name of the Sub-Folder as per your requirement
strNameNewSubFolder = “Found Files”

If Right(rootFolder, 1) <> “/” Then rootFolder = rootFolder & “/”

If Not fso.FolderExists(rootFolder & strNameNewSubFolder) Then
fso.CreateFolder rootFolder & strNameNewSubFolder
End If

Set newFolder = fso.GetFolder(rootFolder & strNameNewSubFolder)

tbl.DataBodyRange.Columns(1).Interior.ColorIndex = xlNone

For Each cel In tbl.DataBodyRange.Columns(1).Cells
strFilepath = rootFolder & cel.Value & “.pdf”
newFilePath = newFolder.Path & “” & cel.Value
If fso.FileExists(strFilepath) Then
cel.Interior.Color = vbYellow
Sheet1.Hyperlinks.Add Anchor:=cel.Offset(, 1).Value, Address:=fso.GetFile(strFilepath), TextToDisplay:=cel.Value
Set fil = fso.GetFile(strFilepath)
‘The following line will copy the file found to the newly created Sub-Folder
fil.Copy newFilePath
End If
Next cel
Set fso = Nothing
End Sub    Read More

​

Hi!

All pages on my site are gone (pages have been in search for years). There are no messages in the Bing console. This happened on September 7th
What could have happened?
Site: https://pluggedin.ru/

Regars,

Linar

​Hi!All pages on my site are gone (pages have been in search for years). There are no messages in the Bing console. This happened on September 7thWhat could have happened?Site: https://pluggedin.ru/Regars,Linar  Read More

​

Hi and thanks for the information contained herein is prohibited and then I will send it to you too 

​Hi and thanks for the information contained herein is prohibited and then I will send it to you too   Read More

​

I created some new folders and sub folders in a 3rd party account on New Outlook for Windows and moved items from my inbox into them. Since then the 3rd party account is not downloading emails. before then it was downloading perfectly well. 

However the same 3rd party account on the mobile Outlook app on my phone is still downloading emails but does not show the folders for that account that I created in New Outlook for windows. 

​I created some new folders and sub folders in a 3rd party account on New Outlook for Windows and moved items from my inbox into them. Since then the 3rd party account is not downloading emails. before then it was downloading perfectly well.  However the same 3rd party account on the mobile Outlook app on my phone is still downloading emails but does not show the folders for that account that I created in New Outlook for windows.   Read More

​

Hello,

I have an issue with the Outlook Ribbon and Customisation in Outlook 365 (Not the new version) on my desktop PC.

I have created specific customisations for almost every type of view, email inbox list, email read/create, calendar view, new meeting creation, contacts listing etc.

I started using customisation of the Ribbon in an attempt to get rid of some of the default items which are put in the Ribbon by the system. Namely, OneNote, Groups and Share to Teams.

At first, I tried just removing the unwanted items but found that although the customisation would work for a few minutes, or even hours, the offending items would return.

I then tried completely customising almost every item in my Ribbon by removing all of the system generated menu groups, with the exception of the “Quick Steps” item, and creating my own custom groups and adding menu items to those groups.

Unfortunately, even this approach does not work as my customisations are not honoured and the unwanted items keep reappearing in the Ribbon.

I have more than one Microsoft email account registered in my Outlook application. The first is an Exchange type email account and the other two Inboxes are for an outlook.com account and a Gmail account.

If I customise the Ribbon while viewing the Inbox for the Exchange type email account and then click on the Inbox for one of the other email accounts the customisations are honoured in the view of those email account Inboxes and the unwanted items are not displayed.

If I then click back on the Exchange email account Inbox view the three unwanted Ribbon Groups, OneNote, Share to Teams and Groups, will have been returned to the Ribbon alongside my custom groups.

The following screenshots show my customisation of the Ribbon using the “Customise the Ribbon” right mouse click option and the Ribbon display after that customisation;

The next two images show the Ribbon display, with the unwanted items which reappear in the Ribbon, after I have changed my view from the Exchange email account Inbox to one of my other email account inboxes and then back again to the Exchange email account Inbox view;

I experience the same behaviour with other folders in the Exchange email account where the customisations are not honoured whereas when viewing other folders in either of the other two email accounts, the customisations are honoured and display the way I want them to.

I do not use OneNote or Groups and I do not want or need to share anything to Teams and the presence of these items in my customised Ribbon takes up precious screen real estate.

Has anyone else encountered this behaviour with the Ribbon?

In my scouring of the internet to try to find a solution, I have seen numerous posts in which the person posting is looking for a way to remove OneNote from the Ribbon but apart from those people being pointed towards the stock standard online help topic for Ribbon customisation, I have not found any reference to the problem with one’s customisations not being honoured by Outlook.

I am now at the point where I am considering brushing off my somewhat rusty VBA for Office and creating a macro which generates a customised Ribbon and which runs every time I change from one email account Inbox to another.

​Hello, I have an issue with the Outlook Ribbon and Customisation in Outlook 365 (Not the new version) on my desktop PC. I have created specific customisations for almost every type of view, email inbox list, email read/create, calendar view, new meeting creation, contacts listing etc. I started using customisation of the Ribbon in an attempt to get rid of some of the default items which are put in the Ribbon by the system. Namely, OneNote, Groups and Share to Teams. At first, I tried just removing the unwanted items but found that although the customisation would work for a few minutes, or even hours, the offending items would return. I then tried completely customising almost every item in my Ribbon by removing all of the system generated menu groups, with the exception of the “Quick Steps” item, and creating my own custom groups and adding menu items to those groups. Unfortunately, even this approach does not work as my customisations are not honoured and the unwanted items keep reappearing in the Ribbon. I have more than one Microsoft email account registered in my Outlook application. The first is an Exchange type email account and the other two Inboxes are for an outlook.com account and a Gmail account. If I customise the Ribbon while viewing the Inbox for the Exchange type email account and then click on the Inbox for one of the other email accounts the customisations are honoured in the view of those email account Inboxes and the unwanted items are not displayed. If I then click back on the Exchange email account Inbox view the three unwanted Ribbon Groups, OneNote, Share to Teams and Groups, will have been returned to the Ribbon alongside my custom groups. The following screenshots show my customisation of the Ribbon using the “Customise the Ribbon” right mouse click option and the Ribbon display after that customisation;  The next two images show the Ribbon display, with the unwanted items which reappear in the Ribbon, after I have changed my view from the Exchange email account Inbox to one of my other email account inboxes and then back again to the Exchange email account Inbox view;  I experience the same behaviour with other folders in the Exchange email account where the customisations are not honoured whereas when viewing other folders in either of the other two email accounts, the customisations are honoured and display the way I want them to. I do not use OneNote or Groups and I do not want or need to share anything to Teams and the presence of these items in my customised Ribbon takes up precious screen real estate. Has anyone else encountered this behaviour with the Ribbon? In my scouring of the internet to try to find a solution, I have seen numerous posts in which the person posting is looking for a way to remove OneNote from the Ribbon but apart from those people being pointed towards the stock standard online help topic for Ribbon customisation, I have not found any reference to the problem with one’s customisations not being honoured by Outlook. I am now at the point where I am considering brushing off my somewhat rusty VBA for Office and creating a macro which generates a customised Ribbon and which runs every time I change from one email account Inbox to another.  Read More

​

We have deployed CA signed certificates to be used for RDP. The RDP self signed certificate in the Remote Desktop folder in the Certificate console was deleted. However the self signed certificate under the Remote Desktop folder keeps coming back even after deleting it. How to permanently delete the RDP self signed certificate so that it does not keep coming back again and again.

​We have deployed CA signed certificates to be used for RDP. The RDP self signed certificate in the Remote Desktop folder in the Certificate console was deleted. However the self signed certificate under the Remote Desktop folder keeps coming back even after deleting it. How to permanently delete the RDP self signed certificate so that it does not keep coming back again and again.  Read More

​