office-js | NPM package for Office.js , corresponding to a copy | Email library

We're using Office JS to develop an Addin for Outlook Calendar. For the same appointment, the EWS Ids of the Organizer and Attendees do not match. Apparently I need ICalUid from Exchange which is common across organizer and attendees and common across different events for the same Item, exactly what we need. But Office JS does not provide such property nor method to fetch it (only for .NET).

But Office JS provides Office.context.mailbox.makeEwsRequestAsync with which I can make SOAP requests to the Exchange server, using XML.

What is the EWS SOAP XML code to get ICalUid from EWS Id?

Does this work? Just replacing FieldURI with ICalUid?

I've been using getRangeByIndexes as it seems to be the best way to use numbers to get Ranges in Office-JS. Problem I'm having is that when I need to use entire row/columns, I've resorted to the below. I read up and looks like number of rows/cols hasn't changed in a long time, but I know in vba I used rows.count to make sure the code was dynamic, whatever version of Excel it would use the number of rows on a spreadsheet.

Is there anything similar in Office-JS?

I am new to the Office-JS API, but trying to develop a POC to demonstrate the ability to, with the click of a button, replace all fields in a Word document with corresponding data retrieved from an API.

So I have developed an API as an Azure Function, which I can call, passing a value, and it will return the field names and values as JSON for the record that matches the passed value. I have tested this already using Postman.

Now I am trying to get the Office-JS piece working. I started with the VS-2022 template, which I have converted to TypeScript.

My intended approach is that when the user clicks the button, the application will call the API and obtain the record (data) fields as a set of name/value pairs.

Then, I want loop through all of the (data) fields returned, and for each (data) field name, check to see if there is a (document) field in the document by that name; if so, replace the (document) field with the (data) field's value.

This code is successfully finding the search criteria, and queueing up the replacements, in preparation for the context.sync call... But then during the context.sync call, is reporting an error "ItemNotFound."

I am following the recommended approach documented here https://docs.microsoft.com/en-us/office/dev/add-ins/concepts/correlated-objects-pattern under the "Process objects in the document with the correlated objects pattern" section.

My code follows:

I am new to the Office-JS API, but trying to develop a POC to demonstrate the ability to, with the click of a button, replace all fields in a Word document with corresponding data retrieved from an API.

So I have developed an API as an Azure Function, which I can call, passing a value, and it will return the field names and values as JSON for the record that matches the passed value. I have tested this already using Postman.

Now I am trying to get the Office-JS piece working. I started with the VS-2022 template.

My intended approach is that when the user clicks the button, the application will call the API and obtain the record (data) fields as a set of name/value pairs.

Then, I want loop through all of the (data) fields returned, and for each (data) field name, check to see if there is a (document) field in the document by that name; if so, replace the (document) field with the (data) field's value.

In the end, I realize it would likely be more efficient to loop the other way (loop through the doc fields, and then get the (data) field's value, etc.), but I figure I can tweak this once I get it working.

I also realize it's bad practice to perform a context.sync() within a loop, but again - I can clean that up once I get it working.

Right now, my code is reporting "Error: InvalidRequestContext: Cannot use the object across different request contexts."

My code follows:

I have a big Google Apps Script project working on Google Spreadsheets and I am trying to convert it to an office-js add-in that works on Excel Workbooks. I understand that it is good practice to put everything that will be calling excel specific functions (directly interacting with the workbook) into an Excel.run() function so it does a proper clean-up and no memory leaks occur. I also understand I should do context.sync() as little as possible to optimize performance.

Here are my questions, (I think some of them come from my incomplete grasp of how js works; these things GAS handled without me needing to question them) :

1a) When we put our block of code in

We have a client that wants to run our Excel Add-in (web-based Office Add-in written with office-js), however, they don't have Edge or IE installed. They are running Version 2008 (Build 13127.21766) of Excel, which according to the documentation from Microsoft uses the EdgeHTML WebView (Edge Legacy)

I know with the WebView2 runtimes you can install the runtime separately since Windows 8.1 and 10 didn't come with that runtime. Can the same process be followed for the EdgeHTML WebView (Edge Legacy), as in can we install an EdgeHTML WebView runtime while not having Edge installed? If so can someone point me in the right direction on where to get this runtime from?

I'm trying to add Conditional Highlighting to a column in Excel via Office-JS. I used the automate feature for the first time, but I can't seem to get it to work in Excel.

This is what automate spat out:

Is it possible with an Outlook add-in to automatically reply only to certain emails/senders, based on custom logic? If so, how?

Such an add-in might send an automatic reply only to senders not in contacts, or only to senders whose email has been verified by an external service (which the add-in calls to check). This automatic reply might be:

Thanks for your email! I prioritize emails from verified senders. You can verify yourself for free here.

The sender who receives that message could then click the link and verify through the external service. Then, for future emails, the automatic reply would NOT apply to that sender.

Outlook has an automatic reply option in settings, but its functionality is limited to setting a specific message for internal senders and a different one for external senders, plus choosing whether to only use the automatic reply with contacts. There's no built in ability to accomplish what's described in the examples above.

• Office-js: How I can reply automatically with Outlook Web Add-in?: This may be relevant, but it's hard to tell because the link in the answer is broken now (the answer is from almost 4.5 years ago).
• How can I edit the automatic reply in outlook using c#: Also might be relevant, but also has a broken link in the answer (which is from almost 7 years ago).

Any help would be very much appreciated!

I have the following package.json for my React project.