VBA: Outlook 2007 - enumerating attachments

Visual Studio Tools for Office

Windows Tech ‹ Office
- Archive
  - ISV
  - SQL Server
  - VB
  - Windows Vista
  - Smart Device
  - Visual Studio
  - VS 2008
  - VFP
  - SharePoint
  - Architecture
  - Windows Forms
  - Dotnet
  - Visual C#
  - Game
  - Windows Live
  - IE
  - VS Express
  - Office
  - VC++

- Previous
  - 1
    - Not Able to debug VSTO word Application This is happening with a new project you create, as well as with existing ones Which version(s) of Office do you have installed on your development machine Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
  - 2
    - Programmatic access to Visual Basic Project is not trusted I'm afraid this falls outside the scope of the VSTO forum. VSTO is a particular Visual Studio .NET technology. Your best bet would be one of the office.developer newsgroups, as listed in the "Please Read First" message at the top of this forum. You might also try testing on a system without SP3 installed. There have been numerous reports of "odd things" with that SP... Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
  - 3
    - Managed code extensions not working for word template Hi, If the new dll and document are in the same directory, you should just trust the new dll using caspol If the new dll and document are not in the same directory, two things to do to make it work: бд Update the manifest embedded in the document. бд Trust the dll in new location using caspol Please refer the following two walkthroughs to get the detailed information. http://msdn2.microsoft.com/en-us/library/ms404812(vs.80).aspx http://msdn2.microsoft.com/en-us/library/ms404838(VS.80).aspx Thanks Ji Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
  - 4
    - Bugs on feedback The non-default URL port bug is very concerning. I have not tried this, but did you test if this is a problem when using Visual Studio 2005 SP1 Beta if it is, the bug should probably be posted into the SP1 Beta section as well. Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
  - 5
    - UDF FOR EXCEL 2003 USING VSTO 2005 SE. See this message thread http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=426211&SiteID=1 Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
  - 6
    - Word 2007 Interop problem I've just installed Word 2003 and it works again. Wouldn't mind knowing how to fix it, but I think I might just redo it, so instead of using the interop, it just unzips the new format docx file and then does search and replace in the XML files and zips them up again. Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
  - 7
    - How to: Call native PowerPoint functionalities from my own commandbar? Hi Kenneth As mentioned in my reply to your other question, the best place to get help with this is the PowerPoint newsgroup. Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
  - 8
    - Ribbon menu and Toggle buttons Hi, This forum explicit target VSTO technology. For specific RibbonX questions the best place would be at pschmid's forum . Stephen Bullen has recently published the chapter about RibbonX from Bullen et al book "Excel 2007 VBA Programmer's reference" which may be useful. It's my understanding that radiobuttons are not available in RibbonX and the Togglebutton does not work in that way. Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
  - 9
    - Installed Office version. You should be able to check HKCU\Software\Microsoft\Office\ Under that hive, you'll see several versions there, 10.0, 11.0, 8.0, etc... I'm fairly certain that if a particular component is installed for that version of office, you'll find a folder under each of those for that component: example Word for Office 2003 would be under HKCU\Software\Microsoft\Office\11.0\Word Word for Office 2007 would be under HKCU\Software\Microsoft\Office\12.0\Word You also might want to have a look at the new ComponentCheck, it might contain the product IDs for the various installed versions of Office (I've yet to have the chance to dig into that one). You can find the source for ComponentCheck attached to this MSDN article http://msdn2.microsoft.com/en-us/library/bb332051.aspx Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
  - 10
    - Outbox Frustration Have you tried resolving the additional recipient: Set r = Item.recipients.add(" MyOtherEmail@Someplace.com ") r.Resolve BTW, the way you have it AmIThere will always be false. You should change this statement: If LCase(r.Address) = " MyOtherEmail@Someplace.com " Then to If LCase(r.Address) = "m yotheremail@someplace.com " Then Also, you should check to see that the SaveSentMessageFolder property is not set to an invalid folder reference. Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
  - 11
    - Best practices for VSTO SE Addins Is there any way which can ensure that Outlook Addins are always loaded even if Outlook is started with or Without UI assuming that all the prereqisites are installed correctly. Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
  - 12
    - Please advise on Add-in Express Hello LastHope, VSTO supports only Outlook 2003 und higher. Programming Outlook with .Net is only supported from Outlook XP and upward. If you want to be compatible with Outlook2000 and upwards, you should not use .Net and the best option here is using VB6 or C++. (just my personal thoughts) Greets, Helmut Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
  - 13
    - VSTO - Outlook AddIn and ContactItem Hello Jan, I asume that you have used an InspectorWrapper class for this. As soon as the Inspector.Close event has fired you should do: _ContactItem = null; _Inspector = null; GC.Collect(); GC.WaitForPendingFinalizers(); This hard-release should help here. Greets, Helmut Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
  - 14
    - VSTO se sorting problem Hi John, For it is another question, I will splite it into a separate one and we will discuss there:-) Now I will make sure that I understand your question in a right way. You are just trying to get the sum of pinks(it's 8 in your example), count of pinks:5, and count of pinks which are greater than zero:4. Right But I do not know what do you mean exactly when you say:"Visual Basic can't spell". Do you mean that it does not get the right RGB value of color you see in Excel's cell If I have any misunderstanding about your issue, please feel free to let me know! Thanks Ji Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
  - 15
    - Word 2003 template document running exception "This action is not valid outside of a block-level XML" when used in Word 2007 Hi Using a Word 2003 template document solution on Word 2007 i have the following exception when I am saving the document: This action is not valid outside of a block-level XML Looking at the stack trace I have seen that it happens in Microsoft.Office.Interop.Word.DocumentClass.Save(), saying object reference not set to an instance of an object. I would appreciate any help. Thanks Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
  - 16
    - Cypress Outlook 2007 addin installation problems I figured I'll give it a try here... I made a new Outlook VSTO add-in, and added a messagebox popup to the startup event. I installed it via VS on my dev machine, opened Outlook and the add-in wasn't loaded. "The Managed Add-in Loader failed to initialize". I went into VS and launched Outlook in debug mode from there. Add-in worked. Launched Outlook normally, add-in works now too. Took the setup project to an XP VM. Same error message, can't get the thing to load. I figured while I am already annoyed, I can give it a shot in Vista...Same error message. Patrick Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
- Next
  - 1
    - COM exception when trying to add picture as inline shape in Word 2007 RTM Hi Babu I can't duplicate the problem. I didn't have time to attach a schema and insert an XML element into the textbox. But I did create a textbox (of the Drawing tool type - you don't specify if that's the kind you used) in the document Header and put a bookmark in it. I had no trouble inserting an InlineShape. FWIW, during beta there was a problem with InlineShapes.AddPicture, but it appears to have been corrected. you're absolutely certain you're working with the RTM version of Office 2007, on a clean installation (one that hasn't had the beta installed) Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
  - 2
    - Word add-in and winform control Hi Eome It isn't possible to place a WinForms control on a Word document using an Add-in. You can use the full VSTO ( not the SE version) to create a document-level customization. Document-level customizations do support placing WinForms controls on Word (and Excel) document. In order to do so, VSTO wraps the controls into COM ActiveX controls. This functionality is not available outside the VSTO designer. You could create your own COM ActiveX controls and insert these into a Word document. Beyond that, only Word's internal form fields and ActiveX controls are available for you to use. As to your second question, your observations are correct. VSTO can insert/create host controls at run-time, but these are not saved in the document. You'd need to store the information somewhere, then recreate the controls each time the document is re-opened. Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
  - 3
    - Is VSTO SE for Outlook 2007 in beta ? VSTO 2005 SE, with support for creating add-ins for Outlook 2007 (among other things) was released last year about the time that Office 2007 was released. What is in beta currently is Orcas, the next version of Visual Studio, which will have design-time support for the Office "ribbon" and form regions. Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
  - 4
    - Word VSTO Issue. Hi Murali any chance that more than one version of the .NET framework is installed on these machines Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
  - 5
    - Previously working code breaks when VSTO2005 is installed? Hi Daniel This is an interesting scenario, and I'm not sure that it can be resolved without significant changes to your design. First, the Outlook View Control is not supported in VSTO scenarios - so that's a major change to start with. Second, you're trying to instantiate a new M.O.Tools.Outlook.Application object, and this is also not supported. When you create a VSTO add-in in VSTO 2005, you are given a M.O.Tools.Outlook.Application object as part of the original project creation code-gen, and there is never any reason to instantiate a new one in a VSTO add-in. Outside a VSTO add-in, of course, you cannot instantiate VSTO objects at all. Also, the fact that you're using M.O.Tools.Outlook.Application indicates that you're using VSTO 2005. This release of VSTO only supported one add-in type (Outlook), and has been superceded by VSTO 2005 SE. VSTO 2005 SE supports more add-in types, and has also changed the add-in base class model - this is what you should be using now. You can get VSTO 2005 SE from here: http://www.microsoft.com/downloads/details.aspx FamilyId=5E86CAB3-6FD6-4955-B979-E1676DB6B3CB&displaylang=en Given the first two blocking problems, this may or may not be useful to you - either way, you will probably have to significantly re-think your design. Hope that helps. Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
  - 6
    - Word ribbon customisation not working Are other things (such as the Custom task pane) loading and working correctly It's only your Ribbon XML that's not appearing Can you copy the content of the XML file you're loading the Ribbon from into a reply, plus the code that loads it, please Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
  - 7
    - Remove borders from Excel charts using C# Hi, If You change the following ((Excel.ChartObject)oSheet.ChartObjects("Chart 1")).Border.LineStyle = Excel.XlLineStyle.xlLineStyleNone; to: ((Excel.ChartObject)oSheet.ChartObjects("Chart 1")).Border.LineStyle = 0; will that solve the issue That solution works as expected in VB as the following example shows (see the sub Create_Chart_Report: http://www.excelkb.com/article.aspx id=10218 Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
  - 8
    - Send email using Outlook (Question 2) Hello cathie, using outlook from an ASP page is not a good way to send email from an server. 1. the ASP Account must have an Outlook profile. 2. Outlook needs a Desktop and sometimes it pops up messageboxes (reminders, etc.) - the ASP service runs without a Userinterface. 3. Sending an email from outside Outlook hits the security Guard. I strongly recommend to send an Email with the integrated SMTP function from System.Web namespace. As I know the SMTP-Service must not be installed, you can use an external server like the Exchangeserver within the Customer network. I recommend never install Outlook on a production server. Here is an example ( .Net 1.1 and .Net2.0 ) of a Codebehind page using System.Web; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; System.Web.Mail.MailMessage mail = new System.Web.Mail.MailMessage(); mail.From = " mustbe@acorrect.emailaddress "; mail.To = " someone@internet.com;someother@internet.com "; mail.Subject = "Here goes the Subject"; mail.Body = "Here comes the body..."; System.Web.Mail.SmtpMail.SmtpServer = "smtp.server.of.customer"; System.Web.Mail.SmtpMail.Send(mail); hope this helps, greets, Helmut Obertanner [http://www.x4u.de] Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
  - 9
    - Question re the CRM Integration Add-In Sample For Outlook 2003 (2) i have been waiting patiently for a response to this thread for over a week. if my question is naive or annoying, then please forgive me, but i assure you i am busting my gut to get my head around this thing. a response from a knowledgable person would be greatly appreciated. Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
  - 10
    - VSTO - Excel 2007 Sheet Template Hi Tom, The straight answer is that You cannot create workbook level solutions (template and workbooks) with VSTO 2005 SE. You need to have VSTO 2005 and Office 2003 (with SP-1) installed to do it - See my blogpost Requirements VSTO . Created templates works with all the versions of Excel 2007 but it's recommended to test before shipment. Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
  - 11
    - Outlook: MAPI fields versus User Properties .NET languages have no support for accessing MAPI properties in versions prior to Outlook 2007. Therefore, the UserProperties collection would be the supported approach. What kind of behaviors are you seeing as abnormal Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
  - 12
    - Using the Microsoft Office Document Imaging 2003 Viewer Control Is there a way Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
  - 13
    - Installing Visual Studio Tools for Office 2005 Hi John I'm moving this directly to the VSTO forum. You may want to do a search in that forum, once you're in there, because I believe this has come up before. I don't remember the details, however. If you do locate an answer before someone replies with the information, we'd appreciate it if you copy the link to the message thread with the answer to a reply on this message:-) Then we can mark it as "answered". Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
  - 14
    - Adding a custom Button in OutLook ? yes it is Look at the blog at this link you might find it helpful http://blogs.msdn.com/dancre/archive/2004/03/21/93712.aspx Cheers Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
  - 15
    - Outlook PST file archive db Hi. This forum is focused at questions about the use of VSTO. Since your question is about Outlook general programming, you need to re-post it to the General Outlool programming questions forum. Please see the resources postings on the first page of this forum. Thanks Mohit. Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office
  - 16
    - Use Outlook 2003 to send meeting request using c# Hi mafiaboy, Your question appears to be related directly to Outlook and VSTO, not Office Live. You should try the newsgroups for Outlook to get a faster response. This discussion board is for Office Live development only. Here are a few that may be a better fit for the information you are seeking: Outlook Programming Add-ins Newsgroup Outlook Programming Forms Newsgroup Thanks, Chris Tag: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments Office

Eric66

I am using VBA within Outlook 2007. I could not find an appropriate forum for this question.

What I want to do seems basic (pseudocode):

For Each OutlookMailItem having Attachment

If Attachment is a picture (.gif, .jpg,.bmp)

SaveToDisk (Attachment)

End If

Real simply: Each message must have an attachment. If the attachment is a picture, save it to disk.

What is the best approach for this

I cant seem to find a way because i'm stuck trying to understand GetTable which seems only to expose string representation of email properties.

Is there some way to cast one of these properties to get the actual outlook email item Or what is the best approach to do as I need

Thanks for any help.

Top

Re: Visual Studio Tools for Office VBA: Outlook 2007 - enumerating attachments

Helmut Obertanner

Hello Eric,

maybe have a look here,

Hope this helps.

greets, Helmut

http://www.outlookcode.com/threads.aspx forumid=2&messageid=21947

Top