Re: how do i set up a macro in Outlook 2003 to track items%3f

From: Mike Anderson (MikeAnderson_at_discussions.microsoft.com)
Date: 02/04/05


Date: Fri, 4 Feb 2005 04:59:01 -0800

Sue, sorry for my apparent ignorance. I must admit, with Office apps
anyway, I am a little slow.
1. The form is published to the Personal forms library.
2. When looking at the message class of the form it simply says:
IPM.Note.USAFE Tasker.
3. I am not sure how to get to the information you are requesting (I can
zip the oft file and email it to you)
4. All users attach to a single organizational mailbox to update items.
5. The form creates a new entry in mailbox, increments a tracking number,
and tracks history, comments, and status. What is not happening is the saved
history function. there is an area to add comments for each update. when a
new update is made, the previous comment is added to history. this funciton
is not working.

"Sue Mosher [MVP-Outlook]" wrote:

> But are you actually using the published form? You said earlier that you
> were using a VBA macro. Then you said it was an .oft form template file. Now
> it sounds like you're just "pretty sure" it's a published form, and that it
> may be published in multiple locations (which has potential implications in
> Outlook 2003). I'm happy to try to help you resolve this, but we need to get
> a complete, accurate picture of the problem first:
>
> 1) Where is the form published?
> 2) What kind of form is it -- mail, contact, etc.?
> 3) What is the state of the "send form definition with item" box on the
> (Properties) page in design mode?
> 4) Where do the items that use the form reside -- in the user's mailbox, in
> other users' mailboxes, in public folders?
> 5) Does any code on the form run at all? If not, have you checked the
> possible causes of a one-off form? See
> http://www.outlookcode.com/d/formpub.htm#macro
> --
> Sue Mosher, Outlook MVP
> Author of
> Microsoft Outlook Programming - Jumpstart for
> Administrators, Power Users, and Developers
> http://www.outlookcode.com/jumpstart.aspx
>
>
> "Mike Anderson" <MikeAnderson@discussions.microsoft.com> wrote in message
> news:56E73809-F9C5-4BF9-A736-80B73EB455F7@microsoft.com...
> >I am pretty sure form has been published to the organizational forms
> >library.
> > Alternatiely, as was done in Exchange 5.5, the form is published to the
> > local personal forms library. The Outlook 2000 Security Roll-up broke the
> > form and Exchange/Outlook 2003 has only complicated it more.
> >
> > Short of redesigning the form from scratch, what can we do?
> >
> > "Sue Mosher [MVP-Outlook]" wrote:
> >
> >> Code doesn't run on one-off forms, which is what you get when you use an
> >> ..oft file.. You'll need to publish the form and use the published form
> >> to
> >> create the items.
>
> >>
> >>
> >> "Mike Anderson" <MikeAnderson@discussions.microsoft.com> wrote in message
> >> news:4656D94C-E5BF-417A-BF46-F93A13747193@microsoft.com...
> >> > Sue - it is actually a .oft file and I can send it to you to look at.
> >> > what
> >> > is not working is the a function which saves comments and notes
> >> > properly.
> >> > Really appreciate your expertise. I am flailing with these advanced
> >> > features
> >> > of Outlook, so thanks a bunch for your help!
> >> >
> >> > "Sue Mosher [MVP-Outlook]" wrote:
> >> >
> >> >> It might help if you explained in detail what functionality is lost.
> >> >> Without
> >> >> that, we're just guessing.
> >> >>
> >> >>
> >> >> "Mike Anderson" <MikeAnderson@discussions.microsoft.com> wrote in
> >> >> message
> >> >> news:77078047-00E1-48D6-93DB-6DD95C46D1DF@microsoft.com...
> >> >> > Thanks for the link. The real problem lies with corporate
> >> >> > requirement
> >> >> > to
> >> >> > upgrade to Outlook 2003 and Exchange 2003 from Outlook 2000 and
> >> >> > Exchange
> >> >> > 5.5.
> >> >> > The macro no longer functions properly.
> >> >> >
> >> >> > "Mike Anderson" wrote:
> >> >> >
> >> >> >> We are currently using a VBA macro to track taskers and documents
> >> >> >> using
> >> >> >> Outlook 2000. However, the security roll-up, and all subsequent
> >> >> >> SPs
> >> >> >> break
> >> >> >> the macro. We want to be able to automatically create a tracking
> >> >> >> number
> >> >> >> (incremented from the previous one), add comments and status, all
> >> >> >> from
> >> >> >> within
> >> >> >> Outlook.
>
>
>



Relevant Pages

  • Re: Newbie Question
    ... Only in an Exchange environment, ... Sue Mosher, Outlook MVP ...
    (microsoft.public.outlook.program_vba)
  • Re: how do i set up a macro in Outlook 2003 to track items%3f
    ... Sue Mosher, Outlook MVP ... All users attach to a single organizational mailbox to update items. ... >> and tracks history, comments, and status. ... >>> other users' mailboxes, in public folders? ...
    (microsoft.public.outlook.program_vba)
  • Re: MailItem.Reply
    ... Thanks for the advice, Sue. ... Sue Mosher, Outlook MVP ... -Reply to All with History ... I am attempting to prove to the big boss that ...
    (microsoft.public.office.developer.outlook.vba)
  • Outlook XP (2002) How to get a default signature for 2 diff profil
    ... We have a user (we'll call her "Sue" for right now) in one of our departments ... Sue has her own mailbox profile set up, ... recently been set up to be able to sign onto a department mailbox also. ... Now, if she closes out of Outlook, opens it up ...
    (microsoft.public.outlook.general)
  • Re: Adding public folder shortcuts to Favourites
    ... two highly used mailboxes into the top toolbar? ... > Sue Mosher, Outlook MVP ...
    (microsoft.public.outlook.general)

Quantcast