Available add-In VSTO

outlook,add-in,outlook-addin,office365

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

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...

Deploy Outlook add-in to Office Store

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 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...

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 =...

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.

Outlook Addin, When Loading Error Ribbon_GetDCVisible

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

Cells format event/hook

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...

Save File Dialog in Outlook VSTO Addin

vsto,ribbon,office-addins

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 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 } ...

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...

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....

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...

change the Label of a button in ribbon word add in

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...

Copy Worksheet Excel VSTO C#

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

The fact is that you are trying to use objects from different processes/threads: w.Copy(Type.Missing, Globals.ThisAddIn.Application.Workbooks[1].Worksheets[1]); The w instance belog to a newly created Excel instance, but the parameter comes from the add-in instance. If you need to copy the worksheet you need to open it in the existing Excel instance...

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...

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...

VSTO Outlook 2013 Addin Quit

c#,dialog,vsto,outlook-addin

If you need to shut down Outlook you may use the Quit method of the Application class. The associated Outlook session will be closed completely; the user will be logged out of the messaging system and any changes to items not already saved will be discarded. But if you need...

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...

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 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) {...

Replace text in MailItem Body

visual-studio,add-in,vs-extensibility

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,...

How to create VSPackage project from VisualStudio2015?

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

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)); ...

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

ms-office,vsto,outlook-addin

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...

Get Array of Values for Non-Contiguous Range

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

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....

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)....

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...

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...

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...

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.

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...

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...

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...

VSTO Outlook Getting Email Address From Someone with same Domain

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

Get result of ShowCategoriesDialog in Outlook

excel,debugging,visual-studio-2013,vsto

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

Debug Excel VSTO add-in when launched by double-clicking existing file

Try to use any logging mechanisms to log any action in the code. Thus, you will be able to find what is going on in the code at runtime. For example, you can write actions to the log file. You may find the log4net library helpful.

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....

Add Registry Key Data With Quotes

windows,batch-file,registry,add-in

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...

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...

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...

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. ...

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....

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...

VSTO Outlook Addin Ribbon Group Not Showing on Ribbon