Available add-In VSTO

ms-office,vsto,outlook-addin

There is no such event. Your main events are for Workbook and Worksheet objects. Intellisense is presumably giving them all to you. If not, check out the MS reference for Worksheet events. There is a similar list for Workbook. These are also the same as the events available within the...

Outlook 2010 - how to receive attachment events when mail item is created from Word or Excel

BeforeAttachmentAdd event will not fire. But NewInspector fires just fine for me - do you see the event in OutlookSpy if you click Application button, select the Inspectors property, click Browse, go to the Events tab and look at the log at the bottom of the tab? Since NewInspector event...

How to programmatically add errors for a Monodevelop Project?

monodevelop,add-in

The trick is to create a Task like this: TaskService.Errors.Add (new Task ("/path/to/file.xx, "Error message ", 10, 30, TaskSeverity.Error)); ...

Excel DNA how to get events for each minor change in spreadsheet?

c#,excel,vsto,excel-dna

The COM object model that Excel provides, together with the set of events exposed by the Application, Worksheet and other objects, is the richest set of information available from Excel. VSTO, and any other type of add-in (including those built with Excel-DNA), are restricted by the same COM object model...

How can I reliably get the object of a contact context menu in an Outlook 2013 addin?

c#,vsto,outlook-addin,outlook-2013

The type of the Context object depends on the place where you clicked and the context menu type. To get the underlying type you need to do the following: Cast the object to the IDispatch interface. Get the ITypeInfo interface using the GetTypeInfo method of the IDispatch interface. Get the...

How to create VSPackage project from VisualStudio2015?

visual-studio,add-in,vs-extensibility

Finally i got solution to my problem from the below link https://social.msdn.microsoft.com/Forums/vstudio/en-US/e1dcc380-d87d-4f76-89ff-07a65b917640/vs-extension-from-vs2015?forum=vsx#ec3165d6-7230-4afb-8254-7959547c2c5d

Save File Dialog in Outlook VSTO Addin

c#,vsto,outlook-addin,outlook-2013

I don't think you absolutely need to use a save dialog via a form; In your ribbon code add this: On top using System.Windows.Forms; Then this function /// <summary> /// Return selected file from winform save dialog /// </summary> /// <param name="fn">The filename</param> /// <param name="id">The initial directory</param> /// <returns>Specified...

VSTO Outlook Addin Dialog Boxes

c#,wpf,vsto,outlook-addin,office-addins

You can use a regular System.Windows.Forms.Form instance to display a dialog window for collecting the required information. Use ShowDialog method which shows the form as a modal dialog box with the specified owner. Don't forget to psecify the parent window handle to prevent any changes in Outlook. The IWin32Window interface...

How to add images from resources folder as attachment and embed into outlook mail body in C#

Create an attachment and set the PR_ATTACH_CONTENT_ID property (DASL name "http://schemas.microsoft.com/mapi/proptag/0x3712001F") using Attachment.PropertyAccessor. Your HTML body (MailItem.HTMLBody property) would then need to reference that image attachment through the cid: img src="cid:xyz" where xyz is the value of the PR_ATTACH_CONTENT_ID property. Look at an existing message with OutlookSpy (click IMessage button)....

Deploy Outlook add-in to Office Store

outlook,add-in,outlook-addin,office365

The manifest '.xml' file is the xml file that you need to upload (you are right, it isn't a package - that wording is for SharePoint apps and is confusing). Make sure that you are using the manifest that has the full URL references and not the localhost references that...

VSTO document-level customization Intercept Commands

c#,ms-word,vsto

You may have to use repurpose commands. Here is the how to In Ribbon.xml <commands> <command idMso="Paste" onAction="CustomPaste"/> </commands> In Ribbon.cs public void CustomPaste(Office.IRibbonControl control, bool cancelDefault) { //Globals.ThisAddin.Application.Selection.Paste(); //Check if the pasted content is image and then add caption to it } ...

Get result of ShowCategoriesDialog in Outlook

No, it is not. The Outlook object model doesn't provide anything for that.

How to add a ribbon group to both Outlook inspector windows and the inline response contextual menu?

c#,outlook,vsto,outlook-addin,ribbonx

No, you need to define tabs separately. But there is no need to return the whole custom UI XML at once. Actually you need to return an appropriate ribbon XML markup depending on the value passed to the GetCustomUI method of the IRibbonExtensibility interface. The RibbonID string parameter indicates the...

VSTO Addin Form Closing Handler

c#,forms,vsto,outlook-addin

There is no need to declare the Closing event because the parent class provides the event out of the box. Moreover, you can simply set the event handler without declaring the delegate class (latest .net versions): public Form1() { InitializeComponent(); OtherInitialize(); } private void OtherInitialize() { Closing += Form1_Closing; }...

VSTO Addin Save File Dialog

you need an event handler to do that. for example add a button. In button_Click method, call the ShowDialog method on the saveFileDialog instance. this example in MSDN shows an example that saves file with text extension. EDIT private void button1_Click(object sender, EventArgs e) { saveFileDialog1.FileName = "DefaultName.txt"; saveFileDialog1.Filter =...

Getting Outlook Window from VSTO Addin

c#,outlook,vsto

The FindWindow method retrieves a handle to the top-level window whose class name and window name match the specified strings. The first parameter specifies the window class name. The second parameter is the window name (the window's title). If this parameter is NULL, all window names match. Instead of using...

How to Expose Listbox in UserControl in CustomTaskPane VSTO C#

c#,ms-word,vsto

It appears my foreach (and hence my cast) was not correct (per Eugene Astafiev's question in the comment above). I found this SO Post that suggesting looping with type Control instead of UserControl. I did this and all was good. Here is the code: foreach (Control lbxControl in myUserControl.Controls) {...

VSTO Outlook Getting Email Address From Someone with same Domain

c#,vsto,outlook-addin,office-addins

If SenderEmailType == "SMTP", just use SenderEmailAddress. If SenderEmailType == "EX", use MailItsem.Sender.GetExchangeUser().PrimarySmtpAddress. Be prepared to handle null and exceptions....

Outlook 2013 VSTO: Determine which calendar an AppointmentItem is on?

outlook,vsto

The key is to get a Folder object from Explorer.CurrentFolder via Application.ActiveExplorer. Shared folders will have the Folder.EntryID value duplicated in Folder.FolderPath, while non-shared folders will have an actual folder path value. You can also use NameSpace.GetSharedDefault if you want to get a proper reference to a shared folder....

Deploying VSTO Addin with Windows Installer

The page you mentioned in the post describes how to create a new setup project. In Visual Studio, open the Office project that you want to deploy. On the menu bar, choose File, Add, New Project. The Add New Project dialog box opens. In the templates pane, expand Other Project...

VSTO Addin Connecting to MSSQL

c#,sql-server,vsto

You may treat your VSTO based add-in as a regular .Net application. There is no anything specific from the Db perspective. The only difference is that your VSTO assembly is run within the host application (not standalone). So, I'd suggest reading any good book on how to use SQL databases...

Word Add-in keeps Word process alive when document is embedded via OLE

c#,com,ms-word,vsto,ole

Instead of attaching the DocumentBeforeClose event handler on application startup, consider attaching it on document open—and only if it's not an embedded object. The tricky part is determining whether the document being opened is an embedded object. I haven't found any documented way to explicitly check whether an Automation application...

Excel CustomTaskPane with WebBrowser control - keyboard/focus issues

c#,excel,winforms,excel-2010,vsto

Ok I was able to fix the issue using the following code protected override void WndProc(ref Message m) { if(m.Msg == 528 && !this.Focused) { this.Focus(); } base.WndProc(ref m); } I added this function to my TaskPaneView which is simply a UserControl with that webbrowser child. I don't have a...

Searching user tasks by task.body text

c#,visual-studio-2013,vsto,outlook-addin

Why not use the user properties (TaksItem.UserPropertiers.Add)? If the user fields is added to the folder fields, you can search for that property using Items.Find/FindNext/Restrict.

Get Array of Values for Non-Contiguous Range

Since you do not want to use any of the methods mentioned in the links that I gave you above and you also do not want to copy the data to a new worksheet then this is the only way I can think of. Logic Open workbook as Read Only....

Outlook 2013 VSTO: How to get original MeetingItem for an Appointment?

outlook,vsto

Searching by the appointment id is the only way. There is no other way since there is no one-to-one correspondence between an appointment and (potentially) multiple meeting items in the Inbox and Sent Items folder. Also keep in mind that Outlook Object Model will not let you search for binary...

Format too old or invalid type library in Chinese Excel 2010

c#,ms-office,vsto

This is a well-known issue when automating Office applications. There are two possible ways to avoid the issue: Use the late binding technology specifying the culture information when calling properties and methods, see Type.InvokeMember for more information. Set the CultureInfo prior to calling any Excel properties or methods. You can...

Outlook Addin, When Loading Error Ribbon_GetDCVisible

windows,batch-file,registry,add-in

Answer was to rebuild and check startup code. My problem was a duplicate key in dict during startup.

Unit Testing VSTO projects

c#,unit-testing,vsto

If this is your first time at unit testing, then VSTO might be a steep learning curve. As suggested by @Sam Holder, you might want to put some of your logic into a separate assembly to encourage you to separate your logic from your interactions with the office infrastructure. That...

The customization cannot be run because the solution ID in the document does not match

visual-studio-2010,vsto

Do you develop a document level add-in? If so, you need to include the Excel file into the installer package. Make sure that you did all the steps described in the Publishing an Office Solution by Using Windows Installer article. ...

Way to capture double click to open file?

excel,vba,excel-vba,add-in

I tackled this by using 2 instances of Workbook_Open inside an excel Addin. When a file is loaded, the addin starts up, and checks to see if there are any active workbooks. If there is none, then we wait a little bit and check again, looped as many times as...

Unload addin .xla when uninstall Excel interop add-in

excel,interop,action,add-in,uninstall

Don't use Addins.Add - just have A open the XLA as if it was a workbook. Then when Excel closes the XLA will close and you don't need to mess with the Addins manager.

C# How to Determine if Netwokr Path Exists w/o new Process

c#,vsto

You can run a check on a secondary thread which you may cancel if it hangs. The simplest way is to use the BackgroundWorker component. See How do I run a simple bit of code in a new thread? for more information. Also see the How to: Create and Terminate...

VSTO - How to make Ribbon buttons to fill vertically the blank space

excel,button,vsto,ribbon,fill

The Fluent UI doesn't provide any property or attribute for that. Read more about the Fluent UI (Ribbon UI) in the following series of articles: Customizing the 2007 Office Fluent Ribbon for Developers (Part 1 of 3) Customizing the 2007 Office Fluent Ribbon for Developers (Part 2 of 3) Customizing...

How to get rowspan and cospan of word document table using openXML

c#,vsto,openxml,openxml-sdk

Finally I found the solution, private static int CalcColspan(XElement cell) { if (cell.Name != W.tc) return 0; return cell.Element(W.tcPr).Element(W.gridSpan) == null ? 1 : Convert.ToInt32(cell.Element(W.tcPr).Element(W.gridSpan).Attribute(W.val).Value); } private static int CalcRowspan(XElement cell) { if (cell.Name != W.tc) return 0; int rowspan = 1, colNum = 0; XElement currentRow = cell.Parent; foreach...

Add Registry Key Data With Quotes

Quotes need to be escaped on declaration when setting the variable and you should also put \" around the %PATH%, like this: setlocal enableDelayedExpansion setlocal ENABLEEXTENSIONS SET VERSION=15.0 SET PATH=\"C:\Program Files\Microsoft Office\Office15\Library\Custom_AddIn.xlam\" REG add HKCU\Software\Microsoft\Office\%VERSION%\Excel\Options /v OPEN /t REG_SZ /d "%PATH%" /f...

Issues reading unread mails in Outlook

c#,.net,outlook,vsto

The NewMailEx event of the Application class is not the best place for searching unread emails. This event fires once for every received item that is processed by Microsoft Outlook. The item can be one of several different item types, for example, MailItem, MeetingItem, or SharingItem. The EntryIDsCollection string contains...

change the Label of a button in ribbon word add in

vsto,ribbon,office-addins

The visual designer for ribbons in word is a little limited, you can get much more functionality by using an XML ribbon, although it is a little more work. You could do handle this by creating two buttons and then creating a GetVisible method in your ribbon code. The XML...

MailItem SaveAs() Method FIletypes

c#,vsto,outlook-addin,office-addins

I am not sure how it is possible to get a wrong extension if you are the one who specifies the file name (which includes the extension) when calling MailItem.SaveAs. Make sure you specify fully qualified file name that includes the directory, filename, and extension....

Document.Fields.Update event in Word 2010 C#

c#,vsto,word-2010

Try repurpose command This will be invoked when you do Fields Update, but you need to make sure you are updating the fields manually in the code when you do repurpose. Ribbon.cs public void TestFieldsUpdate(Office.IRibbonControl control, bool cancelDefault) { MessageBox.Show("Field Updated"); Globals.ThisAddIn.Application.Selection.Fields.Update(); } IdMso should be valid control identifers. You...

How can I create a style with borders from VSTO code?

c#,vsto,outlook-addin,office-addins

According to this discussion, it seems that there is a difference between the borders of a style and the borders of a range: the latter are indexed by XlBordersIndex (xlEdgeTop, xlEdgeLeft,...), as stated in the documentation, but the former are indexed by Constants (xlTop, xlLeft,...). This can make sense if...

MailItem user property of type olDateTime showing by default 12/30/1899 value. How can we show empty instead?

Null gets converted to 0, which in COM (it uses 8 byte floating point for date/time values) is 12/31/1899. If you do not want to set a value, don't set it at all. Or set it to 1/1/4501 - that special date means "no data" in Outlook.

Dyncamically change ribbon button image in Excel ( C#, XML)

c#,xml,button,vsto,ribbon

You need to use the Ribbon XML markup. Declare the getImage callback for the buttons in the XML markup and add a corresponding event handler to the code. Call the Invalidate or InvalidateControl method of the IRibbonUI inteface when you need to change the image on ribbon controls. Your callbacks...

VSTO Outlook Addin Ribbon Group Not Showing on Ribbon

The greyed buttons mean that your custom UI is disabled. Most probably you got an error in the markup or your code fires exceptions. Office applications disable add-ins that behave unexpectedly. I have got a bunch of questions to the initial post, so decided to publish them as an answer...

COM Interop RCW Reference Count for an Excel Range Object

c#,excel,vsto,com-interop

After a little bit of debugging... The proxy returned and used in the managed code for the worksheet object persists between function calls for the whole app domain. For example assume you have two methods called sequentially Method1 and Method2 and each method sets a reference to the worksheet object....

VSTO Outlook Addin Email Sender Name

The Sender property returns an AddressEntry object that corresponds to the user of the account from which the MailItem is sent.

Replace text in MailItem Body

I've got it working by displaying the Inspector window, as this seems to resync the MailItem.Body and RTF/HTML properties with the Word Document after preforming the find and replace. But it's slow and flicker'y. I've pasted the code below. If anyone can think of a faster and less flicker'y way,...

Copy Worksheet Excel VSTO C#