Macro drag raw until n raw
Hi expert
How could I use macro to drag the cell B2 to n raw as shown in attachment?
n raw is based on A column.
If have column A has 11 raw then drag cell B2 formula to B11
If have column A has 101 raw then drag cell B2 formula to B101
Hi expert How could I use macro to drag the cell B2 to n raw as shown in attachment?n raw is based on A column.If have column A has 11 raw then drag cell B2 formula to B11If have column A has 101 raw then drag cell B2 formula to B101 Read More
Text Files Taking a Long Time to Open
I’ve been experiencing a frustrating issue with text file opening speed in Windows 11. Normally, text files open quickly, but there’s a noticeable delay even with small text files in Windows 11. I suspect the new UWP Notepad app is the cause of this slowdown. Have you also encountered this problem?
I’ve been experiencing a frustrating issue with text file opening speed in Windows 11. Normally, text files open quickly, but there’s a noticeable delay even with small text files in Windows 11. I suspect the new UWP Notepad app is the cause of this slowdown. Have you also encountered this problem? Read More
Issue with Text/Font: Disordered and Difficult to Read
Hello everyone,
I recently bought a new laptop primarily for everyday internet use, but I’m having a major issue with the font/text display—it’s extremely unpleasant. No matter what I do, the text just doesn’t look smooth or natural.
As a first-time user of Windows 11, I searched online for solutions before reaching out here. I tried following the advice from various sources, including watching YouTube tutorials, but none of the common fixes seem to be working.
For instance, I diligently followed all the steps recommended in a specific video, but the problem persists across all applications. While Firefox is slightly better than Edge in terms of font display, overall, it still doesn’t feel “right.”
To provide better context, I’ll be attaching some screenshots as I’m unsure if I’m simply being paranoid. Can you take a look and let me know if you notice any issues with the text smoothness in these screenshots? I find it hard to articulate, but something definitely feels off. I’ve used older laptops running previous Windows versions, and the text rendering was way smoother than what I’m experiencing now.
Any assistance would be greatly appreciated because I can’t stand this any longer—it’s really driving me crazy.
Hello everyone, I recently bought a new laptop primarily for everyday internet use, but I’m having a major issue with the font/text display—it’s extremely unpleasant. No matter what I do, the text just doesn’t look smooth or natural. As a first-time user of Windows 11, I searched online for solutions before reaching out here. I tried following the advice from various sources, including watching YouTube tutorials, but none of the common fixes seem to be working. For instance, I diligently followed all the steps recommended in a specific video, but the problem persists across all applications. While Firefox is slightly better than Edge in terms of font display, overall, it still doesn’t feel “right.” To provide better context, I’ll be attaching some screenshots as I’m unsure if I’m simply being paranoid. Can you take a look and let me know if you notice any issues with the text smoothness in these screenshots? I find it hard to articulate, but something definitely feels off. I’ve used older laptops running previous Windows versions, and the text rendering was way smoother than what I’m experiencing now. Any assistance would be greatly appreciated because I can’t stand this any longer—it’s really driving me crazy. Read More
“I Never Expected to Be Impressed by Windows After My Experience with Vista – From a Mac User’s Pers
I recently acquired a Dell Latitude 3310 laptop for my severe weather chase team and ham radio activities. Coming from being primarily an Apple user since the release of Windows Vista, I never anticipated being impressed by any Windows version after the challenging experience with Vista. Surprisingly, after using the Dell laptop with Windows 11 Pro for a day and a half, I must admit that I am genuinely impressed with how well it functions.
Upon receiving the laptop, it had version 21H2 installed, and it suggested updating to version 22H2. I half-expected the update process to be disruptive, typical of past Windows experiences. However, I was pleasantly surprised when the update was completed and the system politely asked to schedule a restart for installation without interruption. Even during the installation process, which I anticipated to be complex and potentially problematic, everything proceeded smoothly and efficiently. When I resumed using the laptop in the evening, it performed flawlessly.
While it is still early to make a definitive assessment, my initial impression is that Microsoft may have indeed improved and created an operating system that functions seamlessly. Thus far, I am quite satisfied with Windows 11 Pro.
I recently acquired a Dell Latitude 3310 laptop for my severe weather chase team and ham radio activities. Coming from being primarily an Apple user since the release of Windows Vista, I never anticipated being impressed by any Windows version after the challenging experience with Vista. Surprisingly, after using the Dell laptop with Windows 11 Pro for a day and a half, I must admit that I am genuinely impressed with how well it functions. Upon receiving the laptop, it had version 21H2 installed, and it suggested updating to version 22H2. I half-expected the update process to be disruptive, typical of past Windows experiences. However, I was pleasantly surprised when the update was completed and the system politely asked to schedule a restart for installation without interruption. Even during the installation process, which I anticipated to be complex and potentially problematic, everything proceeded smoothly and efficiently. When I resumed using the laptop in the evening, it performed flawlessly. While it is still early to make a definitive assessment, my initial impression is that Microsoft may have indeed improved and created an operating system that functions seamlessly. Thus far, I am quite satisfied with Windows 11 Pro. Read More
Numerous Items Unexpectedly Malfunctioning
I am currently utilizing a Lenovo laptop that offers a versatile design, transforming from a traditional laptop mode to a convenient tablet mode with a touchscreen feature. Although I am unable to pinpoint the exact model due to Windows concealing such details, it closely resembles the ThinkPad X1 Carbon Gen 11 | 14-inch Intel® Evo™ laptop. My operating system is Windows version 22h2, with OS Build 2261.2506.
The primary functionalities of my device include seamless transition between keyboard and tablet modes, in addition to touchscreen capabilities. While it also features the TrackPoint pointer, I must clarify that the issues I am facing are software-related, as all hardware components function properly in other scenarios. For instance, the touchscreen may not be responsive on the desktop, but within the Windows Settings window, it works flawlessly, enabling scrolling.
I prefer utilizing the “Automatically Hide the Taskbar” option for maximizing desktop space and choose not to enable “Optimize taskbar for touch interactions when this device is a tablet.” The recent challenges began with an unexpected OneDrive login prompt, which led to authentication issues and unsuccessful attempts to submit Feedback Reports, resulting in extended loading times. Following a system restart and Windows Update installation, various malfunctions surfaced gradually.
Presently, certain prominent issues persist within my system:
1. Quick Access disappearance from File Explorer, with inaccurate resolution methods found online.
2. Touchscreen malfunction in initiating the Start Menu; only accessible via the mouse cursor.
3. Ineffective response when attempting to launch the Start Menu from the “four square” icon.
4. Failure of the Window key to activate the Taskbar and Start Menu, contrasting with Window-E for File Explorer.
5. Limited touch screen functionality on the desktop, barring Start Menu access.
6. Prolonged login durations and inconsistencies with OneDrive directory visibility and functionality.
These anomalies significantly impede the usability of my system, especially the unresponsive Start Menu. I aim to document and share visual evidence of these issues for comprehensive review and resolution. Your guidance and support in rectifying these concerns would be greatly appreciated. Thank you for your assistance.
I am currently utilizing a Lenovo laptop that offers a versatile design, transforming from a traditional laptop mode to a convenient tablet mode with a touchscreen feature. Although I am unable to pinpoint the exact model due to Windows concealing such details, it closely resembles the ThinkPad X1 Carbon Gen 11 | 14-inch Intel® Evo™ laptop. My operating system is Windows version 22h2, with OS Build 2261.2506. The primary functionalities of my device include seamless transition between keyboard and tablet modes, in addition to touchscreen capabilities. While it also features the TrackPoint pointer, I must clarify that the issues I am facing are software-related, as all hardware components function properly in other scenarios. For instance, the touchscreen may not be responsive on the desktop, but within the Windows Settings window, it works flawlessly, enabling scrolling. I prefer utilizing the “Automatically Hide the Taskbar” option for maximizing desktop space and choose not to enable “Optimize taskbar for touch interactions when this device is a tablet.” The recent challenges began with an unexpected OneDrive login prompt, which led to authentication issues and unsuccessful attempts to submit Feedback Reports, resulting in extended loading times. Following a system restart and Windows Update installation, various malfunctions surfaced gradually. Presently, certain prominent issues persist within my system:1. Quick Access disappearance from File Explorer, with inaccurate resolution methods found online.2. Touchscreen malfunction in initiating the Start Menu; only accessible via the mouse cursor.3. Ineffective response when attempting to launch the Start Menu from the “four square” icon.4. Failure of the Window key to activate the Taskbar and Start Menu, contrasting with Window-E for File Explorer.5. Limited touch screen functionality on the desktop, barring Start Menu access.6. Prolonged login durations and inconsistencies with OneDrive directory visibility and functionality. These anomalies significantly impede the usability of my system, especially the unresponsive Start Menu. I aim to document and share visual evidence of these issues for comprehensive review and resolution. Your guidance and support in rectifying these concerns would be greatly appreciated. Thank you for your assistance. Read More
Green screen error
When i startup my laptop it displays green screen saying the insider program has run into problems, now how can u fix or solve this one
When i startup my laptop it displays green screen saying the insider program has run into problems, now how can u fix or solve this one Read More
New Blog | Join us at the Microsoft Entra Suite Showcase!
This fall, we are bringing the Microsoft Entra Suite Showcase to cities worldwide. Join us to explore how our latest advancements in secure identity and access management can help safeguard your organization’s digital assets.
Announced earlier this year, the Microsoft Entra Suite unifies identity and network access security—a novel and necessary approach for Zero Trust security. It provides everything you need to verify users, prevent overprivileged permissions, improve detections, and enforce granular access controls for all users and resources.
Read the full post here: Join us at the Microsoft Entra Suite Showcase!
By Kaitlin Murphy
This fall, we are bringing the Microsoft Entra Suite Showcase to cities worldwide. Join us to explore how our latest advancements in secure identity and access management can help safeguard your organization’s digital assets.
Announced earlier this year, the Microsoft Entra Suite unifies identity and network access security—a novel and necessary approach for Zero Trust security. It provides everything you need to verify users, prevent overprivileged permissions, improve detections, and enforce granular access controls for all users and resources.
Read the full post here: Join us at the Microsoft Entra Suite Showcase!
New Blog | Azure WAF’s Bot Manager 1.1 and JavaScript Challenge: Navigating the Bot Threat Terrain
By Andrew Mathu
Introduction
Bots are a common presence on the internet, serving a range of functions from automating customer service to indexing pages for search engines. However, their capabilities can be exploited for malicious activities, such as launching botnet attacks that can compromise web applications and disrupt services. Businesses continuously face the delicate balancing act of allowing good bots to perform their functions while preventing bad bots from causing harm.
To address these challenges, Azure Web Application Firewall (WAF) has new enhancements that provide advanced protection against such threats, ensuring the security and integrity of web applications. In this blog, we will explore Azure WAF Bot Manager 1.1 in Azure Front Door (AFD) and coming soon to Application Gateway WAF, as well as the WAF JavaScript Challenge which is available in both Application Gateway and Azure Front Door. These features offer comprehensive protection against malicious bots while ensuring that good bots can continue their work without interruption.
Read the full post here: Azure WAF’s Bot Manager 1.1 and JavaScript Challenge: Navigating the Bot Threat Terrain
By Andrew Mathu
Introduction
Bots are a common presence on the internet, serving a range of functions from automating customer service to indexing pages for search engines. However, their capabilities can be exploited for malicious activities, such as launching botnet attacks that can compromise web applications and disrupt services. Businesses continuously face the delicate balancing act of allowing good bots to perform their functions while preventing bad bots from causing harm.
To address these challenges, Azure Web Application Firewall (WAF) has new enhancements that provide advanced protection against such threats, ensuring the security and integrity of web applications. In this blog, we will explore Azure WAF Bot Manager 1.1 in Azure Front Door (AFD) and coming soon to Application Gateway WAF, as well as the WAF JavaScript Challenge which is available in both Application Gateway and Azure Front Door. These features offer comprehensive protection against malicious bots while ensuring that good bots can continue their work without interruption.
Read the full post here: Azure WAF’s Bot Manager 1.1 and JavaScript Challenge: Navigating the Bot Threat Terrain Read More
SQL Server Error 823 Data error (cyclic redundancy check
We started getting below SQL Server 823 Error alerts on 3 databases.
SQL Server Alert System: ‘Error825’ occurred on
A read of the file ‘c:mdfSAmpleDB.mdf’ at offset 0x00000728018000 succeeded after failing 1 time(s) with error: 23(Data error (cyclic redundancy check).). Additional messages in the SQL Server error log and operating system error log may provide more detail. This error condition threatens database integrity and must be corrected. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
Our Full Backups & Diff backups are also failing with ‘Msg 3203, Level 16, State 1, Line 1. Read on ‘D:mdfSAmpleDB.mdf failed: 23(Data error (cyclic redundancy check)
Msg 2013, level 16, state 1. BACKUP Database is terminating abnormally
We can see The device, DeviceHarddisk0DR0, has a bad block error in eventvwr
However, DBCC CheckDB is succeeding.
These 3 databases are huge & are actually Publication databases in Transaction Replication setup.
Is there any way to fix this issue & keep DBs healthy without impacting Transaction Replication setup
We started getting below SQL Server 823 Error alerts on 3 databases. SQL Server Alert System: ‘Error825’ occurred onA read of the file ‘c:mdfSAmpleDB.mdf’ at offset 0x00000728018000 succeeded after failing 1 time(s) with error: 23(Data error (cyclic redundancy check).). Additional messages in the SQL Server error log and operating system error log may provide more detail. This error condition threatens database integrity and must be corrected. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. Our Full Backups & Diff backups are also failing with ‘Msg 3203, Level 16, State 1, Line 1. Read on ‘D:mdfSAmpleDB.mdf failed: 23(Data error (cyclic redundancy check)Msg 2013, level 16, state 1. BACKUP Database is terminating abnormally We can see The device, DeviceHarddisk0DR0, has a bad block error in eventvwr However, DBCC CheckDB is succeeding.These 3 databases are huge & are actually Publication databases in Transaction Replication setup. Is there any way to fix this issue & keep DBs healthy without impacting Transaction Replication setup Read More
New Blog | Utilizing Azure DDoS Protection Workbook for DDoS attack traffic Analysis
By Shabaz Shaik
In today’s digital age, the security of applications, servers, and networks is paramount. One of the most significant threats to this security is Distributed Denial of Service (DDoS) attacks. These attacks can cripple your infrastructure, leading to downtime, loss of revenue, and damage to your reputation. Therefore, it is crucial to implement robust protection mechanisms to safeguard your digital assets.
Azure DDoS Protection offers a comprehensive solution to defend against these malicious attacks. It provides automatic attack detection and mitigation, ensuring that your applications and services remain available even during an attack. Azure DDoS Protection is seamlessly integrated with Azure’s native services, making it an ideal choice for businesses already leveraging the Azure ecosystem. Some of the salient features of Azure DDoS Protection include Adaptive Tuning, Attack Analytics and Metrics, DDoS Rapid Response etc. By leveraging Azure DDoS Protection, businesses can ensure the resilience and availability of their digital infrastructure, providing peace of mind in an increasingly hostile cyber environment.
Read the full post here: Utilizing Azure DDoS Protection Workbook for DDoS attack traffic Analysis
By Shabaz Shaik
In today’s digital age, the security of applications, servers, and networks is paramount. One of the most significant threats to this security is Distributed Denial of Service (DDoS) attacks. These attacks can cripple your infrastructure, leading to downtime, loss of revenue, and damage to your reputation. Therefore, it is crucial to implement robust protection mechanisms to safeguard your digital assets.
Azure DDoS Protection offers a comprehensive solution to defend against these malicious attacks. It provides automatic attack detection and mitigation, ensuring that your applications and services remain available even during an attack. Azure DDoS Protection is seamlessly integrated with Azure’s native services, making it an ideal choice for businesses already leveraging the Azure ecosystem. Some of the salient features of Azure DDoS Protection include Adaptive Tuning, Attack Analytics and Metrics, DDoS Rapid Response etc. By leveraging Azure DDoS Protection, businesses can ensure the resilience and availability of their digital infrastructure, providing peace of mind in an increasingly hostile cyber environment.
Read the full post here: Utilizing Azure DDoS Protection Workbook for DDoS attack traffic Analysis
New Blog | Microsoft Entra Internet Access now generally available
With the rise of hybrid work, identity and network security professionals are now at the forefront of protecting their organizations. Traditional network security tools fall short in meeting the integration, complexity, and scale requirements of anywhere access, leaving organizations exposed to security risks and poor user experiences. To address this, network security and identity must function as a unified force in defense. Only when identity and network controls deeply integrate into secure access, can we fully deliver on the core Zero Trust principles, where trust is never implicit and access is granted on a need-to-know and least-privileged basis across all users, devices, and applications.
Read the full post here: Microsoft Entra Internet Access now generally available
By Anupma Sharma
With the rise of hybrid work, identity and network security professionals are now at the forefront of protecting their organizations. Traditional network security tools fall short in meeting the integration, complexity, and scale requirements of anywhere access, leaving organizations exposed to security risks and poor user experiences. To address this, network security and identity must function as a unified force in defense. Only when identity and network controls deeply integrate into secure access, can we fully deliver on the core Zero Trust principles, where trust is never implicit and access is granted on a need-to-know and least-privileged basis across all users, devices, and applications.
Read the full post here: Microsoft Entra Internet Access now generally available
Fórmula
Estou com dificuldades para descobrir qual fórmula do Excel poderia me auxiliar na seguinte organização de tarefas. Possuo 250 projetos, 5 pessoas na equipe para análise, preciso que cada projeto seja analisado por 3 pessoas das 5 citadas. Qual comando poderia ser utilizado para otimizar essa divisão? Obrigada
Estou com dificuldades para descobrir qual fórmula do Excel poderia me auxiliar na seguinte organização de tarefas. Possuo 250 projetos, 5 pessoas na equipe para análise, preciso que cada projeto seja analisado por 3 pessoas das 5 citadas. Qual comando poderia ser utilizado para otimizar essa divisão? Obrigada Read More
Having trouble showing number of days.
Hello all,
New to Project and when I input 60 days I want it the duration to be 60 days. Below I have a screenshot showing that when I put 60 days in duration in 1.5 it gives a finish date of 12/18/2024.
Any help would be greatly appreciated!
Example:
Today is 9/20/2024, duration of 5 days should = 9/25/2024.
Hello all, New to Project and when I input 60 days I want it the duration to be 60 days. Below I have a screenshot showing that when I put 60 days in duration in 1.5 it gives a finish date of 12/18/2024. Any help would be greatly appreciated! Example:Today is 9/20/2024, duration of 5 days should = 9/25/2024. Read More
After removing SfB on prem some users still show as AccountType – SfbOnPremUser
We recently moved to Teams Only and removed all of our SfB on prem servers. However, while attempting to use the Set-CsPhoneNumberAssignment on a user I got the following error message.
“The user is hosted in an on-premises deployment of Skype for Business Server. This user’s number must be changed in the on-premises environment and then synchronized to the cloud.”
It seems a few other users are in this state where Teams thinks they are still SfB on prem users.
Is there a way to stamp the on prem AD account with the correct properties so Teams know they are Teams users? I don’t have an on prem SfB server to move them to Teams. For example, could I modify one or more of the msRTCSIP attributes on the account?
We use Azure AD Connect to sync our users and are using Direct Routing.
We recently moved to Teams Only and removed all of our SfB on prem servers. However, while attempting to use the Set-CsPhoneNumberAssignment on a user I got the following error message. “The user is hosted in an on-premises deployment of Skype for Business Server. This user’s number must be changed in the on-premises environment and then synchronized to the cloud.” It seems a few other users are in this state where Teams thinks they are still SfB on prem users. Is there a way to stamp the on prem AD account with the correct properties so Teams know they are Teams users? I don’t have an on prem SfB server to move them to Teams. For example, could I modify one or more of the msRTCSIP attributes on the account? We use Azure AD Connect to sync our users and are using Direct Routing. Read More
Mcgraph pop-up blocking entry
I am trying to activate the MgGraph module using the access token means in PowerShell.
The access token is generated using the tenant Id and client Id acquired on the PowerShell Microsoft Graph page.
PS C:Windowssystem32> $token = Get-MsalToken -TenantId $tenantId -ClientId $clientId -ClientSecret $secureClientSecret
PS C:Windowssystem32> $accessToken = ConvertTo-SecureString -String $token.AccessToken -AsPlainText -Force
PS C:Windowssystem32> Connect-MgGraph -AccessToken $accessToken
When I run these commands, I get a pop-up and I never enter MgGraph.
How can I skip the pop-up? Help
I am trying to activate the MgGraph module using the access token means in PowerShell. The access token is generated using the tenant Id and client Id acquired on the PowerShell Microsoft Graph page.PS C:Windowssystem32> $token = Get-MsalToken -TenantId $tenantId -ClientId $clientId -ClientSecret $secureClientSecretPS C:Windowssystem32> $accessToken = ConvertTo-SecureString -String $token.AccessToken -AsPlainText -ForcePS C:Windowssystem32> Connect-MgGraph -AccessToken $accessToken When I run these commands, I get a pop-up and I never enter MgGraph. How can I skip the pop-up? Help Read More
Power Query or any other solution
Dear Experts,
I have a data in the below format(attached txt file too).
Each Packet( example for Packet-1) has the same structure.
I want to export , it to excel , with the Packet and the data under “Meta Log Buffer” as below for 1st packet.
Attached the result for just 1st Packet, the actual log file may have more than ~1000s of such Packets.
Could you please share some PQ script etc to fetch the data from the attached txt file(seems txt file not supported as attachment so zipped it) into the above format.
Thanks in Advance,
Br,
Anupam
Dear Experts, I have a data in the below format(attached txt file too).Each Packet( example for Packet-1) has the same structure.I want to export , it to excel , with the Packet and the data under “Meta Log Buffer” as below for 1st packet.Attached the result for just 1st Packet, the actual log file may have more than ~1000s of such Packets.Could you please share some PQ script etc to fetch the data from the attached txt file(seems txt file not supported as attachment so zipped it) into the above format. Thanks in Advance,Br,Anupam Read More
No me permite seleccionar mas de una hoja oculta
Hola, buena tarde.
Quisiera pedir de su apoyo, ya que al momento de querer seleccionar mas de 1 hoja oculta para poderla mostrar, no lo permite, ya intente con la tecla CTRL y SHIFT, pero no hay ningún resultado.
Además, se le pone una linea punteada roja en el contorno , dejo evidencia.
Alguien sabe como solucionarlo, saludos.
Hola, buena tarde.Quisiera pedir de su apoyo, ya que al momento de querer seleccionar mas de 1 hoja oculta para poderla mostrar, no lo permite, ya intente con la tecla CTRL y SHIFT, pero no hay ningún resultado.Además, se le pone una linea punteada roja en el contorno , dejo evidencia. Alguien sabe como solucionarlo, saludos. Read More
What’s New in Copilot for Sales – September 2024
Microsoft Copilot for Sales is reimagining sales. Integrated seamlessly into your daily tools across Microsoft 365 and Teams, Copilot for Sales harnesses the power of generative AI and customer data to keep sellers in their flow of work so they can spend more time with customers.
This month, we’re enabling features to streamline your experiences in Outlook, Teams, and Copilot Studio. First up: we’re enabling email banners* that allow you to quickly update CRM data – right from the email message! Next, users signing in to Copilot for Sales for the first time can connect to their CRM directly from Teams rather than first having to sign in to Outlook. We also enabled zero-click sign-in for Copilot for Sales extensions using Entra ID, and finally, we’re making it easy to use the sample certified connector plugin – right from within Copilot Studio!
* shown on up to 2 external emails per day in the new Outlook for Windows and in Outlook on the Web.
Capabilities highlighted below are included in this month’s release of Copilot for Sales. It may take time for specific capabilities to reach every tenant in each market.
In Outlook
Streamline CRM Tasks with actionable message banners in Outlook
Effective management of important day-to-day CRM tasks, such as adding new contacts or leads and saving customer emails, is crucial for maintaining productive customer relationships. However, these tasks can often be overlooked when exchanging emails with customers in Outlook, with sellers either unaware that these tasks can be completed using Copilot for Sales or needing to self-navigate through the sidecar to complete them.
To simplify this process and ensure that critical CRM updates are never missed, we’ve introduced Actionable Message Banners directly within the sellers’ Outlook inbox. When reading emails from external customers, these banners will surface contextual prompts that guide sellers to perform important actions directly through Copilot for Sales, such as adding new contacts or leads and saving emails to the CRM, all helping sellers stay organized and save valuable time.
Each banner is contextual to the email on which it’s shown, surfacing only relevant content and actions.
Clicking on an action will take the seller directly to the appropriate experience in the sidecar to complete the action.
Banners will be shown on up to 2 external emails per user per day.
Screenshots showing user flow for two actions, save a contact to the CRM and save an email to the CRM, both actions directly accessed from an actionable banner.
In Teams
CRM sign in experience in Teams
Today, first time users of Copilot for Sales who start from Teams face friction as they must go first to Outlook to sign into their CRM because sign in capabilities in Teams do not have parity and consistency with sign in capabilities in Outlook.
We’re excited to announce that starting this month we’re improving the sign in experience. For Copilot for Sales users who open the Teams Personal App:
Dynamics users will be automatically signed in to an environment even if they have never signed in before (similar rules as in Outlook) and they can confirm or change their environment! Also, if they have multiple environments, they will be able to switch their environment without signing out.
Salesforce® users will be able to sign in to any of their environments directly from the Teams Personal App.
Screenshot showing an example of the new user experience for sign in from Teams.
Extensibility and Cross-Surface
Sample certified connector plugin for Copilot for Sales (preview)
Currently, customers have access to a sample connector solution that helps them understand how to build a new extension for Copilot for Sales; however, to see and learn from the sample connector solution in action, customers need to take multiple steps: (1) download the connector solution; (2) import the downloaded solution in their Dataverse environment connected to Copilot for Sales; and (3) create a connection action in Microsoft Copilot Studio.
We’re very pleased to announce that starting this month customers can accelerate and get started more quickly extending Copilot for Sales by using a certified connection action that customers can discover, enable and study – directly from Microsoft Copilot Studio!
To get started, follow the instructions in the Learn article Manage extensions for Copilot for Sales (preview) using Microsoft Copilot Studio and enable the Contoso Hub connector action for Copilot for Sales. We also have more information available about the sample certified connector action.
Screenshot to illustrate the sample connector in Copilot Studio.
Simplified zero-click sign in experience for Copilot for Sales extensions using Microsoft Entra ID (preview)
Currently, Copilot for Sales users need to explicitly sign into connector plugins enabled to extend Copilot for Sales even if the connector plugin uses Microsoft Entra ID for authentication.
Starting this month, Copilot for Sales will silently create connections for connector plugins which use Microsoft Entra ID for authentication if the copilot administrator has already enabled the connector plugin for Copilot for Sales users.
This allows users to view data and insights from non-CRM applications that extend Copilot for Sales and use Microsoft Entra ID without explicitly signing into those applications again, saving time and energy.
You can learn more about how to create a custom connector and connector action and how to view insights from partner applications (preview) from within Copilot for Sales.
Screenshot of Outlook with Sales Insights added from Contoso Hub plug-in. without additional sign-in required.
Get started
Ready to join us and other top-performing sales organizations worldwide? Reach out to your Microsoft sales team or visit our product web page.
Ready to install Copilot for Sales? Have a look at our deployment guide for Dynamics 365 Sales users or our deployment guide for Salesforce users.
Learn more
Ready for all the details? Check out the Copilot for Sales product documentation.
Ready for the latest tips…and more? Copilot for Sales Tip Time can serve as a foundation for your training of Copilot for Sales users, customers, or partners! This content includes use cases and demonstrates how each feature will benefit sellers, administrators, and sales managers.
Looking for the latest adoption resources? Visit the Copilot for Sales Adoption Center and find the latest information about how to go from inspiration to adoption.
Stay connected
Want to stay connected? Learn about the latest improvements before everyone else at https://aka.ms/copilotforsalesupdates. Join our community in the community discussion forum and we always welcome your feedback and ideas in our product feedback portal.
Microsoft Tech Community – Latest Blogs –Read More
Only keeping a number/letter combination in a column
Hi all,
I want to Find and replace a column that has a bunch of rows with a text that says
“Liz A on 09/18/2024: 003TV00000DiIg6YAF”
The problem is the column will have a bunch of variety between the rows- for instance:
“Liz A on 9/19/2024: 9349943GTH4i98494”
“Liz A on 10/21/2023: 49849q1i9H0390339”
and so on (different number/letter variation and different text around it (the quotation and formatting stays the same but the info is different))
It could even be another user so the user changes.
I am wanting to delete all information in this column except the number/letter combination. But since the information around the number/letter combination can be different I’m not sure of an easy way to remove all of that text around it. Does anyone know of a way to go about this?
Hi all, I want to Find and replace a column that has a bunch of rows with a text that says “Liz A on 09/18/2024: 003TV00000DiIg6YAF” The problem is the column will have a bunch of variety between the rows- for instance: “Liz A on 9/19/2024: 9349943GTH4i98494″”Liz A on 10/21/2023: 49849q1i9H0390339″and so on (different number/letter variation and different text around it (the quotation and formatting stays the same but the info is different))It could even be another user so the user changes. I am wanting to delete all information in this column except the number/letter combination. But since the information around the number/letter combination can be different I’m not sure of an easy way to remove all of that text around it. Does anyone know of a way to go about this? Read More
