outlook 2007 attach multiple journals to same contact

Status
Not open for further replies.
L

lightjag

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

Ken Slovak - [MVP - Outlook]

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.

"lightjag" <lightjag> wrote in message

news:6B538B3B-39C6-43A7-97A5-5A6DF3D7C912@microsoft.com...
> 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?
>
 
L

lightjag

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

> >

>

> "lightjag" <lightjag> wrote in message
> news:6B538B3B-39C6-43A7-97A5-5A6DF3D7C912@microsoft.com...
> >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?
> >


>
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
L Can't attach files in Outlook 2007 Using Outlook 2
K Attach addin to outlook 2007 editor Outlook VBA and Custom Forms 3
S Re: Cannot attach a file to an Outlook 2007 template after installingOffice 2007 SP2 Outlook VBA and Custom Forms 3
S Outlook 2007 crash linked to gdiplus.dll Using Outlook 0
S Outlook 2007 - Automatic purge fail Using Outlook 0
J outlook 2007 doesn't let me choose which .pst to search Using Outlook 2
D Outlook 2007 vs. Outlook 2010 -- ToDo Bar Using Outlook 0
D Outlook 2007 on 365 Using Outlook.com accounts in Outlook 2
S Macro for other actions - Outlook 2007 Outlook VBA and Custom Forms 23
S Verwendung von Outlook 2007 Using Outlook 0
A Arthur needs help with 2007 Outlook e-mail Using Outlook.com accounts in Outlook 3
M PST import from Outlook 2007 to 2010 - Address Book contacts all in 1 group Using Outlook 4
S outlook 2007 calendar search Using Outlook 6
B Migrate Outlook 2007 to Office 365 Using Outlook 3
X I have met my waterloo trying to resolve embedded graphics problem with outlook 2007 and now 2016 Using Outlook 1
R Outlook 2007 only loads some appointments Using Outlook 0
C Move Outlook 2007 to new PC with Outlook 365 Using Outlook 3
J Outlook 2007 Hide Messages Option not Available Using Outlook 2
S Outlook 2007 Calendar instant search problem. Windows 7 Using Outlook 4
S Outlook 2007 Calendar instant search problem. Windows 7 Using Outlook 0
B Server errors Outlook 2007 Using Outlook 1
S Reboot of frozen windows7 results in changed outlook 2007 settings Using Outlook 1
S Outlook 2007 printing wrong email address at top of page Using Outlook 8
M Configure outlook 2007 to accept digital signatures Using Outlook 2
D Outlook 2007 crashes when opening an email Using Outlook 2
R New chap saying hello and needing advice on Outlook 2007 thumbnails Using Outlook 3
icacream From Outlook 2007 to 2016 ! Using Outlook 9
vodkasoda Object could not be found Error in Outlook 2007 Outlook VBA and Custom Forms 5
S Outlook 2007: Address Cards allow entering text! Why? Using Outlook 3
S View Appointment in Text Wrap in Outlook 2007 Month Calendar View Using Outlook 0
L Outlook 2007 Separate the Send/Receive functions Using Outlook 2
M Outlook 2007 Contacts Glitch: Creating a new email Using Outlook 1
C Move from Outlook 2007 Enterprise (MOE) to Outlook Pro plus 2007 Using Outlook 1
J reinstalling Outlook 2007 asking for user name & password Using Outlook 14
P outlook addin unloaded in office 2007 Using Outlook 0
B Fonts in Outlook 2007 Using Outlook 4
R Add Exchange Account to existing POP3 Outlook 2007 Profile Using Outlook 0
C out of space in file group Outlook 2007 Using Outlook 2
A Moving archived contents in Outlook 2007 back into working folders Using Outlook 0
P Outlook 2007 Email Categorization using VBA Outlook VBA and Custom Forms 1
M Unable to Configure Gmail Account in Outlook 2007 Using Outlook 1
R Outlook 2007 or 2010 - Lock Down Functionality Outlook VBA and Custom Forms 3
S Outlook 2007, windows 10 Font size Using Outlook 1
Diane Poremsky Manually create a POP3 account in Outlook 2007 New Slipstick.com Articles 0
J Can Click to Drag Custom Form Field But Cannot Drop When Designing in Outlook 2007 Outlook VBA and Custom Forms 2
L Outlook 2007 Font Using Outlook 3
J Outlook 2007 connector and Windows 10 Using Outlook 3
R Outlook 2007 - Shared Accounts and Resources without Exchange Server Using Outlook 0
L Outlook 2007 - Macro Re Search Using Outlook 16
D Outlook (Office) 2007 & Windows 10 Pro Using Outlook 6

Similar threads

Top