Custom Forms/Macros to Automate Journal Entry

O

omfie

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 address removed)
 
S

Sue Mosher [MVP-Outlook]

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/Index.cfm?ArticleID=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top