outlook 2007 attach multiple journals to same contact

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lightjag - 29 Jun 2009 20:36 GMT

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?

Reply to this Message

Ken Slovak - [MVP - Outlook] - 30 Jun 2009 13:51 GMT

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.

Signature

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

>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
[quoted text clipped - 7 lines]
> doing
> them one at a time?

Reply to this Message

lightjag - 30 Jun 2009 15:50 GMT

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

> No, not without writing code for that.
>
[quoted text clipped - 15 lines]
> > doing
> > them one at a time?

Reply to this Message