microsoft.public.outlook.program_vba Google Group

How to clear categories

donwms.3ur...@no-spam.invalid (donwms) — Fri, 03 Jul 2009 20:23:44 UT

In OL 2003, from a rule, I'm trying to run a script:
Sub ClearCategories(ObjMsg As Outlook.MailItem)
ObjMsg.Categories = ""
ObjMsg.Save
End Sub
I know that the rule is running, but the Categories are not being
cleared.
Any idea what I'm doing wrong?
Thanks, Don Williams

Re: Copy Entire Email Content - Paste into new Task

sue...@turtleflock.com (Sue Mosher [MVP]) — Fri, 03 Jul 2009 15:17:30 UT

Actually, that won't do what everything that Kolz describes and seems to
want, because the Body property contains only plain text, not the pictures
and formatting. I've posted a new code sample at
[link] that copies the full
formatted body from one Outlook 2007 item to another, taking advantage of

Re: the default position of the find dialogue is appearing off the scr

kenslo...@mvps.org (Ken Slovak - [MVP - Outlook]) — Fri, 03 Jul 2009 13:11:33 UT

You might want to post this in a Word group and not an Outlook group.

Re: Changing calendar views

kenslo...@mvps.org (Ken Slovak - [MVP - Outlook]) — Fri, 03 Jul 2009 13:10:39 UT

No way to do that in Outlook 2003. That's not exposed to the object model.
In Outlook 2007 you could use the new CalendarView.DisplayedDates property
to let you know which dates were currently visible in the UI.

Re: Reply forms

sue...@turtleflock.com (Sue Mosher [MVP]) — Fri, 03 Jul 2009 13:00:13 UT

Unless you can publish a custom Outlook form to the Organizational Forms
library on your Exchange server, a custom Outlook form is not a viable
solution for data gathering. Consider using Microsoft InfoPath, a web page,
or a survey generated by Access 2007+Outlook 2007.

How can I copy incoming messages to a msg file using a rule?

t...@discussions.microsoft.com (Tony) — Fri, 03 Jul 2009 11:38:00 UT

Re: Run script rule not exectued for first few mails

luc...@newsgroup.nospam (Luc) — Fri, 03 Jul 2009 08:26:56 UT

I think I just /may/ have thought of a solution, but as there are no mails
waiting on the server when I start Outlook now, I'll have to wait until
monday to see if it works.
The solution would be to create an Application_Startup script with just
some dummy code that doesn't really do anything, except being there.

Reply forms

mar...@discussions.microsoft.com (Martin) — Fri, 03 Jul 2009 08:16:04 UT

Hello VBA masters,
I'm tryin to find a solution how to cllect data from many users efficiently.
Regullary I have to ask round 50 users and they reply by E-mail. I want to
process their responds automatically in an excel file and track who has
replied and who not.
I was thinking about some forms that would contain fields where the

Re: Addin to trap email item open

dmi...@dimastr.com (Dmitry Streblechenko) — Fri, 03 Jul 2009 06:54:31 UT

Look at the Application.Inspectors.NewInsp ector event. It will not let you
cancel the action.
You can also trap the MailItem.Open event (which is canceable), but that
means that you will need to set an an event handler on each selected
messages and track the selection by using the Explorer.SelectionChange

Re: Recipient's SMTP address

dmi...@dimastr.com (Dmitry Streblechenko) — Fri, 03 Jul 2009 06:49:31 UT

Firstly, instead of reading the To property, you need to loop through the
Recipients collection.
Secondly, ff you were using Outlook 2007, you could read the
Recipient.AddressEntry.GetExch angeUser.PrimarySMTPAddress property.
In older versions of Outlook your only choice is either Extended MAPI (C++

Re: Addin to trap email item open

ashutosh_jogda...@persistent.co.in (Ashutosh Jogdande) — Fri, 03 Jul 2009 06:49:24 UT

Hi John,
You can achieve this by handling Application.ItemLoad event,
in this you can look for MailItem as an Objet type, if it is then handle
MailItem's Open event.
Thanks,
Ashutosh

Run script rule not exectued for first few mails

luc...@newsgroup.nospam (Luc) — Fri, 03 Jul 2009 06:47:59 UT

I recently replaced a number of rules for routing incoming mails to
different folders by a single 'run script' rule, and wrote a more refined
version of the filters in VBA (in O2007).
Now, every morning when I start up outlook, the script is skipped for the
first handful of mails that are already waiting at the mail server (mails

Re: Drag and Drop mails from Outlook to Clarion6 Application

dmi...@dimastr.com (Dmitry Streblechenko) — Fri, 03 Jul 2009 06:34:25 UT

If you can access the Outlook Object Model in Clarion, you shoudl be able to
loop through the items in the Application.ActiveExplorer.Sel ection
collection and call SaveAs for each item.

Re: MailItem from an RSS feed

d...@discussions.microsoft.com (Dan) — Fri, 03 Jul 2009 02:43:01 UT

Sue,
Thank you. You solved my problem.
Dan

Re: MailItem from an RSS feed

sue...@turtleflock.com (Sue Mosher [MVP]) — Fri, 03 Jul 2009 01:46:40 UT

This is the problem statement:
Dim Message As Outlook.MailItem
It makes an assumption that all items being processed are MailItem objects.
If you use Object instead of MailItem for the declaration, your code should
still work fine.
Also, you should not delete messages inside a For Each ... Next loop.