PC Review


Reply
Thread Tools Rate Thread

Custom Forms/Macros to Automate Journal Entry

 
 
omfie
Guest
Posts: n/a
 
      9th Jun 2004
I know everyone is probably tired of my Journal questions. I realize no-one
uses this (at least I don't see many questions about it here), but I think
it is a great tool, and could be much better with a few tweaks. Until MS
comes up with these tweaks, I will have to figure out how to come up with
them on my own/with everyone's help here.

Anyway....

I am looking for a way to create a macro that will open a journal entry,
make it for a specific type of entry, start the timer automatically when the
form is opened. For instance, I am placing a phonecall (bad example as the
journal entry default is phone call, but work with me). I run a macro
(maybe assign a button on the menu bar for this macro ?possible?) for this
specific type of task and the timer starts immediately. While I am placing
my call, I am filling in the info on the form (i.e. contact, subject, notes,
etc), but the timer is already running. Would also like to consider this
for other types of journal entries, such as a phonecall to a specific
contact, a task with a specific subject or category, etc. etc. Would be
great to use the standard journal form, just fill in specific info by
creating a macro/custom form, etc. etc.

I may be asking for alot, but would appreciate any input.

Thanks!

Tom Pratt
Office Manager
Florida Industrial Electric, Inc.
407.331.1551
(E-Mail Removed)


 
Reply With Quote
 
 
 
 
Sue Mosher [MVP-Outlook]
Guest
Posts: n/a
 
      9th Jun 2004
This is what your basic macro would look like:

Sub StartPhoneCall()
Dim objJournal As Outlook.JournalItem
Set objJournal = Application.CreateItem(olJournalItem)
With objJournal
.Type = "Phone Call"
.Start = Now
.Display
.StartTimer
End With
Set objJournal = Nothing
End Sub

If you're new to Outlook VBA macros, these web pages should help you get
started:

http://www.winnetmag.com/Articles/In...eID=21522&pg=1
http://www.outlookcode.com/d/vb.htm

Next time, please pick just one group to post in, instead of crossposting to
a lot of groups that aren't terribly relevant to your issue. FYI, there is a
newsgroup specifically for general Outlook programming issues "down the
hall" at microsoft.public.outlook.program_vba


--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"omfie" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I know everyone is probably tired of my Journal questions. I realize

no-one
> uses this (at least I don't see many questions about it here), but I think
> it is a great tool, and could be much better with a few tweaks. Until MS
> comes up with these tweaks, I will have to figure out how to come up with
> them on my own/with everyone's help here.
>
> Anyway....
>
> I am looking for a way to create a macro that will open a journal entry,
> make it for a specific type of entry, start the timer automatically when

the
> form is opened. For instance, I am placing a phonecall (bad example as

the
> journal entry default is phone call, but work with me). I run a macro
> (maybe assign a button on the menu bar for this macro ?possible?) for this
> specific type of task and the timer starts immediately. While I am

placing
> my call, I am filling in the info on the form (i.e. contact, subject,

notes,
> etc), but the timer is already running. Would also like to consider this
> for other types of journal entries, such as a phonecall to a specific
> contact, a task with a specific subject or category, etc. etc. Would be
> great to use the standard journal form, just fill in specific info by
> creating a macro/custom form, etc. etc.
>
> I may be asking for alot, but would appreciate any input.
>
> Thanks!
>
> Tom Pratt
> Office Manager
> Florida Industrial Electric, Inc.
> 407.331.1551
> (E-Mail Removed)
>
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Are their other Outlook Journal entry forms besides the standard? biblechlove@msn.com Microsoft Outlook Form Programming 1 18th Sep 2009 04:27 PM
How do I set custom journal entry types? NDExpat Microsoft Outlook Discussion 2 24th Mar 2009 03:11 PM
Creating a custom Entry Type in Journal smithwdoug Microsoft Outlook Discussion 2 16th Mar 2009 06:06 PM
Custom Forms/Macros to Automate Journal Entry omfie Microsoft Outlook 1 9th Jun 2004 06:11 PM
Custom Forms/Macros to Automate Journal Entry omfie Microsoft Outlook Discussion 1 9th Jun 2004 06:11 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:20 PM.