I have 4k journals that I have imported from excel 2003 (file format) into
outlook with the contact name in the beginning of the subject field (so all
journals are grouped by contact name followed by the subject and the person
who authored the journal). Now I would like to link each group of journals
to their respective contact. Is there a way to highlight all the journals
(e.g. 20 journals) and link them to their respective contact, without doing
them one at a time?

No, not without writing code for that.

You'd have to get the ActiveExplorer.Selection collection, iterate it and
for each member of the collection open it as a JournalItem, then get the
appropriate contact and add that contact to the Links collection of each
JournalItem, using the Links.Add() method which takes a ContactItem as an
argument.

--
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


"lightjag" wrote in message
...
I have 4k journals that I have imported from excel 2003 (file format) into
outlook with the contact name in the beginning of the subject field (so
all
journals are grouped by contact name followed by the subject and the
person
who authored the journal). Now I would like to link each group of
journals
to their respective contact. Is there a way to highlight all the journals
(e.g. 20 journals) and link them to their respective contact, without
doing
them one at a time?

Thanks for your answer. I know there is an issue with exporting and
importing outlook data and the links surviving the process. A method of
re-linking journals to their respective contacts (as you have described
below), I image would be of great use to many. But, unfortunately what you
have described below, sounds like Chinese to me (I have limited VBA
experience in Excel, and none in Outlook).

If there is someone on this broad that knows VBA backwards and forwards, I
image this would be a FUN project to test your skills on (and seeing that it
is probably a slow week leading up to July 4) and would be greatly
appreciated by those who are not as advanced and would be a great learning
experience as we analyze how the problem was solved.

Thanks in advance to anyone willing to take on this challenge -- Lightjag


"Ken Slovak - [MVP - Outlook]" wrote:

No, not without writing code for that.

You'd have to get the ActiveExplorer.Selection collection, iterate it and
for each member of the collection open it as a JournalItem, then get the
appropriate contact and add that contact to the Links collection of each
JournalItem, using the Links.Add() method which takes a ContactItem as an
argument.

--
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


"lightjag" wrote in message
...
I have 4k journals that I have imported from excel 2003 (file format) into
outlook with the contact name in the beginning of the subject field (so
all
journals are grouped by contact name followed by the subject and the
person
who authored the journal). Now I would like to link each group of
journals
to their respective contact. Is there a way to highlight all the journals
(e.g. 20 journals) and link them to their respective contact, without
doing
them one at a time?