Available add-In VSTO

outlook,add-in,outlook-addin,office365

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

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

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

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

Save File Dialog in Outlook VSTO Addin

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

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

Searching user tasks by task.body text

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.

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 add images from resources folder as attachment and embed into outlook mail body in C#

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

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

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

Get Array of Values for Non-Contiguous Range

excel,debugging,visual-studio-2013,vsto

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

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

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.

Get result of ShowCategoriesDialog in Outlook

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

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

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

Replace text in MailItem Body

windows,batch-file,registry,add-in

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

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

VSTO Addin Save File Dialog

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

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

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

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

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

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

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

Outlook Addin, When Loading Error Ribbon_GetDCVisible

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

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

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

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

MailItem SaveAs() Method FIletypes

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

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

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

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

Copy Worksheet Excel VSTO C#

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

Cells format event/hook

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

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

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

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

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

VSTO Outlook Addin Ribbon Group Not Showing on Ribbon

visual-studio,add-in,vs-extensibility

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

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

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

VSTO Outlook Addin Email Sender Name