ThreadLast AuthorMessages
read/total
Date
Still having issues with the SelectionChange event....
Ken Slovak - [MVP - O...
0 / 2 19 Mar
As you've no doubt guessed by now there is no such event. Only the workarounds presented in your earlier thread are possible. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm <elandau1@gmail.com> wrote in message...
Using MSXML2.XMLHTTP in VBA?
Kevin07003
0 / 3 18 Mar
Thanks - that was part of the problem. I haven't used VBA since 1998 or so! Here is the working code that also parses the XML Response: Private Sub TestXMLHTTP() Dim strURL As String Dim oReq As Object Set oReq = CreateObject("MSXML2.XMLHTTP") Dim oDOM As Object Set oDOM = CreateObject("MSXML2.DOMDocument.3.0") oDOM.async = "false" Dim oNodeList As...
Can I assign Alt-UpArrow as a shortcut key to a macro?
elandau1@gmail.com
0 / 3 16 Mar
Thanks again Sue. -Ed...
CreateObject("Outlook.Application") failing to get outlook
Ken Slovak - [MVP - O...
0 / 2 14 Mar
One thing that can cause that, assuming Outlook is installed and registered correctly is a script stopper. Some A-V software or software firewalls have script stoppers that prevent CreateObject() and/or GetObject() from working. It shouldn't be related to whether or not Outlook is the default mail handler, that doesn't have anything to do with CreateObject(). There have been some...
Response Status for each member in a DL?
melon
0 / 1 13 Mar
Suppose I have a MeetingItem. MeetingItem.Recipients contains 1 member, and it is a DL. I can extract individual members of the DL using AddressEntry.Member. However, AddressEntry does not contain MeetingResponseStatus. Is it possible to obtain the MeetingResponseStatus for each recipient in the DL? Do I need to do something like 1) Extract AddressEntry from the DL. 2) Add all...
Adding Contact to shared Contacts with Redemption
McKilty
0 / 12 13 Mar
On Mar 13, 10:18 am, "Ken Slovak - [MVP - Outlook]" <kenslo...@mvps.org> wrote: > Does the code work on other computers aside from this one? > > You can't register stdole directly. How are you installing your VB6 code? > Just include that dll in your deployment package. > > Did you run the Office repair on the problem computer as I suggested? > > -- > Ken Slovak > [MVP -...
text message icon not showing outlook2007
sathai
0 / 2 13 Mar
I comment this in the community content at http://msdn2.microsoft.com/en-us/library/bb277361.aspx Can anybody advise me on how to fixed this issue. Thanks...
Help writing a macro to move emails
sandeepthanki@gmail.com
0 / 11 13 Mar
...
Access/Excel/Outlook/VBA/VSTO/SharePoint
jACK
0 / 1 12 Mar
I have a huge assignment and right now I am doing research. I need to design basically a business tracking set of tools, either in Visual C+ + or C# or Basic; or just Office with VBA. Basically we start a job, and then when it is complete, I need to have it so someone can just click a button and set a status, and then have email sent out to responsible parties, and once they finish their...
copy email once it's marked as completed
limi
0 / 3 12 Mar
Thanks a lot. I got some progress from your direction. Thanks, limi "Ken Slovak - [MVP - Outlook]" wrote: > For #2, ConversationTopic is the same for all mail items in the same thread. > ConversationIndex increases by a date/time struct size amount for each new > item in the thread. > > #1 can be done automatically or manually. For manual you'd create your macro > and then...
Help parsing body text
Klaus Linke
0 / 7 11 Mar
I agree. If you want to use the array approach, I had posted sample code to your question in microsoft.public.word.vba.general. The different number of cells in the rows should not matter much ... as long as you can determine which column corresponds to which weekday. Klaus "JP" <jp2112@earthlink.net> schrieb im Newsbeitrag news:81dfca73-9a37-4433-a443-98e79f663e1e@s12g2000prg....
How to add button on Mail editor which is not outlook.??
Ken Slovak - [MVP - O...
0 / 39 10 Mar
Items in a combobox control are based on the XML you supply for that combobox when the control is first created and accessed. If you want a dynamically created control use a dynamicMenu control, that you supply with the contents using the getContent callback. Otherwise you'd have to create your ribbon XML dynamically when asked for it and it wouldn't be changeable. -- Ken Slovak...
Newbie - need some pointers about reading email and create calendar invites
Ken Slovak - [MVP - O...
0 / 2 08 Mar
item.Body is the plain text string of the mail item. Code run from an open item would use Application.ActiveInspector.CurrentItem to get the current item. For a button in an Inspector in Outlook 2003 or earlier right-click on a toolbar or menu bar and select Customize. The Commands tab lets you select Macros, which you can then rename when they are added to a toolbar or menu. A...
VBA .Move or .Copy Resets All Properties
Dmitry Streblechenko
0 / 6 04 Mar
set Msg = Msg.Move(SomeRDOFolder) Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool "David T." <DavidT@discussions.microsoft.com> wrote in message news:DFC5A6AF-B250-41BE-9551-113B98CFC22E@microsoft.com... > Do you happen to have the code as an example. I to am trying to properly > implement the replacement of the standard .move...
Warning dialog when sending mail from Access
Sue Mosher [MVP-Outlook]
0 / 2 04 Mar
See http://www.outlookcode.com/article.aspx?ID=52 for your options with regard to the "object model guard" security in Outlook 2000 SP2 and later versions. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "DomThePom" <DomThePom@discussions.microsoft.com>...
outlook form error -2147467259
Sue Mosher [MVP-Outlook]
0 / 2 04 Mar
"wrote an outlook form via VB" -- given that is is not possible to create a Outlook custom form with VB, please clarify what you're actually doing. My hunch is that you are creating a new item that uses a custom form, but we won't know that unless you provide us code or more details. Where the form is published is also very relevant. -- Sue Mosher, Outlook MVP Author of Microsoft...
How can I assign custom keyboard shortcuts to Macros?
Sue Mosher [MVP-Outlook]
0 / 6 03 Mar
The simplest approach is to try the key combination and see what happens. If nothing happens, try using it for your macro. If still nothing happens, give up on that key combination (because it would seem to be reserved by Outlook for some mysterious purpose) and try another one. You could also write code to iterate the top-level menus and toolbars to list their captions so you can see what...
Can I tell which folder an email is in?
elandau1@gmail.com
0 / 9 29 Feb
I think I understand where you are headed. It seems like this is a little back-asswards: What I want is to say: If I've moved to the next email and the previous one is still there, unflagged... then move it. What you are suggesting is that I handle pretty much any event I could possibly do (Delete, move etc.) and implement those in addition to the move. I will not go down this...
Adding Contact to shared Contacts with Redemption
McKilty
0 / 1 28 Feb
Grasping at straws... It turns out that the CDO.DLL was a reference and shouldn't have been. It was used for some old code that was removed. We are both using Office 2003. What library is needed that would not be registered? It's a pretty fresh install of 2003. It didn't work on her previous computer either which was built just for her. On Feb 28, 4:38 pm, "Ken Slovak -...
Catching an Explorer event too early...
elandau1@gmail.com
0 / 1 28 Feb
Reposting with a new subject-line since my search has now progressed to suspecting I'm catching an event too early: I created an Explorer class which triggers on the SelectionChange event. For each event 1) If myLastInboxItem is not nothing, move it to an Archive folder 2) set myLastInboxItem = ExplorerClass.Selection.Item(1) ... Of course, I need to make sure the email I was...
Multiple copies of message in archive file
reader
0 / 3 28 Feb
Thank you! I will use this method of accessing the archive from now on. No training here so have been figuring things out on my own. "Sue Mosher [MVP-Outlook]" wrote: > Importing an archive file is never a good idea. Instead, open it with the File | Open | Outlook Data File command. It will appear in the Folder List navigation pane as a separate information store with its own folder...
Display VB form on Outlook Word Email Editor
Ashok
0 / 1 25 Feb
Hi All, I am developing Com Addin for outlook using VB 6.0. If the outlook email editor is word(OL 2003), I am unable to pop up my form on the current inspector, it always goes to the outlook explorer. Could anyone of you guide me how to achieve the same? I'm able to display my form, if the editor is normal. Your prompt reply would be appreciated. Thanks & Regards...
objShell.BrowseForFolder dialog - how to use file shortcuts
Ken Slovak - [MVP - O...
0 / 10 25 Feb
What kind of form is that? Is it a VBA UserForm or what? hInstance is a value for the instance handle for that instance of your form, just as hWnd is the window handle for that window when it opens. Both are transient values that are only valid for that invocation of your form. You can just omit the line for setting the hInstance if you aren't using it. VBA UserForms don't provide a...
Caching policy for emails in IMAP account
Darshan
0 / 1 25 Feb
Hello, I have configured an IMAP account in my Outlook 2003. I have observed that some of the emails in the IMAP account are still accessible in Outlook, even when i am not connected to the network. This does not happen always, and each time a different set of emails is accessible. This leads me into thinking that Outlook is caching some of the emails according to some policy like:...
VBA macro not scanning entire Inbox
Sue Mosher [MVP-Outlook]
0 / 2 24 Feb
You should never delete items inside a For Each ... Next loop. Instead, use a down-counting loop: count = Inbox.Items.Count For i = count to 1 Step -1 Set item = Inbox.Items(i) ' do stuff to item and if desired, then: item.Delete Next -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators...
Get outlook post item flag value
delfino.nunez@gmail.com
0 / 11 22 Feb
Yes it doesn't make sense to do a lot of work for so little and I don't want to make it to complicated. Thanks for all your help guys....
Follow a link in the body of an Outlook email message
Ken Slovak - [MVP - O...
0 / 2 22 Feb
If I understand what you said and what you're asking then you can retrieve the HTMLBody property of the email and parse the HTML to find your link and then use your favorite method of retrieving the file pointed to in the link and save it where you want. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007 Reminder Manager,...
Entry_Id for IMAP account emails
Darshan
0 / 1 22 Feb
Hello, Outlook internally uses a unique EntryId as an identifier for every item in Outlook. Every time Outlook synchronizes the emails in its IMAP account, is it possible that each item gets assigned a different EntryId? or does Outlook somehow remember what EntryId had been assigned to each item and makes sure that the same is reassigned? -- Darshan...
"Empty the Deleted Items folder upon exiting" setting
Frank S
0 / 3 18 Feb
Thank you....
inserting reminders into other users' calendars
Ken Slovak - [MVP - O...
0 / 2 18 Feb
If you have permissions on those calendar folders you can use the GetSharedDefaultFolder method to access those folders. Look in the Object Browser help for information on that method. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm...
Change view mode in OVC, html+vbcript
Christian Lafrance
0 / 1 17 Feb
Hello, I want to change view mode (day, 5 days, 7 days...) through command buttons in a HTML page. See code below. It gives me error in script - in status bar. Calendar shows up properly. Any idea? <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> <HEAD> <TITLE>View Control</TITLE> <META http-equiv=Content-Type content="text/html;...
Starting Outlook from MSAccess
Ken Slovak - [MVP - O...
0 / 15 15 Feb
There are lots of things you can't do with Outlook that people want. Some of them we've figured out workarounds for, others just can't be done. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm "Kathy Webster" <slickdock@yahoo.com>...
How to close outlook application when running
Ken Slovak - [MVP - O...
0 / 2 14 Feb
Look up the help for GetObject and how to use it to get an instance of a running application. If it is running call the Outlook.Application.Quit method. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm "Phefos"...
How can I declare an object to match all items in my inbox?
JP
0 / 7 13 Feb
...
Trying to interact with Outlook from Windows Service
Ken Slovak - [MVP - O...
0 / 2 13 Feb
The Outlook object model is not supported for use in a service. You really don't want to do that. Use something else like CDOSys (if that's supported for managed code). You'll have to research that, I'm not familiar with CDOSys. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007 Reminder Manager, Extended Reminders, Attachment...
Changing account selection after typing an email wipes out email
Kathy Webster
0 / 4 13 Feb
You are right. Thanks! "Michael Bauer [MVP - Outlook]" <mb@mvps.org> wrote in message news:1p9f4079hkuti$.12aw3fuaojkxa.dlg@40tude.net... > > > Maybe this helps: Please ask again in microsoft.public.outlook.general as > this seems to be no VBA question. In *.general the people know better > those > things. > > -- > Best regards > Michael Bauer - MVP Outlook > Use Outlook...
GetDefaultFolder(olFolderInbox) question
landau@skiz.net
0 / 3 13 Feb
Awesome. Thanks so much ! -Ed...
Explorers or Inspectors... Which to use to catch my event?
landau@skiz.net
0 / 3 12 Feb
Yup... I had that idea overnight and it worked. Thanks a lot for confirming this is the way to go. Now I just have to figure out which object to declare to cover all items in my inbox (which are not all mailItems)... but I posted a different thread on this :). Thanks again, -Ed...
Create a rule or function that will open a file
Ken Slovak - [MVP - O...
0 / 4 12 Feb
Outlook doesn't have VBA addins. COM addins are developed from scratch using a language that supports COM addins such as VB6, VB.NET, C#, C++, Delphi, etc. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm "scott56hannah"...
Macro to add date automatically to MEETING INVITE
Ken Slovak - [MVP - O...
0 / 2 11 Feb
Well for one thing msg isn't assigned to anything so you're trying to add to the Body of a null object. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm "nemadrias" <spovolny@gmail.com> wrote in message...
CDO Error
Ken Slovak - [MVP - O...
0 / 2 11 Feb
CDO 1.21 is subject to even stronger security than the Outlook object model and has been since the Outlook 2000 SP2 days. Just accessing a Message object in a Contacts folder fires the CDO security. It looks like you're using Redemption, use that instead of CDO to access the restricted information. Switch over to Redemption to get the message and use Redemption methods from there to...
Halting warning display for own macros
Ken Slovak - [MVP - O...
0 / 3 11 Feb
Sign your VBA code project. If you don't have a code signing signature you can use the selfcert.exe program that comes with Office to create a certificate and use that. To do so once you have a certificate you select Tools, Digital Signatures in the VBA project. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007 Reminder Manager,...
Speed of VBA move vs manual move, for emails moved to Public Folders
Ken Slovak - [MVP - O...
0 / 2 08 Feb
The Outlook code is using Extended MAPI, which is at least 10 times faster than using the Outlook object model from VBA, maybe more. Unless you write your code using C++ or Delphi and Extended MAPI you won't be able to reproduce the speed with which Outlook moves things. There are optimization tricks that can speed things up some, but you always will be limited by using the object...
How to install Microsoft Office Document Imageing on Windows 2003(x64), when ...
Ken Slovak - [MVP - O...
0 / 2 08 Feb
How is this an Outlook question, and why are you posting it in multiple Outlook newsgroups? Pick a more appropriate newsgroup for your question. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm "DR" <softwareengineer98037@yahoo....
Outllok favorites view
Ken Slovak - [MVP - O...
0 / 2 07 Feb
Set myAPF = myNS.Folders("Public Folders").Folders("Favorites") That will get you to Favorites. Get the Folders collection of Favorites and iterate that collection to list all folders in Favorites. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech....
How: Outlook2007 Preview
Michael Bauer [MVP - ...
0 / 3 07 Feb
You must store the attachment as a file. Then you use the file's standard application to display it by calling: Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long ShellExecute 0, "open",...
IncludeRecurrences 2003 vs 2007
bluesbrthr@gmail.com
0 / 15 05 Feb
On Feb 5, 4:32 pm, bluesbr...@gmail.com wrote: > On Feb 5, 4:23 pm, bluesbr...@gmail.com wrote: > > > > > On Feb 5, 3:57 pm, "Sue Mosher [MVP-Outlook]" <sue...@outlookcode.com> > > wrote: > > > > I think the problem is that you're doing filtering twice and using IncludeRecurrences only on the second filter. You only need to filter once: > > > > Dim filter1 As String > > > filter1 =...
Outlook Appointments & Meetings
Ken Slovak - [MVP - O...
0 / 2 02 Feb
For that you need an autoaccept script or agent running in Exchange on that resource mailbox. You should post this question to an Exchange group, perhaps microsoft.public.exchange.applications. Specify your Exchange version and setup when you post there. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007 Reminder Manager,...
Rule not executing
Michael
0 / 1 01 Feb
I have a rule that reads: Apply this rule after the message arrives sent to "Terminations" and with "Termination Notification" in the subject move it to the "Terminations" folder Everything in quotes are the instructions the rest is the standar label applied by Outlook. This rule was working fine until a few days ago. I do not get any errors or anything but the emails are not being...
How to get past the OutLook Busy DLG . . .
Ken Slovak - [MVP - O...
0 / 7 01 Feb
This is a multi-part message in MIME format. ------=_NextPart_000_0012_01C864DF.21B9F9E0 Content-Type: multipart/alternative; boundary="----=_NextPart_001_0013_01C864DF.21B9F9E0" ------=_NextPart_001_0013_01C864DF.21B9F9E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Right, you certainly don't want to try to have both ESM and Outlook on the...
All times are in (US) Eastern Daylight Time (GMT -4:00)