Search results

The macro is already available. You only need to paste it as described.

Here's a sample: Print First Page of an Email - VBOffice

Show the code, please.

Item.GetInspector.Wordeditor.Printout Range:=wdPrintFromTo, From:="1", To:="1"

yep, it's really cool :) This shoud be faster as it keeps the ref on xl: private xlApp as excel.application private sub application_startup() set xlApp=new excel.application end sub The variable is set to Nothing automatically when you close Outlook.

You can pass the text to Excel: Speech.Speak Method (Excel)

It doesn't matter where the code is running. You most likely call Workbook.Save*, so you're calling a method of the Excel library. Workbook.Application refers to the Excel application object, so it's pretty simple: Workbook.Application.DisplayAlerts=false You just need to insert the variable...

I'd say it's easy, you just more code to write :-)

Outlook doesn't have that property. It's a message of Excel, not of Outlook, right? Then set Excel's DisplayAlerts property.

You'd need to move the event to a class module, loop through the entire folder hierarchy and create one object of that class for every folder. Use a collection in ThisOutlookSession to store the reference on each object of your class module. Here is a sample for the loop through all folders.

Keep in mind, after every change of the code the "initalize_handler" should be called, which isn't called automatically at startup. Better name it Application_Startup

Most likely renaming the sub did it.

See the GetDefaultFolder function, there change the passed value to olFolderSentItems.

Maybe MS closed that workaround. See if this macro still works: http://www.vboffice.net/en/developers/display-categorizer-for-outgoing-emails

See the Application.CreateItemFromTemplate function.

I don't think so.

If it's an attachment, you need to save it as a file. A msg file can be loaded with the CreateItemFromTemplate function.

you're welcome

CreateObject("WScript.Shell").Run "file.chm"

Unfortunately, there's no other option. I hope MS will improve the ribbon, which is - from a devs perspective - awful.