Getting Started with Microsoft Loop for Sales
Good Afternoon, I've scoured the web and can't find the information I'm looking for in terms of getting setup to use Loop. The tool, on the surface, appears to be exactly what I need, but I'd like to see if I can get some more pointed feedback on how to…
VBA Outlook: AddressList.AddressEntries collects only the first 500 entries of address list
I am using O365 classical outlook on Windows 10 Considering classical VBA code bellow, AddressList.AddressEntries only collects the first 500 entries. Indeed, browing "All Users" global list in Outlook AddressBook Window, I see the same last…
Does OneNote support AppleScript?
I use applescript to automate Outlook on Mac, but am finding few resources for doing the same with OneNote. Does it even exist? Anyone have example of scripts they used for it? I want to: Find notes in notebooks/tabs Create notes Rename notes Copy Notes…
Please help on Pivot Table Refresh online
Hello, I'm having issue with refreshing pivot tables using Excel Online. The pivot tables are built using data model with data source from the tables in existing workbook. When I refresh manually using "Refresh Selected Connection"…
VBA "Type Mismatch " Error in Office 64-bit
Hi , We have a VBA program that has been working for years. During the test with office 64-bit, we get this error message "Type mismatch" as you can see from the attachment. This piece of code is used to open a simple existing text file from…
Availability of OnMessageReadWithCustomHeader for Web and New Outlook on Windows
Hello, I would like to know when the OnMessageReadWithCustomHeader events will be available for Outlook on the web and the new Outlook for Windows. This feature is essential for our workflow, and we would appreciate any insights on its expected rollout…
Having trouble getting my Outlook Add-in manifest to work
Hello, I'm trying to develop an outlook add-in for my company that detects if there are external recipients in the to, cc, or bcc columns. I have developed all of the necessary files (HTML and JS) but I have not been able to figure out how to organize my…
when will this function 'getImageAsBase64(options)' be available for use in production?
When will the getImageAsBase64(options) function be available for use in the production environment? It is currently still in beta/preview. Is there an estimated timeline for its release?
Upload apps to be deployed
Hello, I have the problem that I cannot check a manifest file (.xml). I keep getting the error message marked. Do you have any tips for me? Regards
Is there any usable way to copy Microsoft Excel sheets using the Graph API only?
Scenario I am developing an RPA integration application that automates several services, including Microsoft services via their APIs (specifically Microsoft Graph). I want to copy sheets in Microsoft Excel, but the Graph API does not fully support this…
further develop the =UNIQUE formula
in Excel, could we build on the =UNIQUE formula and have =UNIQUEIF and =UNIQUEIFS with my current problem, I am looking at data spanning several years and I want to create a unique list of people for any given year/month at a time. by having a UNIQUEIF…
How to reactivate a deleted developer e5 Tenant
Hello, I had to take an extended LOA and it appears my tenant didnt auto renew with my E5 subscription. I was wondering how i can reactivate this and get this back, or atleast start a fresh new tenant. I typically only use this for graph api and demoing…
How to Display Full Data Results Instead of Preview in Excel Copilot's Advanced Analysis?
I am using advanced analysis in copilot through excel in order to use python to create a model that analyses my data. When I get my results printed in a new sheet, it only shows a preview, is there any way to avoid the results being shown in a preview…
PropertyNotLoaded Error Persisting after calling load and context.sync
I am creating a Word add-in using the javascript API. I am hitting a 'PropertyNotLoaded' error when trying to access items within my rangeCollection. As far as I can tell, I have loaded items/text and have called await context.sync() before I use the…
How to Deploy Excel Addin
I have developed an Excel addin using Typescript and deployed a version to Azure. I am able to sideload the addin on the windows app, mac app and through the web version of Excel. This all works great. I am very happy with the features and functionality…
Outlook for Mac add-in, and for a particular user, we are getting prompts
We have an Outlook for Mac add-in, and for a particular user, we are getting prompts that a secure connection cannot be established with the server and that the user needs to trust the certificate. If he trusts the certificate, the add-in will work, but…
Why do I keep getting the error message "value must match one of the listed items" in an excel multi-select list?
I have inserted a VBA code from https://www.ablebits.com/office-addins-blog/create-multi-select-dropdown-excel/#comment-714534 to enable me to select multiple items in a dropdown list. It works perfectly for me if the cells aren't formatted as a table.…
How to safely keep and access my API Keys when hosting on Azure storage containers?
I am hosting an outlook add-in on Azure Storage Containers base on this link: https://learn.microsoft.com/en-us/office/dev/add-ins/publish/publish-add-in-vs-code I have some API keys in my .js file, may I know where I can host them? What are the exact…
chart.Axes(xlCategory).CategoryNames function doesn't work in vba excel
chart.Axes(xlCategory).CategoryNames doesn't want to overwrite my x axis labels
Calling from VBA a Excel Webb AddIn custom function with Application.Evaluate does not work
I have generated a Excel Web AddIn with VS Code using the extension "Office Add-ins Development Kit" (Yo office) and I used the options "Excel Add-In", "Excel custom functions using shared runtime", Typescript. I have…